topic Re: ODBC Connection problem in Archicad C++ API

ODBC Connection problem

Anonymous — Thu, 03 Aug 2023 09:49:28 GMT

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?

Re: ODBC Connection problem

Anonymous — Thu, 29 Apr 2010 11:05:53 GMT

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

Thank you

Re: ODBC Connection problem

Anonymous — Thu, 29 Apr 2010 11:30:49 GMT

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 ???

Re: ODBC Connection problem

Karl Ottenstein — Thu, 29 Apr 2010 19:04:39 GMT

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

Re: ODBC Connection problem

Anonymous — Thu, 29 Apr 2010 23:39:27 GMT

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

Re: ODBC Connection problem

Karl Ottenstein — Fri, 30 Apr 2010 00:56:25 GMT

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