topic Help! How to create a external sql connection? [Solved] in Archicad C++ API

Help! How to create a external sql connection? [Solved]

Anonymous — Tue, 01 Aug 2023 16:54:01 GMT

Hi all, im still new to ArchiCAD API so would like to ask for some help, a thank you in advance! Currently we trying to select data from our online MySQL server for our addon, was looking into odbc connection but sadly we can't find much information on how to create the connection to external sql server.

Re: Help! How to create a external sql connection?

ReignBough — Wed, 08 Jan 2014 07:26:08 GMT

I am currently using MySQL C++ Connector 1.1.3 to connect to external database.

Re: Help! How to create a external sql connection?

Anonymous — Sat, 18 Jan 2014 12:56:41 GMT

Thanks for the reply ReignBough.

I have tried using MySQL C++ Connector 1.1.3 but without much success yet. I included all the MySQL header and .lib files in my Visual Studio project Src folder, as well as including the BOOST C++ library( required by the MySQL connector ). While it compiled perfectly, when I test it with the AddOnTool it just gives the error "Undefined Release". I think it may have to do with the MySQL .lib or BOOST files not being included into ArchiCAD correctly?

Re: Help! How to create a external sql connection?

ReignBough — Tue, 21 Jan 2014 08:36:59 GMT

Here's what I did:
Open project property.

Add include directory of MySQL Connector to Configuration Properties > C/C++ > General > Additional Include Directories.

Add lib/opt directory of MySQL Connector to Configuration Properties > Linker > General > Additional Library Directories for release mode.

Add mysqlcppconn.lib to Configuration Properties > Linker > Input > Additional Dependencies for release mode. NOTE: Their documentation says that you should also include libmysql.lib but it is not found on the said directory.

Also, you need to install BOOST and add its main folder to Additional Include Directories.

Re: Help! How to create a external sql connection?

Anonymous — Tue, 04 Feb 2014 09:22:41 GMT

Thanks ReignBough we've got it working.