CODEWITHSUNDEEP
sql-server-2008sap-aselinked-server
Christian
Christian

Reputation: 1

sql linked server 2008 with sybase 15.5 limits rows to 100

The following query always gives a resulset of 100 records (although there are many more).

select * from openquery (SybaseLinkedServer, 'SELECT F1, F2 FROM db.dbo.table where F1 in (120, 125, 126, 127) and F2 in (4,6,8)')

I tried to add TOP 10000 in both selects, with no result.

Linked server was setup in sql management studio 2012 on a 2008 database. ODBC driver for sybase-ase is 3.51 (sybase 15.5).

Does someone know a solution for this problem?

Many thanks in advance.

Upvotes: 0

Views: 136

Answers (1)

Avijit
Avijit

Reputation: 1229

I had similar issue. The root cause is that you've set up your linked server using ODBC instead of OLE DB.

Below link will help you to created db link to Sybase from Sql Server Mgnt Studio:

http://sql-articles.com/articles/dba/creating-linked-server-to-sybase-from-sql-server/

Upvotes: 1

Related Questions