I was wondering if someone can help me with a passthrough query.
1) I have setup an ODBC connection on my system from my Sybase Server
2) I have tested this connection by linking some tables via OSBC from the Link Table manager
3) I have set up the connection correctly in the properties section of the query window to produce a Pass Through Query
ODBC;DSN=xxxxx Sybase Server;UID=xxx;PWD=xxx;LANGUAGE=us_english;DATABASE=xxx
SELECT dbo_action_log.* FROM dbo_action_log
However I get the following error message when I try to run the Pass Through query
ODBC -- call failed
[Microsoft]ODBC SQL Server Driver][SQL Server]dbo_action_log not found. Specify owner.objectname or use sp_help ...... etc.
I notice that I need to do a Pass Through query to Sybase but is Pass Through queries exclusive to SQL Server only?