topic Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password in QlikView

ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Wed, 25 Nov 2020 16:16:04 GMT

i am using Qlikveiw version 12.0 SR5 64 bit.

I want to retrieve data from MS Access database for which i follow the following steps.

Create and ODBC connection both 32 bit and 64 bit.

Now from the script editor i create connection ( both 32 bit (Using Force 32 bit option) and 64 bit ) to my database and load all the required tables from MS Access database.

"ODBC CONNECT TO [Database Name;DBQ=E:\QA Dashboard\MQTU\Database Name.mdb] (XUserId is BaQAYQRMNLacWGA, XPassword is aAdCWRdNSLZEDSVOPTEA);"

To create QVDs i write the following scripts for all tables.

store Table_Name into E:\Path....\Table_Name.qvd(qvd);

Now i click the "Reload " button to create QVDs but i give an error.

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

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Tue, 09 May 2017 07:53:02 GMT

Hi Iftikhar,

if you're using accdb. Format, then you can make the following steps:

step 1: SELECT "OLE DB " in the Database tab

step2: Check "force 32 Bit"

step3: Click "Connect"

step4: in the "Data Link Properties ". Select "Microsoft Office 12.0 Access Database Engine OLEDB Provider"

step5: Click "Next"

step6: You will be directed to "Connection Tab"

step7: Copy and paste the complete/full path of the Access Database ("E\.....\yourDatabase.accdb")

step8: Go to "Advanced tab", uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection tab" and click "Test Connection"

step10: then you will have a message : "Test Connection succeeded"

step11: Click "OK"

here is a way of proceeding in case of : MDB.Format

step1: Select "OLE DB" in the Database tab

step2: Check "force 32 bit"

step3: Click "Connect"

step4: in the "Data Link Properties", select "Microsoft Jet 4.0 OLE DB Provider"

step5: Click "Next"

step6: You will be directed to "Connection" tab

step7: Select the Database in 2002 Format(.mdb)

step8: Go to "Advanced" tab, uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection" tab and click "Test Connection"

step10: You will have message: like "Test Connection succeeded"

step11: Click "Ok"

i hope that helps

Beck

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Tue, 09 May 2017 08:05:25 GMT

Dear beck bakytbek thanks for reply

upon following your steps it give me an error again which is

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Tue, 09 May 2017 08:12:01 GMT

Hi Iftikar,

pleas mark as correct this content, then next time have another colleagues an easy access to right information

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Tue, 09 May 2017 08:18:00 GMT

Hi Iftikhar,

what of kind of datatype/format are you using? accdb or mdb?

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Tue, 09 May 2017 09:04:28 GMT

i am using .mdb format database

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Tue, 09 May 2017 09:12:43 GMT

Hi Iftikhar,

did you select in the "Data Link Properties", select "Microsoft Jet 4.0 OLE DB Provider"?

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Tue, 09 May 2017 09:29:32 GMT

Dear Back bakytbek

i follow the following steps

here is a way of proceeding in case of : MDB.Format

step1: Select "OLE DB" in the Database tab

step2: Check "force 32 bit"

step3: Click "Connect"

step4: in the "Data Link Properties", select "Microsoft Jet 4.0 OLE DB Provider"

step5: Click "Next"

step6: You will be directed to "Connection" tab

step7: Select the Database in 2002 Format(.mdb)

step8: Go to "Advanced" tab, uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection" tab and click "Test Connection"

step10: You will have message: like "Test Connection succeeded"

step11: Click "Ok"

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Tue, 09 May 2017 09:47:27 GMT

Iftikar,

have you solved your issue?

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Tue, 09 May 2017 09:53:43 GMT

Dear Back bakytbek

Still the problem is exist

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Tue, 09 May 2017 11:01:46 GMT

Iftikhar, what do you see in the step 4?, if you go in tab: Data Link Properties

step1: Select "OLE DB" in the Database tab

step2: Check "force 32 bit"

step3: Click "Connect"

step4: in the "Data Link Properties", select "Microsoft Jet 4.0 OLE DB Provider"

step5: Click "Next"

step6: You will be directed to "Connection" tab

step7: Select the Database in 2002 Format(.mdb)

step8: Go to "Advanced" tab, uncheck "Share Deny None" and Check "Read/Write"

step9: Go to "Connection" tab and click "Test Connection"

step10: You will have message: like "Test Connection succeeded"

step11: Click "Ok"

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Wed, 10 May 2017 04:28:33 GMT

Dear beck bakytbek

i exactly follow your steps

from the "Data link Properties " i select "Microsoft Jet 4.0 OLE DB Provider"

but it give me an error

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Wed, 10 May 2017 07:07:27 GMT

Hi Iftikar,

i have an idea, give me your example-file (mdb.with fake-data) or send on: bakytbeck@gmx.de. and when i solve it i will send to you back.

What do you think about it?

Beck

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

Anonymous — Wed, 10 May 2017 07:48:36 GMT

Hi!

I had the same problem for some years ago.

I dont know your PC configuration but I had a file .accdb.

I solved with:

- installation of Microsoft Access Database Engine 32 bit;

- use OLEDB;

- force 32 bit;

- use driver Microsoft 12 access OLEDB;

- so click "Next" and you need to write path, password, etc.

If you dont solve the problem is it possible to have a sample of accdb (or mdb) file)?

Giuseppe

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

iftikhar_aup — Wed, 10 May 2017 10:42:24 GMT

Dear Giuseppe Gallina

my database is .mdb format in MS Access 2007

installation Microsoft Access Database Engine 32 bit and also 64 bit;

Create an odbc connection both 32 and 64 bit

From qlikview script editor connection has been created (in 32 bit Force 32 bit option is used)

Please Check connection string

"ODBC CONNECT TO [Database Name;DBQ=E:\QA Dashboard\MQTU\Database Name.mdb] (XUserId is BaQAYQRMNLacWGA, XPassword is aAdCWRdNSLZEDSVOPTEA);"

Now a load all the required tables from database

up to here everything is fine

But when i click "Reload " button to get data or create QVDs it give me an error that

ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

Anonymous — Wed, 10 May 2017 11:10:40 GMT

SO work fine the first time but not after. Version of Qlikview?

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Wed, 10 May 2017 11:12:49 GMT

Hi Iftikhar,

give me your database-example. i try to solve it

Beck

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

Anonymous — Wed, 10 May 2017 11:38:39 GMT

Good idea, I ask to have a sample two hours ago but I hasnt en answer...

It is very hard to guess.

Re: ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password

beck_bakytbek — Wed, 10 May 2017 11:50:02 GMT

We will see