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!

  • 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: General network error

Status
Not open for further replies.

christer102

IS-IT--Management
Aug 15, 2007
17
US
I have a weird problem, I have created a linked server to a Dbase database. It works perfectly from SQL Server A, but not from SQL Server B. On SQL Server B, I am getting this error: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken

but only if I run the query for a specific Dbase table (prsp). However, if I run the exact same query (some Dbase server, same table), it is working.

select * from openquery(T15,'select * from prsp')TM

I have given full security access to the dbase files on the remote server. My SQL installation and SQL is running under the domain administrator account.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top