sql server odbc: MS Access Linked Tables under SQL 2005 x64? -- sql server odbc

Re: MS Access Linked Tables under SQL 2005 x64?

Mike Epprecht (SQL MVP)
4/25/2005 12:00:00 AM

sql server odbc:

Hi

You may get a better answer by posting this question in the SQL Server 2005
Beta Newsgroups

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

MS Access Linked Tables under SQL 2005 x64?

Ohio Tom
4/25/2005 8:14:08 AM

I am running the 64-bit x64 version April CTP SQL Server 2005 under Windows
2003 Server x64 Edition. I am trying to create a Linked Server to a
Microsoft Access database, it does not show the Microsoft.Jet.OLEDB.4.0 as
one of the available providers.

I can programatically create the linked table by executing the
sp_addlinkedserver and specifying the 'Microsoft.Jet.OLEDB.4.0 provider, but
when I try to run a query against that linked server, I get the following
error message:

Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I would appear that SQL Server 2005 is only seeing the 64-bit OLE DB
providers. Is there a way to get it to recognize/use the installed 32-bit