如何从SAP中连接其他数据库
来源:互联网 发布:真爱西西里香水知乎 编辑:程序博客网 时间:2024/04/30 03:18
Connect to SQL Server database 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.
DBMS: MSS
USER_NAME: <db_user>
PASSWORD: <password>
CON_ENV: MSSQL_SERVER=<server_name> MSSQL_DBNAME=<db_name>
- Specifying the server name
The server name is simply the name of the SQL Server or named instance i.e. the hostname (for a default instance), or <host>/<instname>
Starting with release 6.40 however there are some special considerations that should be taken into account. When running with kernel release 6.40 or later, the R/3 system will prepend a protocol specifier to the server name. Example:
1. For a server running on the same server:
np:<servername>
2. For a remote server:
tcp:<servername>
This forces the connection to be made with a named pipes and tcp/ip protocols respectively.
When specifying the server name you can override this by setting your own protocol (tcp: or np:), or you can make R/3 avoid setting any prefix by using simply :<servername> - a colon in front of the server name.
例程一
report zdbcon .
data: dbn(128).
EXEC SQL.
CONNECT TO 'DAN1'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'DAN1'
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
write: / 'current database name', dbn.
DAN1在DBCON表中配置
CON NAME DAN1
DBMS MSS
USER NAME iis_log
PASSWORD CON ENV
MSSQL_SERVER=tcp:###.###.###.### MSSQL_DBNAME=iislog
例程二
Here is an example for how to connect to another server with CON_NAME=BSK. The example assumes BSK is running R/3:
EXEC SQL.
CONNECT TO 'BSK'
ENDEXEC.
EXEC SQL.
SET CONNECTION 'BSK'
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / 'current database name', DBN.
EXEC SQL.
SET CONNECTION DEFAULT
ENDEXEC.
EXEC SQL.
SELECT db_name() INTO :DBN FROM SVERS
ENDEXEC.
WRITE: / 'current database name', DBN.
notes: https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=178949&nlang=EN&smpsrv=https%3a%2f%2fwebsmp103%2esap-ag%2ede
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- MySQL 如何从其他主机连接数据库
- 如何从SAP中查找BADI
- 如何从SAP中查找BADI
- 如何从SAP中查找BADI
- 如何从SAP中查找BADI
- 转:如何从SAP中查找BADI
- 如何:从C#中启动其他进程
- 如何从其他应用程序中“借用”资源。
- SAP连接数据库
- SAP Lumira连接数据库
- 如何将openCRX数据从HSQLDB迁移到其他数据库
- Sql Server数据库行转列:创建交叉数据报表或旋转数据
- 教你泡制12道居家减肥茶
- Power Designer杂记
- 精彩Blog
- HPC中体会存储的作用
- 如何从SAP中连接其他数据库
- 在Option条目中填充前导空格的方法
- DataGrid应用的一个实例
- Asp.net 1.1中aspnet_regiis的问题
- 今天学习ISDN的配置,,贴出资料
- Json是个好东西
- 关于考研
- Asp.net直接保存文件到客户端
- IT个人的奋斗历程