Re: MS Access Linked Tables under SQL 2005 x64?

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@xxxxxxxxxxxx

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

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

"Ohio Tom" <Ohio Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93D26725-198C-4CB0-97E0-EA7BE8E11C36@xxxxxxxxxxxxxxxx
>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
> providers on the system?


.

Relevant Pages
Loading