topic No Microsoft Access selection for OLE DB connection in QlikView

No Microsoft Access selection for OLE DB connection

zagzebski — Sat, 26 Apr 2014 16:53:14 GMT

I am trying trying to use an Access Database as a source for QlikView. When I choose OLE DB and hit "Connect" my list of "Providers" doesn't include a Microsoft Access connection. I know in the past I have seen this choice on other QlikView servers.

Can anyone let me know what needs to be done to make this selection available?

Thanks in advance,

Steve

Re: No Microsoft Access selection for OLE DB connection

MK_QSL — Sat, 26 Apr 2014 16:56:30 GMT

Open Control Panel

Administrative Tools

Data Source (ODBC)

User DSN

If there is no MS Access Database in User Data Sorce... try to Add by clicking on ADD BUTTON..

Hope this helps..

UPDATE :

To add MS Access Database ....

Go to System DSN tab

Add

Now Create New Data Source will open

Select Microsoft Access Driver (*.mdb)

Finish..

Now try to connect to MS Access Database....

Re: No Microsoft Access selection for OLE DB connection

Clever_Anjos — Sat, 26 Apr 2014 17:06:07 GMT

Maybe clicking "Force 32 bit" may force your Access Driver appear

Re: No Microsoft Access selection for OLE DB connection

maxgro — Sun, 27 Apr 2014 16:47:55 GMT

I usually found 32 bit (not 64) Access connectivity (also in 64 bit machine)

If you like oledb try (script editor)

If you like odbc you can check for Access driver in Qlik script editor

menu --> tools --> odbc administrator 32 bit --> driver tab

than follow Manish post