Connecting To Access Error

Anonymous — Mon, 08 Feb 2016 09:09:33 GMT

Hi,

I'm trying to connect to an access file, Time.accdb.

Connecting via oledb, force 32 bit enabled.

OLEDB CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=***PATH***Time.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;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;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False];

It works fine locally on my machine, but when put to the server, 11.2 sr12 it errors with the following:

08/02/2016 09:02:08: 0055 OLEDB CONNECT32*Provider*Password*Password*

08/02/2016 09:02:09: Error: ErrorSource: (null), ErrorMsg: Class not registered

08/02/2016 09:02:09: General Script Error

08/02/2016 09:02:09: Execution Failed

08/02/2016 09:02:09: Execution finished.

Bit stumped.

Any help gratefully accepted.

Re: Connecting To Access Error

johank — Tue, 21 May 2019 18:56:26 GMT

sorry for such a late reply but maybe the answer will help someone else than the poster...

I have had similar error messages when i have used a 32 bit connection string on a 64 bit server. ie changing from

"oledb connect32" to "oledb connect" solved this issue for me server side.

on my local machine i of course needed to continue with connect32

topic Connecting To Access Error in QlikView

Connecting To Access Error

Re: Connecting To Access Error