topic Accessing MS SQL Database using DBCON in Application Development and Automation Discussions

Accessing MS SQL Database using DBCON

Former Member — Wed, 18 Oct 2006 10:55:50 GMT

Hello!

I have a problem when we try to connect to MS SQL Server using DBCON.

In table DBCON I had configure the connection lika this:

MSSQL_SERVER=tcp:<server_ip> MSSQL_DBNAME=<database>

I also have the ABAP program. It is giving a return code of 4 after 'Connect to'.

I can read in SAP system log that is the "Problem in SAP BASIS" and is "No shared library found for the database".

Here is a sample of my program:

report ztest_baza .

data: dbn(128).

EXEC SQL.

SET CONNECTION 'CON'

ENDEXEC.

if sy-subrc eq 0.

write: 'connection ok'

else

write: 'connection error'.

endif.

EXEC SQL.

CONNECT TO 'CON'

ENDEXEC.

if sy-subrc eq 0.

write: 'connection ok'

else

write: 'connection error'.

endif.

Can somebody help me??

Former Member — Wed, 18 Oct 2006 11:28:36 GMT

Hi grzegorz,

1. If your sap application server is unix/aix

(and not a microsoft OS),

2. then this kind of secondary databse connection,

to MS SQL (which is microsoft system),

is at present not possible.

(BCOS the required system files, for such

cross - platform connection is not delivery by sap)

regards,

amit m.

Former Member — Wed, 18 Oct 2006 12:40:06 GMT

So, you mean that it imposible to cnfigure that connection between MSSQL and SAP if SAP is on Unix platform??

There is no solution for that problem??