|
Home > Archive > MS SQL Server ODBC > April 2005 > MS Access Linked Tables under SQL 2005 x64?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MS Access Linked Tables under SQL 2005 x64?
|
|
| Ohio Tom 2005-04-25, 11:23 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
providers on the system?
| |
| Mike Epprecht \(SQL MVP\) 2005-04-25, 8:23 pm |
| 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/
"Ohio Tom" <Ohio Tom@discussions.microsoft.com> wrote in message
news:93D26725-198C-4CB0-97E0- EA7BE8E11C36@microso
ft.com...
>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?
|
|
|
|
|