christer102
IS-IT--Management
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
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