SAP Connect to external database: MSSQL

[Former Member]

Hi all,

i'm new to this forum. please help me on the external database connection problem.

1) i've setup DBCON for the external database MSSQL

CON NAME: RAF

DBMS: MSS

USER NAME : RACHEL

PASSWORD : ****

CON ENV: MSSQL_SERVER=10.1.1.888 MSSQL_DBNAME=MASTER

2) Our SAP application server is running in Windows NT, and we have dbmssslib.dll installed in the run directory

i come across the following errors after test run the connection via ABAP: ADBC_TEST_CONNECTION ~

B *** ERROR => Version mismatch between kernel (620.02) and DBSL shared library (6)

[dbcon.c 3492]

B ***LOG BZY=> unexpected return code calling CON [dbds#2 @ 1023] [dbds 1023 ]

B ***LOG BZY=> unexpected return code 4 calling DBACDS [dbacds#2 @ 961] [dbacds 0961 ]

Please advice.

regards,

rachel

[former_member433984 · Accepted solution]

make right mouse click on dbmsslib.dll -> Properties -> Version

post here product version, platform, build description

if you have 6.40 version of dbmsslib.dll you have to run 6.40 kernel.

6.20 is out of support.

[Former Member · Accepted solution]

Thanks for your feedback.

I've re-run ADBC_TEST_CONNECTION after kernel update.

<b>the code dump end at</b>:

The termination occurred in the ABAP program "CL_SQL_CONNECTION=============CP

in "GET_CONNECTION".

The main program was "ADBC_TEST_CONNECTION ".

The termination occurred in line 33 of the source code of the (Include)

program "CL_SQL_CONNECTION=============CM004"

of the source code of program "CL_SQL_CONNECTION=============CM004" (when

calling the editor 330).

CALL 'C_DB_FUNCTION' ID 'FUNCTION' FIELD 'DB_SQL'

ID 'FCODE' FIELD 'CO'

ID 'CONNAME' FIELD con_name

ID 'CONDA' FIELD con_da

ID 'SQLCODE' FIELD sql_code

ID 'SQLMSG' FIELD sql_msg.

<b>the log shown at SM21:</b>

09:10:39 DIA 03 300 RACHEL SE38 Q0E Signal c00 received by operating system

09:10:40 DIA 03 300 RACHEL SE38 Q02 Stop Workproc 3, PID 2552

09:23:04 RD Q0I Operating system call recv failed (error no. 10054)

09:23:12 WRK 00 Q0Q Start Workproc 3, Pid 5300

09:23:27 DIA 03 300 RACHEL SE38 R47 Delete session 004 after error 023

1) no core file found in the SAP System work directory (e.g. /usr/sap/c11/D00/work ).

2) Do i need to setup ODBC in application server to solve this problem?

Please advice.

[former_member204746 · Accepted solution]

SM21 shows:

<b>09:10:40 DIA 03 300 RACHEL SE38 Q02 Stop Workproc 3, PID 2552 </b>

so, check dev_w3 for traces on why this failed.

also, have you read SAP Note 738371 - Creating DBCON multiconnect entries for SQL Server

[Former Member · Accepted solution]

thanks for your feedback.

Note: 738371 checked. The DECON : user id logon is SQL server authentication.

is it because of the kernel and db library patches level :-

kernel : 640, patches : 161

db library : 640, patches : 195

<b>this is what i found in dev_w1 trace file:</b>

B Mon Sep 10 11:15:15 2007

B create_con (con_name=JVA)

B Loading DB library 'F:\usr\sap\P05\SYS\exe\run\dbmssslib.dll' ...

B

B Mon Sep 10 11:15:16 2007

B Library 'F:\usr\sap\P05\SYS\exe\run\dbmssslib.dll' loaded

B *** ERROR => Version mismatch between kernel (640.00) and DBSL shared library (6)

[dbcon.c 4370]

Please advice.

[former_member433984 · Accepted solution]

it still looks like you have old db library version.

What is the date from dbmsslib.dll and disp+work.exe in F:\usr\sap\P05\SYS\exe\run?

[Former Member · Accepted solution]

Thanks