Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

32 bit SQL Server on 64 bit Windows 2012 ACE.OLEDB.12 Expand / Collapse
Posted Wednesday, October 30, 2013 10:01 AM


Group: General Forum Members
Last Login: Wednesday, July 8, 2015 1:10 PM
Points: 21, Visits: 117
I have a difficult situation trying to set up a linked server to access (no pun intended) some MDB files that we use to transfer report catalogs from our development location to the remote production server. The remote Windows Server 2012 is owned by a customer who does not want to open SQL Server up for direct remote access...thus the MDB files. We load the MDB files with table data, transfer them to our customer's server and then import them into the SQL tables with the linked server. We have 30 customer installations where this scenario works just fine.

However in this particular instance the customer has installed SQL Server 2012 STD 32-bit on the 64-bit Windows OS.

The Jet4.0 driver does not work in the 64-bit environment.
When I install the 64-bit Microsoft.ACE.OLEDB.12.0 driver and try to create the linked server, SQL Server does not recognize this driver as "registered".
When I install the 32-bit Microsoft.ACE.OLEDB.12.0 driver and then create the linked server, it fails to connect to the MDB in the same way that the Jet.4.0 driver fails.

Please Note: I have had success on servers where both SQL Server and Windows are 64-bit by using the 64-bit Microsoft.ACE.OLEDB.12.0 driver

I am assuming that this current issue is related to 32-bit SQL residing on 64-bit Windows.

Does anyone have any suggestions?
Post #1509853
Posted Wednesday, October 30, 2013 12:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 1:27 PM
Points: 3, Visits: 78
The 32 bit client should work just fine. How you determined this is not a network issue at all? Does ODBC connectivity work?
Post #1509913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse