Altova XMLSpy 2024 Professional Edition

This example illustrates how to connect to a MariaDB database server through ODBC.

Prerequisites:

The MariaDB Connector/ODBC (https://downloads.mariadb.org/connector-odbc/) must be installed.

You have the following database connection details: host, database, port, username, and password.

To connect to MariaDB through ODBC:

1.Start the database connection wizard.

2.Select MariaDB (ODBC), and then click Next.

dbc_mariadb01

3.Select Create a new Data Source Name (DSN) with the driver, and choose MariaDB ODBC 3.0 Driver. If no such driver is available in the list, click Edit Drivers, and select any available MariaDB drivers (the list contains all ODBC drivers installed on your operating system).

4.Click Connect.

dbc_mariadb02

5.Enter name and, optionally, a description that will help you identify this ODBC data source in future.

dbc_mariadb03

6.Fill in the database connection credentials (TCP/IP Server, User, Password), select a database, and then click Test DSN. Upon successful connection, a message box appears:

dbc_mariadb04

7.Click Next and complete the wizard. Other parameters may be required, depending on the case (for example, SSL certificates if you are connecting to MariaDB through a secure connection).

 

Note:If the database server is remote, it must be configured by the server administrator to accept remote connections from your machine's IP address.

© 2017-2023 Altova GmbH