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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked servers

Status
Not open for further replies.
AccessSQLUser

AccessSQLUser

Programmer
Apr 23, 2001
101
US
I added a linked server to my SQLServer database. The linked server is basically a system DSN containing dbf files that are stored on the C: drive of my server. I was able to link the server and everything looks ok but then when I try to do a selection on one of the tables from the linked server (Select * from DatalineDBFs...AidHrs), I get the error:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.
 
Status
Not open for further replies.

Similar threads

BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
276
pjw001
pjw001
NBVC
  • Locked
  • Question
Finding IP address for a linked Oracle server 1
Replies
2
Views
395
NBVC
NBVC
malaygal
  • Locked
  • Question
How to bulk insert Access table into SQL Server temp table without setting up Linked Server 1
Replies
4
Views
560
malaygal
malaygal
grnzbra
  • Locked
  • Question
Syntax Problem between Servers
Replies
2
Views
207
grnzbra
grnzbra
Cpreston
  • Locked
  • Question
View loses Order By when linked to Excel 1
Replies
8
Views
282
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top