10-18-2006 11:55 AM
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??
10-18-2006 12:28 PM
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.
10-18-2006 12:28 PM
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.
10-18-2006 1:40 PM
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??