ODBC for AC20

[ReignBough]

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."

[Ralph Wessel]

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

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

[ReignBough]

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

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

[Ralph Wessel]

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.

[Akos Somorjai]

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

[leceta]

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

[leceta]

ok. C++...