topic Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password) in Connectivity & Data Prep

OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

iftikhar_aup — Fri, 02 Apr 2021 08:02:00 GMT

I want to conncect MS access 2007 database (.mdb ) format to Qlikview.

OLEDB

Step 1 : Install AccessDatabaseEngine and AccessRuntime_x64_en-us

Step 2 : Now open Script editor in Qlikview

Step 3 : From Database i select "OLEDB" tick mark "Force 32 Bit" and click "Connect"

Step 4 : Now select "Microsoft jet 4.0 OLE DB Provider" and move to Connection tab.

Step 5 : Now i enter database name password

(1) Path of database

(2) User name and password

and click "Test Connection " and get the following error

"Test connection failed becaues of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user".

ODBC

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

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

stabben23 — Thu, 18 May 2017 06:51:14 GMT

Hi,

Try this Connector, works for my .mdb files

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

iftikhar_aup — Thu, 18 May 2017 06:55:31 GMT

Thanks for reply Mr. Staffan Johansson

i am using the connector which you are specifying

Step 4 : Now select "Microsoft jet 4.0 OLE DB Provider" and move to Connection tab.

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

stabben23 — Thu, 18 May 2017 07:07:13 GMT

Ok, I'll missed that, sorry, Can you open the .mdb file in Your MS Access? Use a copy of Your original sourcefile.

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

iftikhar_aup — Thu, 18 May 2017 07:15:12 GMT

Yes i can open it

it is password protected

When i enter the password i can see all the tables and quires

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

stabben23 — Thu, 18 May 2017 08:04:52 GMT

Ok, and that password wont gives you premission to Connect to the .mdb file in Qlikview?

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

iftikhar_aup — Thu, 18 May 2017 09:12:07 GMT

ODBC

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

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

stabben23 — Thu, 18 May 2017 09:22:01 GMT

So you can Select tables With the OBDC connect, but when you try to reload script it fails?

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

iftikhar_aup — Thu, 18 May 2017 09:47:08 GMT

yes

Re: OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

stabben23 — Thu, 18 May 2017 09:54:36 GMT

Can you show the script?