Home > IT Answers > Database > Sybase to SQL Server via linkserver
Seat
15 pts.
Q:
Sybase to SQL Server via linkserver
Sybase 12.5.0.2, SQL Server 2005, Linked Server, ODBC, IBM AIX, Database connectivity, SQL Server connectivity, Sybase connectivity
I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 12.5.0.2 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67
The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any error. Please note that there is no problem when I insert rows from SQL server to the SYBASE server
I appreciate any possible solutions...
ASKED: Mar 26 2009  9:27 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Mrdenny
49385 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
Run a trace and duplicate the problem. What shows up in the trace against the sybase server as the command that the SQL Server sent?
Last Answered: Mar 26 2009  8:47 PM GMT by Mrdenny   49385 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Seat   15 pts.  |   Mar 30 2009  6:14AM GMT

Thanks for the answer. I ran ODBC trace with no results.
I think that i have found an answer. I ran dbcc freeproccache and dbcc dropcleanbuffers before the select statements against SYBASE server and it works ok.
Apparently there is a bug in cache management is sql server when linkserver is involved