by Scenario:
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
sources)
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
message:
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