Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

How to connect Ms Access Database in Qlikview Script

Hi,

I want to load Ms Access database in Qlikview Script Editor. But, when I connect to ODBC, it asks to user id and password for Data Source.

Please suggest the same that how to load such database.

Regards

Amol Khochare

Tags (4)
5 Replies
ashwanin
Valued Contributor

Re: How to connect Ms Access Database in Qlikview Script

Hi Amol,

Follow the thread.

Connect to Ms Access files?

MVP
MVP

Re: How to connect Ms Access Database in Qlikview Script

Have you already created the ODBC connection? If yes, you would have got an option for saving the password while created. Edit the connection string and enable that check and try again.

Not applicable

Re: How to connect Ms Access Database in Qlikview Script

Hi,

I have created the Ms.Access Database. But, while fetching the data in qlikview, it asks for User Id and Password.

Regards

Amol Khochare

vardhancse
Valued Contributor III

Re: How to connect Ms Access Database in Qlikview Script

once try to connect using OLE DB->Microsoft OLE DB Provider for ODBC Drivers

Click on next ->specify the source of data->enter user Id and password->test connection.

Then in script we can see connection string..

OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=(Path);Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

Highlighted
vikasmahajan
Esteemed Contributor

Re: Re: How to connect Ms Access Database in Qlikview Script

While creating ODBC  specify user and password , Then every time qv will not ask you the same.

Please see attached file.

Vikas