MS Access Linked Tables under SQL 2005 x64?
- From: "Ohio Tom" <Ohio Tom@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Apr 2005 08:14:08 -0700
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?
.
- Follow-Ups:
- Re: MS Access Linked Tables under SQL 2005 x64?
- From: Mike Epprecht \(SQL MVP\)
- Re: MS Access Linked Tables under SQL 2005 x64?
- Prev by Date: Re: Create DSN programmatically cannot set Port (VBA)
- Next by Date: Re: MS Access Linked Tables under SQL 2005 x64?
- Previous by thread: Re: Create DSN programmatically cannot set Port (VBA)
- Next by thread: Re: MS Access Linked Tables under SQL 2005 x64?
- Index(es):
Relevant Pages
|
Loading
