Post reply

64-bit Linked server to 32-bit Access File

  • January 17, 2013 at 2:25 pm

    #269377

    I have a SQL 2008 R2 64-bit Instance that needs a Linked Server to an Access 2003 (MDB) file.

    I've gotten this to work from SQLExpress 32-bit on my desktop but not from 64-bit on the Server. The complication seems to be that the Jet Driver works in 32-bit only. I've installed the AccessDatabaseEngine from Microsoft that allows me to set up an ODBC connection using ODBCJT.32, but this driver is not seen from the Linked Server Setup, and none of the options that are visible that I've tried create an object that can view the data in the access file.

    Has anyone dealt with this and how was it resolved?

  • January 17, 2013 at 2:44 pm

    #1578479

    I've had to deal with this sort of thing too. I couldn't resolve it nicely, so keen to see what works.

    Thanks

    Good luck.

  • January 17, 2013 at 2:47 pm

    #1578480

    i believe there is a bug in the ACE drivers which affects Access but not Excel, even if you've installed the 64 bit versions;

    there's a connect item on it with some work arounds requiring a DSN:

    http://connect.microsoft.com/SQLServer/feedback/details/587897/connecting-via-a-linked-server-to-an-access-2010-database-file

    also check out my recent post from a day or so ago on linked servers and how to force the 64 bit ACE drivers to be installed, even if 32 bit is already there:

    http://qa.sqlservercentral.com/Forums/FindPost1407497.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply