Connect to OLEDB

Click “New” on the Connectionmenu.

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.

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.