Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


32 bit SQL Server on 64 bit Windows 2012 ACE.OLEDB.12


32 bit SQL Server on 64 bit Windows 2012 ACE.OLEDB.12

Author
Message
John Kotuby
John Kotuby
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 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?
alliedDBA
alliedDBA
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search