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

Add Windows ODBC DSN from command line / setup.

Hello,

I am using MariaDB Connector/ODBC 3.0.5 and trying to add a Windows ODBC DSN from command line with the following syntax:

odbcconf.exe CONFIGSYSDSN "MariaDB ODBC 3.0 Driver" "DSN=test|CONN_TIMEOUT=0|DATABASE=test|PORT=3306|SERVER=testserver"

But instead of creating a DSN it just shows the DSN configuration dialog.

When trying the same command with the MySQL ODBC driver it is working as expected.

odbcconf.exe CONFIGSYSDSN "MySQL ODBC 8.0 Unicode Driver" "DSN=test|CONN_TIMEOUT=0|DATABASE=test|PORT=3306|SERVER=testserver"

Also calling SQLConfigDataSource from odbccp32.dll with the above drivers results in the same behaviour (MySQL working, MariaDB showin dialog).

Am I missing parameters or is this way of creating a Windows ODBC DSN not supported?

Thanks for any input in advance.

Regards Florian

Answer Answered by Lawrin Novitsky in this comment.

Thank you for your question. This way of creating WIndows ODBC DSN was not tested. Since it does not work, there is probably a bug in the connector. And it's better to create an issue here https://jira.mariadb.org/ in project "MariaDB Connector/ODBC"

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.