MS SQL Server Linked Server And Sybase ODBC Driver

MS SQL Server Linked Server And Sybase ODBC Driver

Post by Adriano Merlott » Fri, 14 Dec 2001 09:44:07


Sybase SQL Server 11

MS SQL Server 2000
   Service Pack 2
   System DSN (Sybase System 11 ODBC Driver v.
to Sybase server
   Linked Server over the defined DSN using MSDASQL
(provider for ODBC data

A simple SELECT query in a ASP page, using the DSN in a
ADO connection,
works fine (so that I'm sure the DSN is OK).  But when the
same query is
adapted for execution through the linked server (and im
sure the query is
correct) over a MS SQL Server connection, I got the
following error

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: [INTERSOLV][ODBC SQL
Server driver][SQL
Server]ct_bind(): user api layer: external error: This
routine cannot be
called when the command structure is idle.]

In Enterprise Manager, I can see all the Sybase schema
information normally
by clicking in the linked server.

Any comments ??

Thanks in advance