topic Unrecognized database MS Acess format in QlikView

Unrecognized database MS Acess format

Anonymous — Tue, 02 Aug 2016 14:05:02 GMT

Hi ,

I am using Provider=Microsoft.Jet.OLEDB.4.0 ms access db

Connection string is:

OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\Sales\Sales.mdb;Mode=ReadWrite;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database 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 OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

Problem is: I can reload succesfully in local but while i try to reload in QMC the dashboard is failing with the following msg

OLEDB CONNECT32*Provider*Password*Password*

Error: ErrorSource: Microsoft JET Database Engine, ErrorMsg: Unrecognized database format '\Sales\Sales.mdb'.

Please help me

Re: Unrecognized database MS Acess format

marcus_sommer — Tue, 02 Aug 2016 14:14:23 GMT

You need to install the database-driver on your server, too. See for this: The Great ODBC Confusion.

- Marcus

Re: Unrecognized database MS Acess format

beck_bakytbek — Tue, 02 Aug 2016 14:15:52 GMT

Hi John,

You have a Provider: Microsoft Jet OLEDB 4.0 = MdB.format. but if you use accdb.Format you should use this Provider: Microsoft Office 12.0 Access Database Engine OLEDB.

tell me if you solve your issue

beck

Re: Unrecognized database MS Acess format

beck_bakytbek — Tue, 02 Aug 2016 14:19:39 GMT

for accdb format

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"

beck