Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
iftikhar_aup
Contributor III
Contributor III
‎2017-05-15 05:34 AM

Qlikview and MS Access connectivity Problem(Not a valid password)

Hi

I am new to qlikview and want to access data from MS Accss database (.mdb) format.

i follow the following Steps

Step  1 :  Install AccessDatabaseEngine and AccessRuntime_x64_en-us

Step  2:  Create odbc conncection to my database  from script editor

              Connection String

ODBC CONNECT TO [MQTU;DBQ=Path\Database.mdb] (XUserId is JCTafQRMNLacWNC, XPassword is aRSBXRdNSLZEDSVOPbFB);

Step  3 : Now i load all the required tables from my database

Step  4: Now Click Reload button to load data form database and it give me an  error

SQL##f - SqlState: 42000, ErrorCode: 4294965391, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password.

if my password is wrong then how it load my tables

432 Views
0 Likes
0 Replies