Skip to Content
0
Former Member
Feb 22, 2008 at 01:41 PM

RFC call from MSSQL 2000 stored procedure

455 Views

Hi. I need call SAP RFC transaction from stored procedure of MS SQL Server 2000.

When i'm execute example from T-SQL Help it's work perfect

Examples
A. Use Prog ID
This example creates a SQL-DMO SQLServer object by using its ProgID.

DECLARE @object int
DECLARE @hr int
DECLARE @src varchar(255), @desc varchar(255)
EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT
IF @hr <> 0
BEGIN
   EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT 
   SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
    RETURN
END

When i'm execute:

DECLARE @object int
DECLARE @hr int
DECLARE @src varchar(255), @desc varchar(255)
EXEC @hr = sp_OACreate 'SAP.Functions',
    @object OUT
IF @hr <> 0
BEGIN
   EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT 
   SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
    RETURN
END

i'm recieve error:

0x800401F3

ODSOLE Extended Procedure

Wrong string with class name

BUT! This example work perfect via another way: in VBS script, in VBA macros, in Visual FoxPro program.

What wrong in MS SQL ???