cancel
Showing results for 
Search instead for 
Did you mean: 

DB Connect - Link to database failed

Former Member
0 Kudos

I encountered error when I use the TMS Check Transport Tool. Both DB Connect and Offline Call failed during tp Call. Below are the log from the error.

Hope someone can kindly give me some advice here. Thanks.

Rgds,

Aaron

-


This is tp version 340.16.24 (release 640, unicode enabled)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBNAME is no longer used.

ERROR: Connect to N01 failed (20070402180622, probably wrong environment).

TRACE-INFO: 1: [dev trc ,00000] Mon Apr 02 18:06:21 2007 179913 0.179913

TRACE-INFO: 2: [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 13 0.179926

TRACE-INFO: 3: [dev trc ,00000] using "D:\usr\sap\N01\SYS\exe\run\dbmssslib.dll" 13 0.179939

TRACE-INFO: 4: [dev trc ,00000] Thread ID:5048 27238 0.207177

TRACE-INFO: 5: [dev trc ,00000] Thank You for using the SLOLEDB-interface 14 0.207191

TRACE-INFO: 6: [dev trc ,00000] Using dynamic link library 'D:\usr\sap\N01\SYS\exe\run\dbmssslib.dll'

TRACE-INFO: 7: 22 0.207213

TRACE-INFO: 8: [dev trc ,00000] dbmssslib.dll patch info 33 0.207246

TRACE-INFO: 9: [dev trc ,00000] patchlevel 0 8 0.207254

TRACE-INFO: 10: [dev trc ,00000] patchno 152 8 0.207262

TRACE-INFO: 11: [dev trc ,00000] patchcomment Connection check on (0,0) (988711) 9 0.207271

TRACE-INFO: 12: [dev trc ,00000] np:(local) connection used on EMI-SAP 95 0.207366

TRACE-INFO: 13: [dev trc ,00000] CopyLocalParameters: dbuser is 'dbo' 11 0.207377

TRACE-INFO: 14: [dev trc ,00000] Provider SQLNCLI could not be initialized. See note #734034 for more information.

TRACE-INFO: 15: 336468 0.543845

TRACE-INFO: 16: [dev trc ,00000] Using provider SQLOLEDB instead. 11 0.543856

TRACE-INFO: 17: [dev trc ,00000] OpenOledbConnection: MARS property was not set. 1474 0.545330

TRACE-INFO: 18: [dev trc ,00000] Mon Apr 02 18:06:22 2007 654933 1.200263

TRACE-INFO: 19: [dev trc ,00000] Provider Release:08.10.1830 10 1.200273

TRACE-INFO: 20: [dev trc ,00000] Provider SQLNCLI could not be initialized. See note #734034 for more information.

TRACE-INFO: 21: 24489 1.224762

TRACE-INFO: 22: [dev trc ,00000] Using provider SQLOLEDB instead. 10 1.224772

TRACE-INFO: 23: [dev trc ,00000] i'm dbo but there exists 1 users <> dbo with tables SVERS ==> connect terminated

TRACE-INFO: 24: 27591 1.252363

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

standard output from tp and from tools called by tp:

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Joe,

Thanks for your reply.

Notes 734034 implies the following...

"Please NOTE: This is a warning message only. It is meant to remind users to apply the SQL 2005 client libraries."

I have seen this note before and concluded that since I'm on MS SQL 2000 now, so it's not mandatory in my case.

Lastly, I was reluctant to proceed with it because IMHO, I will be introducing new factors into my unsolved problems.

Former Member
0 Kudos

even i faced the same error, what did you do to resolve this error.

Former Member
0 Kudos

Probably a silly question, have you tried R3trans -x ?? what dos it shows?

Is TP program updated?

Not an expert but I´m very interested to know what the problem is.

yuezhi_zhao
Contributor
0 Kudos

Hello Aaron,

As it's indicated in the trace of the checking TP tools, you need to Install the sql native provider on the application server. In the trae mesasge, it says clearly ou need to consult note 734034 to install the sql native provider on the application server.

Regards,

Joe

Former Member
0 Kudos

Thanks Vincent.

I've gone through the notes you listed before. I might have missed something due to my limited knowledge in basis. My initial installation was in SP09 and I've been able to patch uptill SP18. It's only recently that I encounter this problem. It happened during updating the SPAM tool. And currently stuck in the Import phase CHECK_REQUIREMENTS.

Perhaps you can let me know what information you need in order to pin point the problem.

Thanks again for your kind help.

vincentlim826
Employee
Employee
0 Kudos

Hi,

Check the MSSQL env variables settings, i.e DBMS_TYPE, MSSQL_DBNAME,

MSSQL_SCHEMA, SAPLOCALHOST, MSSQL_SERVER

See below SAP Notes

351586 TP: DBSL error 107, DB error 208 with Connect

128126 Database Connect for external tools

28667 Microsoft SQL Server Specific Profile Parameters

98678 SQL Server Connection Issues

Could you also check STMS, system overview, tab transport tool and see here if there are any wrong parameters?

Hope this helps.

Regards,

Vincent