topic Re: Connecting to MS SQL server in Application Development and Automation Discussions

Connecting to MS SQL server

Former Member — Mon, 17 Apr 2006 17:11:54 GMT

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.

Re: Connecting to MS SQL server

former_member181966 — Mon, 17 Apr 2006 18:51:03 GMT

Checkout the thread!!

Thanks

Saquib

Re: Connecting to MS SQL server

Former Member — Mon, 17 Apr 2006 20:42:05 GMT

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?

Re: Connecting to MS SQL server

Former Member — Tue, 18 Apr 2006 04:39:55 GMT

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.