Connect to OLE DB

Click New on the Connection menu.

Select Connection OLE DB.

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

Connection name: assign a name.

Database source: Click the button.

Select the appropriate OLE DB driver.

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.

Select a valid OLE DB driver.

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

Click Finish.

Select the database to connect to.

Click Finish.

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

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

Click Ok.

Enter the Server database password and Click Ok.

Click Ok.

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.

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