Sybase to SQL Server via linkserver

15 pts.
Tags:
Database connectivity
IBM AIX
Linked Server
ODBC
SQL Server 2005
SQL Server connectivity
Sybase 12.5.0.2
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...

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Seat
    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
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following