Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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