关于DBSL（Database share library）

今天搜索DBSL，整理了一下：
请问想把SAP中一部分数据导到sql sever 中怎么实现,sap中是Oracel/DB2或其它数据库？

答：first of all, you must ensure that the ABAP report, which is connecting
to an non-SAP MS SQL Server database, has to run with an Microsoft OS
(Windows 2000 or Windows 2003).
In other words: it doesn't matter which DBMS or which hardware a SAP-
system uses, but the R/3 application server, on which the ABAP report
runs, need to be installed on Microsoft OS.

To connect to a MS SQL Server an DB-independant client library
(DataBase Shared Library, DBSL) and Microsoft Data Access Components
(MDAC) is required.

You can download the DBSL from SAP Service Marketplace going to URL

SAP Support Packages and Patches
Entry by Application Group
SAP Application Components
SAP R/3
SAP R/3
SAP Kernel 32-BIT
NT/I386L.CAR
MS SQL SERVER
LIB_DBSL.CAR


Copy the file "dbmssslib.dll" to the directory
\usr\sap\\sys\exe\run
on the application server on Windows 2000 or Windows 2003.

You can download the Microsoft Data Access Components (MDAC) at the
URL
For installing please refer to the instructions provided by Microsoft.
Further information is available at the attached note 178949.

DBSL的使用方法

有谁安装过DBSL（Database Shared Library）吗？能否介绍一下，多谢了。如果不安装DBSL，有什么更好的方法可以让SAP与其它系统交换数据？

If you used 4.7 the DBSL have it,You only used T_code "sm30" maintain table "DBCON"
Maintain connect exterior database inform

一些有用的相关链接

 

My Sap edition is 4.7, with oracle database, and application servers run in UNIX.
I created a link 'TEST' in table 'dbcon' using SM30 , then I run this program but failed. It is said that creating a DB link in application server is a necessity, and maybe there are some other necessities.
so, what I want to know is How to set up in SAP in order to use native SQL in ABAP to access external database directly?
who can tell me, thanks!

My program is as follows:


REPORT zkrdbtst .
DATA dsn(10) VALUE 'DSN'.

DATA: BEGIN OF wa,
client(3), arg1(3), arg2(3),
END OF wa.
DATA f3(3).
**Connect to external database
EXEC sql.
connect to 'TEST' as 'CONN'
ENDEXEC.
**Set connection
EXEC sql.

set connection 'CONN'

ENDEXEC.

**Execute native SQLs.
*EXEC sql.
* CREATE TABLE AVERI_CLNT (
* CLIENT CHAR(3) NOT NULL PRIMARY KEY,
* ARG1 CHAR(3) NOT NULL,
* ARG2 CHAR(3) NOT NULL
*
* )
*ENDEXEC.
*
EXEC SQL.
INSERT INTO AVERI_CLNT (CLIENT, ARG1, ARG2)
VALUES ('002', 9, 2)

ENDEXEC.

EXEC SQL.
SELECT * INTO :WA FROM AVERI_CLNT where client = '002'
ENDEXEC.

WRITE: / wa-client, wa-arg1.

**Disconnect
EXEC sql.

disconnect 'CONN'

ENDEXEC.

 

 

 

Prerequisite: At least one Windows application server must be available on the R/3 system and the DBSL dynamic library (DLL) dbmssslib.dll must be installed on this server. This dll can be downloaded from the SAP Service Marketplace.

See SAP note 178949

Cheers Dennis.

 

 

The author never said that the external database is MSSQL.

The correct note could be 323151.

 

 

Hello all,

I am trying to connect with native SQL from a R3 database running DB2/AIX to send records to a MS SQL database. I have logged a note with OSS on the matter because I feel that we are missing the appropriate dll. I got the following reply:

-To connect to a Microsoft SQL Server, you must ensure that the ABAP report, which is connecting
-to an non-SAP MS SQL Server database, has to run with an Microsoft OS
-(Windows NT or Windows 2000).
-In other words: it doesn't matter which DBMS or which hardware a SAP-
-system uses, but the R/3 application server, on which the ABAP report
-runs, need to be installed on Microsoft OS.

What I would like to know is if anyone else has connected to an external db using DBCON, and if so am I heading in the right direction by getting the dll and applying it to the system? And has anyone used this DBCON with a R3 db running DB2/AIX to connect to anything?

Thanks for the help.

 

Hi,

I've heard people doing DBCON connecting to MSSQL on an
HPUX/Oracle R/3 instance. It's done by installing an AP server
on Win2000 as a normal DI. You then further install DB-depenent
MSSQL Kernel DLLs on the DI. This way on the DI, SAP DBI DLLs
for both MSSQL and Oracle are present and the WP's can
perform DB connection to MSSQL via the extra DBCON entry.
Your case is different but it's worth a try!

HTH...
- YJChen

 

The File that we require for accessing the MSSQL Server from AIX is dbmssslib.o , this file is not available from SAP as of now . So I'm guessing that all of the other notes in OSS are missing something about having this file. Could this be false advertising?

 

Hello,

I have tried it in SAP ECC 5.0 / Oracle 9i / Windows 2003 platform. But it is disconnected from SAP when trying to run this program RSMSS_DBSL_PROFILE_SWITCH.I have copied this file dbmssslib.dll in kernel directory. DBCON table entry is like that " MSSDB MSS testuser 0 0 MSSQL_SERVER=saptest MSSQL_DBNAME=TESTSAP OBJECT_SOURCE=testsap"

What will I do?

Please help me ASAP

Thanks
Gautam

I have to get the data to BW from MS SQL. I spent some time yesterday to do that but I failed.
I put an entry into the DBCON table in BW.
Database Connection Name: PLWARD0011
DBS: MSS
User name: here I typed the user name that lets me log on my MS SQL Server
Connection info: MSSQL_SERVER=194.181.40.18 MSSQL_DBNAME=LOADER

And connetion doesn't work. When I go to Source System in BW, choose Select Tables I get the following message: "Database system cannot be reached"

Do I have to do anything on the MS SQL server?
What about dbmssslib.dll? It should be installed on the BW server, right?
How should I install it?

Thanks in advance
Arek

just put it in the same directory where you find dboraslib.dll

 

 

 

Hi guys,

Is there an OS issue in terms of network, database connection, etc..? Im trying to create one Windows apps server remotely and im having problems such as hostnamelookup to a Unix database central instance.

Thanks in advace and more power!

We're trying to do the same but we chose Linux instead of Windows.
I think it's more stable on Linux and integrates better with our AIX backend.
If we use Windows we need to use SAMBA to mount File System onto Windows, may i ask what you use for this?

I'm interested also other people's view on this.

Thanks.

it's called heterogenous environment. - I hope I spelled it right... like above said, you will need to use samba to mount file systems. to maintain it, it's even harder. only do this when you feel that you are competant.

people usually do this to save money on server. now that linux is around, that doesn't apply much except you want to have fully supported/validated OS. one other might be connecting non-SAP SQL server using DBCON. people also do this for heck of it. last I can think of is, some thought that it will bring them job security. since it's not easy set up to maintain as I said before.
_________________
NOT certified but stayed at holiday inn