![]() ![]() You can also change the paths that unixODBC uses for its configuration files by changing some environment variables. | |Ĭhanging UnixODBC's Configuration File Paths You can verify that a DSN is properly configured with UnixODBC on Linux by using the isql utility.įor example, if the DSN is called MariaDB-server, then we can verify that it works properly by executing the following: $ isql MariaDB-server Verifying a DSN Configuration with UnixODBC on Linux However, MariaDB Connector/ODBC doesn't yet support this GUI interface for adding DSNs. UnixODBC also provides a GUI to add DSNs. See Parameters for connection string options. To connect with SQLDriverConnect, you would need to specify Driver= in the connection string along with your other connection parameters. To configure the Driver, you can use the odbcinst tool, which can add a configuration entry for MariaDB Connector/ODBC to the system's global /etc/odbcinst.ini file.įor example, create a template file similar to the following, with a name like MariaDB_odbc_driver_template.ini: ĭescription = MariaDB Connector/ODBC v.3.0Īnd then install it to the system's global /etc/odbcinst.ini file with the following command: sudo odbcinst -i -d -f MariaDB_odbc_driver_template.iniĪt this point, you should be able to connect to MariaDB by using the Driver with the SQLDriverConnect function. The first step is to configure UnixODBC to recognize MariaDB Connector/ODBC as a Driver. ![]() Configuring MariaDB Connector/ODBC as a UnixODBC Driver on Linux You will need to ensure that UnixODBC has been installed before you can perform these steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |