AS400 SAP to Microsoft SQL Server

[Former Member]

We currently run SAP on an AS/400 and our Time and Attendance system on MSSQL. Is it possible to make a direct call to the SQL server using ABAP. I have tried using EXEC SQL but get the error 'SQL error 100663296 occurred when setting up connection' when it tries to connect.

Any help would be much appreciated.

Regards

Richard

[RichHeilman]

We run on an AS/400 as well, and I have tried to do the exact same thing as you, I have found that the only way to do so is if you are running a windows app server.

Regards,

Rich Heilman