topic Re: ODBC for AC20 in Archicad C++ API

ODBC for AC20

ReignBough — Tue, 06 Dec 2022 13:03:52 GMT

Where can I get the ODBC driver for AC20?

I tried the following (on AC20 add-on):

// ... more SQL initialization above
sqlRetCode = SQLDriverConnect(hdbc, hdesktop,
(SQLCHAR*)"DRIVER={Archicad 18 Project ODBC Driver}; PLANFILE=<file_loc>;",
_countof("DRIVER={Archicad 18 Project ODBC Driver}; PLANFILE=<file_loc>;"),
outConnStr, 255, &outConnStrLen, SQL_DRIVER_PROMPT);

...but got the following error...

"The procedure entry point ... could not be located in the dynamic link library GSRoot.dll."

Re: ODBC for AC20

Ralph Wessel — Tue, 27 Jun 2017 15:11:19 GMT

ReignBough wrote:
Where can I get the ODBC driver for AC20?

I believe it's discontinued – the last stable version was for AC18.

Re: ODBC for AC20

ReignBough — Wed, 28 Jun 2017 02:49:55 GMT

So, can it still be used on higher version of ArchiCAD?

BTW, I tried using it on AC18 but with the same error message.

Re: ODBC for AC20

Ralph Wessel — Wed, 28 Jun 2017 06:47:25 GMT

ReignBough wrote:
So, can it still be used on higher version of ArchiCAD?.

I strongly doubt that technology developed for one version of ARCHICAD (at the API level) will work on another. Someone from GS may be able to confirm that.

Re: ODBC for AC20

Akos Somorjai — Fri, 30 Jun 2017 10:43:19 GMT

Ralph wrote:
ReignBough wrote:
So, can it still be used on higher version of ArchiCAD?.
I strongly doubt that technology developed for one version of ARCHICAD (at the API level) will work on another. Someone from GS may be able to confirm that.

Ralph is right, the last ODBC driver was for AC18. The decay started in AC17 we the introduction of building materials.
Since then all of that code has been removed from the source as well.

Sorry, Akos

Re: ODBC for AC20

leceta — Sat, 04 Nov 2017 18:03:24 GMT

oh, this is bad news... are you planning any other technology to substitute SQL queries? I was studying the possibility to develop a GH component based on your ODBC driver (given that the driver was manageable using C#) in order to have a live link between my ACH model data and Grasshopper.

Do you have any suggestions of other approaches, preferably without the use of c++, this would be out of my capabilities...

thanks
aitor

Re: ODBC for AC20

leceta — Tue, 14 Nov 2017 20:22:19 GMT

ok. C++...