DB Connect to SQL from SAP BW AIX server

[Former Member]

Dear All,

I want to connect my BW system(running under AIX) to MS SQL(which running under window). anybody know what I am suppose to do? since I did create the Source System for the DB connect and MSSQL as the target.. but it didnt work... it say required the library... anybody know where i can find the library for the AIX... one forum say that I have to find the dbmssslib.o but i cant find it...

Thanks in advance for the reply

Regards,

Tienus

[mathew_muthalaly · Accepted solution]

Hi,

Take a look at this link:

http://help.sap.com/saphelp_nw04/helpdata/en/58/54f9c1562d104c9465dabd816f3f24/content.htm

BR/

Mathew.

[former_member181953 · Accepted solution]

Hi

If you want DB -connect with MS-SQL, In the source MS-SQL all the tables which provide data for SAP have to be owned by SAP-User (which you created to connect data base).

[Former Member · Accepted solution]

Hi Shasi and matthew,

First of all, thanks for the quick reply... I appreciate it...

The thing is.. I have already have the user for the for the SQL that will grant all the authorization. My problem here is when I try to make a Source System using DB Connect.. it gives me an error which says that missing some kind of library...

And I try to find those library, but I cant get it... I search in the sap market place... but none of those library match with my BW server...

correct me if I am wrong, the file name should be LIB_DBSL.CAR some of the forum say that we should find the library under SAPEXEDB.SAR.. but I cant find those file for kernel 6.40 AIX 64 bit oracle.

Anybody can help me with this..

Thanks in advance..

Tienus

[Former Member · Accepted solution]

Hi all,

this is the error that i got when i create the source system using DB connect to MSSQL

No shared library found for the database with ID DBSQL

As well as the standard connection, an attempt was made to set up

another database connection, under the specified ID. The Shared Library

for this second database could not be found.

The Shared Library is usually found in the the Executable

directory (profile parameter DIR_LIBRARY) under the name dbs

<dbs>slib<os_ext>. <dbs> stands for the database type and <os_ext>

stands for the operating system-specific extension of the Shared

Libraries.

The database type is determined from the entry that corresponds to the

specified DB ID in the table DBDCON. Check whether the data in this

entry is correct.

anybody can help me with this error...

My BW system is on AIX server.. and I want to connect the MSSQL under Window..

Thanks in advance for the reply

[Former Member · Accepted solution]

Hello Tienus,

You need a Windows-NT application server since there are no SQL driver for AIX.

Have a look at [https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2f0fea94-0501-0010-829c-d6b5c2ae5e40]

Thanks.