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 Mark,

Yes i tried with ODBC. ODBC shows that the connection is fine. I tried to use OLEDB and it was not working with SQL Server. Then for the test i made MSAccess Database, made its ODBC connection and tried with the same OLEDB code and it was working fine.

I think there is an issue between this SAP and SQL Server 2008. SAP is not able to communicate to SQL Server 2008 with DBConnect or ODBC. DLL and PDB Files are placed in run directory of SAP in the Server as mentioned but still no use.

Please advice.

Thanks,

Usman Malk

[Former Member]

Hi,

Have you created a OSS message with SAP to see what they think ?

Mark