SAP Knowledge Base Article - Preview

1976895 - SAP SDK OleDB Driver RPC calls failes between MSSQLserver and SAP ASE.


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

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'.



Sybase SDK 15.7


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.