ODBC Connection problem

[Anonymous]

Hi all
Have downloaded ArchiCAD 13, ODBC Driver.
Created simple plan, saved it.
Created ODBC connection, and now I try to connect to that plan.
Here is VBscript code:

Dim conn, rsObjectList
set conn = WScript.CreateObject("ADODB.Connection")
If not IsObject(conn) Then
WScript.Echo "connection: error"
WScript.Quit(-1)
End If

conn.Open "ArchiCad_Test" <- This is ODBC name, created in Control panel/ODBC, and here is error reported

Set rsObjectList = conn.Execute("select * from WALLS'")

This is error:
Line: 8
Char: 1
Error: Catastrophic failure
Code: 8000FFFF
Souce: Provider

Can someone explain how to make simple connection in VB or VBscript, please?

[Anonymous]

Have try with Excel (Get external data) but without success.
Is there someone who actually use Archicad 13 ODBC driver?

Thank you

[Anonymous]

jperic022 wrote:
Have try with Excel (Get external data) but without success.
Is there someone who actually use Archicad 13 ODBC driver?

Thank you

Does TRIAL version works with ODBC ???

[Karl Ottenstein]

jperic022 wrote:
Does TRIAL version works with ODBC ???

I've only used the ODBC driver with files produced by the commercial license. I do not know if the driver works with any other file versions. The various training guides contain commercial project PLN files, so you could try setting your ODBC connection to one of these sample files just to get your VBA code working. If you own Microsoft Access, that is the easiest way (no coding required) to link to an ODBC source and verify the connection.

Karl

[Anonymous]

Karl wrote:

jperic022 wrote:
Does TRIAL version works with ODBC ???

I've only used the ODBC driver with files produced by the commercial license. I do not know if the driver works with any other file versions. The various training guides contain commercial project PLN files, so you could try setting your ODBC connection to one of these sample files just to get your VBA code working. If you own Microsoft Access, that is the easiest way (no coding required) to link to an ODBC source and verify the connection.

Karl

Hi thank you
could you be so nice, and draw 2 walls, save it and post reply here?
Files on this site - http://www.graphisoft.com/education/training_guides/#MOD - (training guides) are about 600 - 700 MB !

Thank you

[Karl Ottenstein]

Nothing that large can be attached here. Sorry. You might contact your local reseller, which I believe is 3DArt.