Discussion Board for collaboration on QlikView Scripting.
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.
Follow the thread.
Connect to Ms Access files?
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.
I have created the Ms.Access Database. But, while fetching the data in qlikview, it asks for User Id and Password.
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 OLEDBystem database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBatabase 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 OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDBFP=False];
While creating ODBC specify user and password , Then every time qv will not ask you the same.
Please see attached file.