Symptom
This RPC calls work fine between two MSSQLserver but between MSSQLserver and ASE some of them fails.
This test are using SAP SDK OleDB Driver from SDK 15.7 SP110 version 15.7.0.1100.
select * from openquery(<RemoteServer>, 'exec sp_who')
select * from openquery(<RemoteServer>, 'exec sp_who ''2''')
exec ('tempdb.dbo.sp_who') at <RemoteServer>
exec ('tempdb.dbo.sp_who "2"') at <RemoteServer>
exec <RemoteServer>.tempdb.dbo.sp_who
exec <RemoteServer>.tempdb.dbo.sp_who 2
But between MSSQLserver to ASE some of this fails.
select * from openquery(ASE_BIG, 'exec sp_who')
select * from openquery(ASE_BIG, 'exec sp_who ''2''')
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ASEOLEDB" for linked server "ASE_BIG" reported an error. The provider did not give any information about the error.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "ASEOLEDB" for linked server "ASE_BIG".
exec ('tempdb.dbo.sp_who') at ASE_BIG
exec ('tempdb.dbo.sp_who "2"') at ASE_BIG
Works fine...
exec ASE_BIG.tempdb.dbo.sp_who
exec ASE_BIG.tempdb.dbo.sp_who 2
Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'sp_who' on remote server 'ASE_BIG'.
Read more...
Product
Keywords
linked server oledb ASE SDK , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.