Archicad C++ API
About Archicad add-on development using the C++ API.

ODBC for AC20

ReignBough
Enthusiast
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."
~ReignBough~
ARCHICAD 26 INT (from AC18)
Windows 11 Pro, AMD Ryzen 7, 3.20GHz, 32.0GB RAM, 64-bit OS
6 REPLIES 6
Ralph Wessel
Mentor
ReignBough wrote:
Where can I get the ODBC driver for AC20?
I believe it's discontinued – the last stable version was for AC18.
Ralph Wessel BArch
ReignBough
Enthusiast
So, can it still be used on higher version of ArchiCAD?

BTW, I tried using it on AC18 but with the same error message.
~ReignBough~
ARCHICAD 26 INT (from AC18)
Windows 11 Pro, AMD Ryzen 7, 3.20GHz, 32.0GB RAM, 64-bit OS
Ralph Wessel
Mentor
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 Wessel BArch
Akos Somorjai
Graphisoft
Graphisoft
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
Expert
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
Expert
ok. C++...