Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Link does not work on DI

holger_kopf
Explorer
0 Kudos
73

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

1 REPLY 1

Udo_Ahle
Explorer
0 Kudos
38

Hello,

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