OleDB Connection

An OleDB connection can be used relative to the driver when you want to create for instance a connection on a SQL database or a Microsoft Access database or a personal geo database.

In this example a connection to a personal geo database (.mdb) is created. The name and the alias are defined for the OleDB connection. In the next step the connection to the database is created.

New OleDB connection

New OleDB connection

 

In the Properties dialog box of the data link, the database provider (e.g. Microsoft Jet 4.0 OLE DB Provider) and the connection (selection of the database) is defined.

_img60

Data Link Properties

Data Link Properties

 

When the connection is ready created it can be tested.

Testing connection

Testing connection

 

You can find more information about creating Connection Strings at http://www.connectionstrings.com/.