Sybase to SQLserver linkserver errors

Posted by George on Stack Overflow See other posts from Stack Overflow or by George
Published on 2009-03-24T12:39:37Z Indexed on 2010/03/30 17:03 UTC
Read the original article Hit count: 409

Filed under:

sybase

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...

Related posts about sybase

"Oracle", "Sybase", "SQL Server" vs just "SQL/JDBC" in the CV

as seen on Programmers - Search for 'Programmers'
How would you define a testable measure of the expertise that, if you're honest with yourself, lets you write in your CV words "Oracle", "Sybase", or "SQL Server" and not just "Relational Databases, SQL, JDBC" in your software developer's CV? What every XXX-developer (XXX - a vendor name) should know… >>> More
Limiting Sybase ASE 15 CPU usage on VM

as seen on Server Fault - Search for 'Server Fault'
I've set up a single CPU Sybase ASE 15.7 test/hobby/experimentation system on a Debian Squeeze x64 KVM VM. I notice the CPU load goes to 100% and stays there. Definitely not a Sybase guru, only interested to see if some programs I'm running work on the database. Looking at Sybase docs it seems ASE… >>> More
Php pdo_dblib - cannot find/unable to load freetds

as seen on Server Fault - Search for 'Server Fault'
Self-hosted box, RHEL 6 PHP 5.3.3 PDO installed freetds installed pdo_dblib - so far no luck installing My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate version php source code. I have tried a variety of methods and searched quite a bit for help on this topic… >>> More
Any alternative to Sybase Sql Advantage?

as seen on Stack Overflow - Search for 'Stack Overflow'
Sybase Sql Advantage is the default editor for the Sybase database. But it has lots of shortcomings, because it basically is what Notepad is for Windows users: Can't do multiple undo's Monochrome, text is black and background is white Can't see what character did you exactly paste from clipboard… >>> More
Constructing dynamic columns from parameters in Sybase

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to write a stored proc (SP) in Sybase. The SP takes 5 varchar parameters. Based on the parameters passed, I want to construct the column names to be selected from a particular table. The below works: DECLARE @TEST VARCHAR(50) SELECT @TEST = "country" … >>> More

Developer IT

Sybase to SQLserver linkserver errors - Developer IT

Sybase to SQLserver linkserver errors

sybase

Related posts about sybase

"Oracle", "Sybase", "SQL Server" vs just "SQL/JDBC" in the CV

Limiting Sybase ASE 15 CPU usage on VM

Php pdo_dblib - cannot find/unable to load freetds

Any alternative to Sybase Sql Advantage?

Constructing dynamic columns from parameters in Sybase

Categories cloud