Sybase Pass Through query

shamas21

Registered User.
Local time
Today, 01:00
Joined
May 27, 2008
Messages
162
Hi
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

Code:
ODBC;DSN=xxxxx Sybase Server;UID=xxx;PWD=xxx;LANGUAGE=us_english;DATABASE=xxx

Code:
SELECT dbo_action_log.* FROM dbo_action_log

However I get the following error message when I try to run the Pass Through query

Code:
ODBC -- call failed
[B][Microsoft]ODBC SQL Server Driver][SQL Server][/B]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?

Thanks
 

Users who are viewing this thread

Back
Top Bottom