Sybase SQL Server 11
MS SQL Server 2000
Service Pack 2
System DSN (Sybase System 11 ODBC Driver v. 3.01.00.00)
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
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
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]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
by clicking in the linked server.
Any comments ??
Thanks in advance