Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked server problem - four part name

Status
Not open for further replies.
rushdib

rushdib

Programmer
Jun 12, 2001
203
US
Hi,
I was able to link an Access 2000 database successfully to SQL Server 2000 as a linked server, but when I try to use the four part name in the stored proc, I get the following error.

Invalid use of schema and/or catalog for OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.
OLE DB error trace [Non-interface error].

Thank you,

Rushdi
 
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
158
petart
petart
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
168
okcorral
okcorral
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
283
markjoseph1232
markjoseph1232
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
229
johnb1023
johnb1023

Part and Inventory Search

Sponsor

Back
Top