How to create OLEDB Connection

[#1]

Hi all,

I am new to qlikview, please share me how to add a new OLEDB and ODBC connection in Qlikview.

OLEDB: How to create or add Microsoft Jet 4.0 OLE DB Provider to access MS ACCESS files.

ODBC: How to create a connection for Oracle10g database through ODBC Driver

Thanks,

Charan

[oknotsen]

This is one of the first topics discussed during a QlikView Developer training.

Find a training in your region here:

Search Page

Check if the Access DB is 32bit or not. If so, be sure to select "Force 32 bit".

For OLE DB, make sure OLE DB is selected and click on "Connect". Select the Jet driver and click next. Select the database, click test connection, and click OK.

Tada, you got yourself an OLE DB connection.