Database Link does not work on DI

holger_kopf — Thu, 18 Mar 2010 15:35:13 GMT

Hi, in installed a DI beside on CI. We use some DB-Links to an MS SQL Sever and access the tables with Native SQL. If the ABAP is running on the CI, we have no problems.

But if we start the programm on the DI, we got short dumps.

In the dev_w0 i see such entries:

B create_con (con_name=NEXUS2_GARTNER)

B Loading DB library 'D:\usr\sap\P02\D00\exe\dbmssslib.dll' ...

B Library 'D:\usr\sap\P02\D00\exe\dbmssslib.dll' loaded

B Version of 'D:\usr\sap\P02\D00\exe\dbmssslib.dll' is "700.08", patchlevel (0.246)

B New connection 1 created

B Connect to SQL_EXT as sapsa with MSSQL_SERVER=SQLSERVER1 MSSQL_DBNAME=SQL_EXT

C Thread ID:3864

C dbmssslib.dll patch info

C patchlevel 0

C patchno 246

C patchcomment Safety check in connect and execute function (1434523)

C Network connection used from DIServer to SQLSERVER1 using tcp:SQLSERVER1

C OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

C failed to establish conn to tcp:SQLSERVER1.

C Retrying without protocol specifier: SQLSERVER1

C OpenOledbConnection : CoCreateInstance failed. rc: 8007007e.

C failed to establish conn. 0

B ***LOG BY2=> sql error -1 performing CON [dbds#2 @ 1056] [dbds 1056 ]

B ***LOG BY0=> <message text not available> [dbds#2 @ 1056] [dbds 1056 ]

C OCIStmtExecute() failed with -1=OCI_ERROR

C SQL error 942:

Why does a DB Link does not work on a DI ????

Any help ?

Regards Holger

Re: Database Link does not work on DI

Udo_Ahle — Wed, 30 Jun 2010 09:31:09 GMT

Hello,

i have exactly the same problem. Is there already a solution yet?

topic Database Link does not work on DI in Application Development and Automation Discussions

Database Link does not work on DI

Re: Database Link does not work on DI