You can connect to MariaDB databases in Exportizer using these ways:
- Opening through connection string. Select ADO interface, then choose Connection string option and write a connection string. This way is recommended for advanced users. Here is a connection string example (more examples and details can be found in the Internet):
DRIVER={MariaDB ODBC 3.1 Driver};SERVER=localhost;PORT=3306;DATABASE=myDatabaseName;UID=myUserName;PASSWORD=myPassword; (MariaDB ODBC Driver must be installed)
- Opening through ODBC DSN. Create (if it does not exist yet) an ODBC DSN of the corresponding type using Windows ODBC Data Source Administrator, and point it to your database. Then:
- Select FD interface, click ODBC, then point the Data source parameter to the ODBC DSN by selecting it from the drop-down list.
or
- Select ADO or BDE interface, then choose ODBC data source option and then select the needed ODBC DSN from the drop-down list.
- You can also try options available for opening MySQL. In most cases, they will work for MariaDB too, especially for older MariaDB versions, because MariaDB and MySQL DBMSs have common roots.
Attention
- This database type is supported only in Exportizer Enterprise and Exportizer Pro.
- MariaDB client must be installed. The bit-version of it (32 or 64) must match the bit-version of the application.
- MariaDB ODBC driver must be installed. The bit-version of it (32 or 64) must match the bit-version of the application.
Notes
- Each Exportizer edition has both 32-bit and 64-bit versions. You can install both and use them depending on what type of database you need to work with.
- You can invoke the ODBC Data Source Administrator directly from Exportizer when it was launched in administrator mode:
See also