NL_00


I have a linked server from Sql Server 2000 to Sybase Adaptive Server 12.5.1.

When i try to call a stored procedure on Sybase from Sqlserver i get the following message:

"could not execute procedure sp_who on remote server 'linked server name'(42000,7212)

command executed from sql server:

exec <linked_server>.<database>..sp_who

i am able to user open openquery for selects and inserts, successfully

Help appreciated

Thanks.




Re: Issue with Sql Server to Sybase linked server using stored procedure

Emanuel Peixoto


On your linked server you'll have to enable "data access" on the "server options"







Re: Issue with Sql Server to Sybase linked server using stored procedure

NL_00

On the sqlserver side , sp_helpserver on the linked server shows the following under status:

" rpc,rpc out,data access,collation compatible,use remote collation "

Tried a few varations from sqlserver:

select * from openquery (linked_server_test,"exec sp_who")

select * from openquery (linked_server_test,"exec xx") -> The proc xx does not exist on the sybase side

Both gives the same error as follows:

OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='Sybase.ASEOLEDBProvider', Query=exec xx'].

One of the developers mentioed that the remote stored procedure execution from SQLServer to Sybase is not supported. Works only for SQlserer -> Sqlserver






Re: Issue with Sql Server to Sybase linked server using stored procedure

Emanuel Peixoto

See this Microsoft article:

http://support.microsoft.com/kb/280102/en-us

Also make sure you are writing a full path of the object on openquery statement, including the owner.