Skip to Content
avatar image
Former Member

SAP Oracle database connection with external SQL server database

Dear Experts,

Currently we are using SAP ecc6EHP7 under oracle 11g AIX 7.1 ( only ABAP system) . we want to connect database connection from oracle ( AIX ) to SQLserver 2012 under windows.

I create connection with DBCO , when I test connection with program  ADBC_TEST_CONNECTION

give my connection and execute it give following error.

B  Loading DB library '/usr/sap/DEV/DVEBMGS00/exe/dbmssslib.so' ...

M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/DEV/DVEBMGS00/exe/dbmssslib.so") FAILED

  "#0509-022 Cannot load module /usr/sap/DEV/DVEBMGS00/exe/dbmssslib.so.

#0509-026 System error: A file or directory in the path name does not exist."  (errno=2,No such file or directory) [dlux.c       521

M  {root-id=53A301BEAD8D0920E10080000A000019}_{conn-id=00000000000000000000000000000000}_0

B  *** ERROR => Couldn't load library '/usr/sap/DEV/DVEBMGS00/exe/dbmssslib.so'

wen cannot find library file dbmssslib.so in service portal. and as per sapnote 1601608

5. Troubleshooting

l No shared library found for the database with ID or Unable to find library / dbmssslib.sl'. ->

DLENOACCESS (0,Error 0) or ERROR => DlLoadLib()==DLENOACCESS - dlopen - ("/usr/sap/ /DVEBMGS00/exe/ dbmssslib.so")

FAILED

or could not load library for database connection <DBCON_entry_name> or cannot open shared object

This error indicates that the ABAP stack could not find the SAP DBSL for SQL Server (dbmssslib.dll) in the kernel directory. If you

encounter this error on a Unix - based server the root cause is clear: the DBSL does not exist for other platforms than Windows or Linux

x84_64. In this case use a Windows-based or a Linux x86_64-based SAP Application Server to establish the connection. If your system

does not contain a Windows-based or a Linux x86_64-based Application Server you need to setup a small one as workaround. If you

encounter this error on a Windows Application Server or a Linux x86_64 based Application Server make sure that the DBSL is properly

installed in the kernel directory as explained in point 3.

we cannot connect oracle database under AIX with SQL server under windows.

Kindly guide me workaround solve my issue.

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 20, 2014 at 06:31 AM

    Hi Shahid,

    We cannot connect to MSSQL DB if your instance is running on AIX. Because, the DBLS which is provided my microsoft, is only available for Windows and Linux(specific platform). However, if you wan to monitor MSSQL DB from AIX system, I can provide an alternative way to do it.

    Check SAP Note: 1601608 and 1458291 for more info.

    Regards,

    Divyanshu

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2014 at 06:46 AM

    Hi

    Check this SAP Note

    178949 - MSSQL: Database MultiConnect

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2014 at 07:44 AM

    Hi Shahid,

    From the error message

    M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/DEV/DVEBMGS00/exe/dbmssslib.so") FAILED

      "#0509-022 Cannot load module /usr/sap/DEV/DVEBMGS00/exe/dbmssslib.so.

    #0509-026 System error: A file or directory in the path name does not exist."  (errno=2,No such file or directory) [dlux.c       521

    dbmssslib.so does not exist in the kernel directory. You may need to download the same , extract and place it in the kernel directory.

    Other solution is to have Application server in Windows on which you download and extract this dbmsslib.dll file for MSSQL database and execute remote database connection from that app server.

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Shahid,

      Follow these notes:

      For DBCON - note 339092

      Oracle client software must be installed - notes 539922, 521230

      Network files tnsname.ora and sqlnet.ora must be updated note 571623.

      1261329 - DBA Cockpit: Oracle as a remote database.

      And for Code Page conversion, please provide some more insight on that ST22 dump.

      Regards,

      Divyanshu

  • avatar image
    Former Member
    Jun 23, 2014 at 04:08 AM

    Thanks Divyanshu for your Guidance following are the dump facing after run database connection test program  ADBC_TEST_CONNECTION

    Category           ABAP Programming Error Runtime Errors     CONVT_CODEPAGE Except.            CX_SY_CONVERSION_CODEPAGE ABAP Program       SAPLSDEB

    Application Component  BC-CST-LL

    Date and Time      23.06.2014 09:02:40

    Short Text

    A character set conversion is not possible.

    What happened?

    During conversion of a text from code page '4110' to code page '4102', one of the following occurred: - characters were discovered that cannot be dislpayed in one of the code pages, or - the conversion could not be performed for some other reason (see below for more details)

    Excerpt from the source buffer from the first character that could not be converted, displayed in hexadecimal form (with the ASCII characters in brackets): A4 3F 2E 00 00 00 00 00 00 00 00 00 00 00 00 00 (.?..............)

    The current ABAP program "SAPLSDEB" had to be terminated, as this conversion would have resulted in incorrect data.

    The number of non-convertible characters is 11. If this number is 0, the second reason stated above applies.

    Error analysis

    An exception has occurred which is explained in more detail below. The exception is assigned to class 'CX_SY_CONVERSION_CODEPAGE' and was not caught   in procedure "READ_TRACE_FILE" "(FORM)", nor was it propagated by a RAISING clause.

    Since the caller of the procedure could not have anticipated this

    exception, the current program was terminated.

    The reason for the exception is:

    Characters are always displayed in a specific code page. Many code

    pages only define a restricted set of characters. If you want to

    convert text from one code page to another, and this text contains

    characters that which are not defined in one of these code pages, a

    conversion error occurs.

    A conversion error like this can also occur if one of the code pages

    required ('4110' or '4102') is not known in the system.

    If the conversion error occurred while reading or writing a file, the

    file name was '/usr/sap/DEV/DVEBMGS00/work'. (For more information on this

    file: "X     130

    12288rwxr-xr-x201406230902402014062309024020140623090240")

    Regards

    Add comment
    10|10000 characters needed characters exceeded