Connecting to MS SQL server

[Former Member]

Hi,

I am trying to connect to external MS SQL server to send and receive data from/to SAP server.

I created entry in the table DBCON and we installed

the DLL file dbmssslib.dll.

I am getting the return code SY_SUBRC=4 after the following code.

EXEC SQL.

CONNECT TO 'SQLSERVER'.

ENDEXEC.

Can anyone help me to fix this issue.

Thnaks,

Ashok.

[former_member181966]

Checkout the thread!!

Thanks

Saquib

[Former Member]

This link is for connecting to Oracle database.We want to connect to external MS SQL database. Our SAP server is running on Windows with Oracle database. Our Basis team installed MS SQL client tools on SAP server. Even after this we are getting Sy-SUBRC = 4.

Are we doing something wrong with the entry in DBCON?

[Former Member]

HI ashok,

1. Before checking with abap,

just make sure with basis team,

that the connection is running fine or not.

2. ie.,

without using abap,

check directly on the application server,

whether it is able to connect to your ms sql database,

using some sql utility or some interface.

regards,

amit m.