The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Connecting issues with Mfc CDatabase

Hi

I have en application written in Visual Studio 2008 where I use CDatabase to connect to MariaDB via ODBC. When I try and connect I get an exception with the text "Invalid information type"

I have tried alot of ODBC connect strings for instance:

DRIVER={MariaDB ODBC 1.0 Driver};SERVER=localhost;DATABASE=mydb;UID=test;PWD=

or

DSN=mydb

When I create the DSN every think looks ok and if I change to use {MySQL ODBC 3.51 Driver} it works fine.

After some digging I found that it looks like it is because VS2008 use:

SQLGetInfo( SQL_ODBC_API_CONFORMANCE ...)

This was deprecated in "ODBC 3.x" but is there any chance this will be supported ?

I did a check and it looks like Visual Studio 2013 still use SQL_ODBC_API_CONFORMANCEl.

Thanks for your help.

/Kennet

Answer Answered by Ian Gilfillan in this comment.

This looks like it was fixed in ODBC-15

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.