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,

It is not a Multi Server Environment and I have put this DBMSSSLIB.DLL in the Application Server from where I am connecting. I have check connection to SQL Server through other programs and they are working fine but from SAP it is not working. Connection right now cannot be made through SAP and I am getting the same error as mentioned in the first post.

Please Advice.

Thanks,

Usman Malik

[Former Member]

Hi,

I am assuming you have placed the LIB in the exe directory ?

dbmsslib.dll

dbmsslib.pdb

What are you coonect strings in DBCO ??

Have you read Note: 738371

Mark