SAP Oracle database connection with external SQL server database

[Former Member]

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 <DBCON_entry_name> or Unable to find library <kernel_directory>/dbmssslib.sl'. ->

DLENOACCESS (0,Error 0) or ERROR => DlLoadLib()==DLENOACCESS - dlopen - ("/usr/sap/<SID>/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

[Former Member]

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

[divyanshu_srivastava3]

Hi Shahid,

As this is something related to low level layer client server issue, I would suggest you to re-check the config and permissions.

Regards,

Divyanshu

[former_member188883]

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

[Former Member]

Thanks all for helping , now as per restrction of oracle under AIX connectivity with  windows Sql server we change our plan now we connect sap oracle 11g under IAX with windows oracle 12c steps I followed.

1. create a service in tnsname file with name wms and give all information required for oracle 12c for connection .

2. create connection with transaction DBCO and give service name which was created in step 1.

3.  run program ADBC_TEST_CONNECTION to test connection but it give me dump "covert codepage"

Please guide me

Regards

[divyanshu_srivastava3]

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

[Sriram2009]

Hi

Check this SAP Note

178949 - MSSQL: Database MultiConnect

BR

SS

[divyanshu_srivastava3]

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

[Former Member]

Hi,

Plz find the Connection Matrix info for conneting to external Microsoft SQL Server database

1601608 - How to access an external Microsoft SQL Server database

Thanks & Regards,

Sandeep Alapati