Connect SQL Server through DBCO - DBCONNECT

[Former Member]

Hi Guys,

I am trying to connect to one of the SQL Server in my Domain. I have made entries as mentioned by SAP note in DBCO Transaction. When I am testing connection through program 'ADBC_TEST_CONNECTION' it is showing me following error:

Testing a Database Connection Defined in DBCON

Could not open connection SQLCONNECTION

sql error 1- occured:

I have already installed DBMSSSLIB.DLL in executable directory also.

Please advice.

Thanks,

Usman Malik

[Former Member]

Hi,

Your SAP server is running on Windows?

put DBMSSSLIB.DLL in these directories:

X:\usr\sap\SID\D*\exe

X:\usr\sap\SID\sys\exe\run

X:\usr\sap\SID\sys\exe\ (i386 or ntamd64) \ (nuc or uc)

then, try again,.

Edited by: Eric Brunelle on Sep 29, 2010 11:14 AM