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

How to connect Ms Access Database in Qlikview Script

Fri, 28 Nov 2014 05:52:04 GMT

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

Re: How to connect Ms Access Database in Qlikview Script

ashwanin — Fri, 28 Nov 2014 06:03:49 GMT

Hi Amol,

Follow the thread.

Connect to Ms Access files?

Re: How to connect Ms Access Database in Qlikview Script

tresB — Fri, 28 Nov 2014 06:05:49 GMT

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.

Re: How to connect Ms Access Database in Qlikview Script

Fri, 28 Nov 2014 06:12:52 GMT

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

Re: How to connect Ms Access Database in Qlikview Script

vardhancse — Fri, 28 Nov 2014 06:23:58 GMT

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];

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

vikasmahajan — Fri, 28 Nov 2014 06:24:22 GMT

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

Please see attached file.

Vikas