cancel
Showing results for 
Search instead for 
Did you mean: 

No connect due to DbSl Load Lib Failure - environment variable dbms_type is

Former Member
0 Kudos

Hi guys,

I need your help with the below described issue.

While performing a simple transport tool check on our PRD system we get the following error:

This is tp version 340.16.64 (release 640)

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to PRD failed (20110211130714).

TRACE-INFO is written to file ''. See there for more information.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0249

standard output from tp and from tools called by tp:

stack trace

tp_rfc_main

RfcDispatch

remote_tp

tp_former_main

tp_connect

tp_rc_handler

end stack

_____________________________________________________________________________________________________

Both users SAPPRD8\prdadm and SAPPRD8\SAPServicePRD have all the environment variables correctly configured, namely:

dbms_type=mss

MSSQL_DBNAME=PRD

MSSQL_SCHEMA=prd

MSSQL_SERVER=SAPPRD8

_____________________________________________________________________________________________________

Windows registry entries are correctly configured, namely:

- HKLM\SOFTWARE\SAP\PRD

- AdmUser SAPPRD8\prdadm

- HKLM\SOFTWARE\SAP\PRD\Environment

- DBMS_TYPE = MSS

- MSSQL_DBNAME = PRD

- MSSQL_SCHEMA = prd

- MSSQL_SERVER = SAPPRD8

- PATH = S:\usr\sap\PRD\SYS\exe\run

- SAPLOCALHOST = SAPPRD8

- TEMP = C:\Windows\TEMP

- TMP = C:\Windows\TEMP

____________________________________________________________________________________________________

SAP Default profile shows:

SAPSYSTEMNAME = PRD

rdisp/mshost = SAPPRD8

rdisp/accept_remote_trace_level = 0

rdisp/sna_gateway = SAPPRD8

rdisp/sna_gw_service = sapgw00

rslg/collect_daemon/listen_port = 37

rslg/collect_daemon/talk_port = 13

rdisp/bufrefmode = sendoff,exeauto

ms/server_port_0 = PROT=HTTP, PORT=8100

SAPDBHOST = SAPPRD8

dbms/type = mss

dbs/mss/server = SAPPRD8

dbs/mss/dbname = PRD

dbs/mss/schema = prd

____________________________________________________________________________________________________

SAP Kernel information is as follows: (Latest kernel version available)

kernel release 640

Database Client Library SQL_Server_8.00

DBSL Patch No. 358

kernel make variant 640_REL

compiled on NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10 for "NTintel"

compilation mode Non-Unicode

compile time Sep 20 2010 23:01:12

update level 0

patch number 347

source id 0.347

ICU Version Library not loaded

____________________________________________________________________________________________________

dbmsslib.dll information: (Latest library version available)

Product Version 640, patch 358, changelist 1214128

____________________________________________________________________________________________________

Current platform (temporary, while being upgraded):

- Windows 2008 R2 x64

- SQL Server 2008

- SAP R/3 4.7 x200

____________________________________________________________________________________________________

SAP Support was unable to solve this issue up until now.

Thank you very much for your help.

Bruno Pereira

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member189546
Active Contributor

Hello,

Check these parameters

dbms_type=mss

MSSQL_DBNAME=

MSSQL_SCHEMA=

MSSQL_SERVER=

please be sure you have set this

as note 128126

for user SAPServiceEDP

regards,

John Feely

0 Kudos

Solved by this solution provided.

0 Kudos

Dear All,

I was first facing error 249 and then 232, these two got resolved by parameter settings in environment variables as mentioned by john feely in this query.

Former Member
0 Kudos

Solution:

Note 1436828 - Automatic Environment Synchronization with Roaming Profiles

Thanks for your input nonetheless!

__

Bruno Pereira