32 and 64 Bit SQL 2005 on Same Server

25 pts.
Tags:
Microsoft Access
SQL Server
SQL Server 2005
We need to still link to MS Access databases and understand the 64 bit SQL Server does not allow. So, a thought is to have the new 64 bit SQL Server coexist with a 32 bit SQL Server Express instance. The thought is the 32 bit instance will enable linked server access to MS Access databases. We would then link the 64 bit instance to the 32 bit Express instance. Does this seems like a plausible solution? Does SQL Server 2008 remedy this problem? Thanks in advance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes you can do this.

No SQL 2008 wouldn’t fix this problem. The problem isn’t a problem with SQL Server, but a lack of 64bit Jet drivers. The Jet driver is the ODBC driver which you use to talk to the Access database. The Jet driver is only available in a 32bit driver at this time. Hopefully with the release of Office 2010 next year this will change as a 64bit version of Office will be available.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MxPerry
    Ok. Thanks for the response. Is it possible to run a 32 bit AND 64 bit instance of SQL Server 2005 on the same server? We would then just like the two servers together to exchange data. This will allow the old 32 bit drivers to continue to work. Make sense or am I just smoking crack? Thanks in advance.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following