Connect SQL Server through DBCO - DBCONNECT

[#1]

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,

I would assume the pdb file was part of the lib bundle I got off OSS.

Now I have one of my ERP6 systems that runs Oracle but I am connecting to an open source DB based through MSS

As you mentioned you have the libs loaded in the exe/run directory.

To connect to the MSS system I have had to create an system DNS ODBC on the source system.

In my case I run an Hetrogeneous system environment UNIX CI/DB IBM window blades, so I created the ODBC on the app server.

Now my DBCO connection string is MSSQL_DATASOURCE=<Name of ODBC>

The test program then worked. Also there will be som good trace files out of it for analysis run report RSRFCTRC

Hope this helps some way

Mark