Error while connecting to external SQL server through DBCO

[Former Member]

Hi everyone,

Need help...

I have a problem while creating a connection to an external MS SQL server using TC DBCO.

i m passing the server IP addrs , user id ans pwd and connection string in DBCO.

While testing the connection... it throws an error saying.

'Could'nt load the library '/us/sap/CPC/DVEBMGS00/exe/dbmssslib.so'

Please suggest wat to do..

[brian_walker]

Sounds to me like /us/sap/CPC/DVEBMGS00/exe/dbmssslib.so doesn't exist.

You'll need to download the DB-specific portion of your kernel version for MSSQL on the service marketplace to get the DBSL appropriate library (dbmsslib.so in this case) and copy it to the above directory. For instance, SAPEXEDB_236-20001361.SAR would be appropriate for a Netweaver 7.0 unicode system with the application servers on Windows x86_64.

Do keep in mind that if SAP does not support MSSQL as a database for your app server platform, there will not be a DB specific kernel for you can download. An example would be Linux application servers, as MSSQL is not a supported database to install SAP. In fact, as far as I know MSSQL is only supported for Windows application servers. If you're in that boat, I believe I have seen other forum messages about how to use the JDBC drivers to connect to MSSQL.

Brian