Connect ODBC

Click New on the Connection menu.

Select Connection ODBC.

In this example we are going to establish an ODBC connection to a MS SQL Server database.

Connection name: assign a name.

Database source: Click the button.

Select Use connection string.

Click the Build button.

If you already have a valid DSN then select it.

To build a new DSN click New on the button.

Select a valid ODBC driver.

Enter the name of the file data source or click Browse.

Enter a description for the ODBC data source.

Select a valid Server name.

Select the authentication option.

Click Next.

Select the database.

Click Next.

To test the connection click Test Data Source... .

If the connection was established successfully you will receive a confirmation message.

Click Ok.

Enter the password for the Server database.

Click Ok to finish the ODBC setup.

User: enter the user id

Password: enter the database password

SQL dialect: define which SQL dialect to use. That should be consistent with the database Server version of your database.

Important!

Due to incompatibles, selecting the Auto SQL dialect might present various problems using the Auto SQL dialect with some database servers.

Please be sure to select the right SQL dialect for your connection.

Assign user groups with privileges to open objects from this connection.

Enable Offline mode: Learn more here

Select User Groups who can view the Connection: Assign user groups with privileges to open objects from this connection.

Click Ok to establish the connection.

Related

Connect to DB2