Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, I was looking for the same issue and I got to your post (btw, new to these things as well).
I think I just managed to solve my issue. I am using a test MS Access DB in .accdb format and 64 bit system and QV12.
Here is what I have done:
- downloaded ODBC driver 64 bit from here, although I am still not sure if this was necessary or not Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Cen...
- installed driver: opened ODBC Data Sources Administrator (64-bit) > System DNS tab > Add button > selected Microsoft Access Driver (*.mdb, *.accdb) > in Data Source Name I typed a name for the connection, in Database I navigated to the location where I had my MS Access DB (mine was stored locally), in Advanced I typed the login name and password of the DB and on Options menu I checked "Exclusive" option.
- in QV I used ODBC option and then selected the connection I previously created and I set the same user and password I put when I created the ODBC connection.
I think that the trick for me was to select the Exclusive option; I tried running QV with a connection that didn't have the Exclusive option checked and it didn't work, got same error as you did.
Hope this makes sense and works for you.
Have fun,
Diana
Thank you