ODBC Connection problem

Anonymous · ‎2010-04-29

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 · ‎2010-04-29

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

Thank you

Anonymous · ‎2010-04-29

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 · ‎2010-04-29

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

One of the forum moderators
AC 27 USA and earlier • macOS Ventura 13.6.6, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

Anonymous · ‎2010-04-30

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 · ‎2010-04-30

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

One of the forum moderators
AC 27 USA and earlier • macOS Ventura 13.6.6, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB

Find the next step in your career as a Graphisoft Certified BIM Coordinator!

ODBC Connection problem

Didn't find the answer?

Check other topics in this Forum

Read the latest accepted solutions!

Start a new conversation!