Verify successful installation also using the isql utility, for example:. Verify successful installation in the /.odbc.ini file.Odbcinst -i -s -h -f MariaDB_odbc_data_source_template.ini A sample “MariaDB_odbc_data_source_template.ini” could be: Create a template file for the Data Source Name (DSN).USER DATA SOURCES.: /home/anel/.odbc.iniĭriver=/usr/lib/x86_64-linux-gnu/libmaodbc.so $ odbcinst -jįILE DATA SOURCES.: /etc/ODBCDataSources Verify successful installation in /etc/odbcinst.ini file (this path is obtained by the config info /-j/ option, where drivers are installed in that predefined location). $ sudo odbcinst -i -d -f MariaDB_odbc_driver_template.ini Install the ODBC driver from the template file by running:.odb a file name and save it.Description = MariaDB Connector/ODBC v.3.1ĭriver = /usr/lib/x86_64-linux-gnu/libmaodbc.so Next screen, "Yes, register the database for me" (which may not be needed here) and "Open the database for editing", then Finish On the Data Source screen, select the data source you just set up, then OK On the ODBC Data Source Administrator screen, select the User Data Source you just set up, then OK. On the ODBC Microsoft Access Setup screen, type in Data Source Name, Description, and Select database, then OK On Create New Data Source screen, select a Microsoft Driver (among different drivers and languages), then Finish On the ODBC Data Source Administrator screen, select Add On the Data Soure screen, select Organize On Database Wizard sceen, it asks the name of the ODBC data source on your system. There are good explanations here: How to Connect to a Microsoft Access DatabaseĬonnect to an existing database, choose ODBC, then Next Well, in my particular case, the answer was to open the 2003 Access database with ODBC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |