Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: How to connect Ms Access Database in Qlikview Script

Hi Amol,

Follow the thread.

Connect to Ms Access files?

tresesco
Not applicable

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
Not applicable

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 OLEDBSmiley Frustratedystem database="";Jet OLEDB:Registry Path="";Jet OLEDBSmiley Very Happyatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBSmiley Very Happyatabase 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 OLEDBSmiley Very Happyon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDBSmiley FrustratedFP=False];

vikasmahajan
Not applicable

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