如何从SAP中连接其他数据库
来源:互联网 发布:美工笔记本 编辑:程序博客网 时间:2024/05/17 07:14
2006年08月30日 15:07:00
1. 工作环境需求
A. The operating system user >sid
B. The R/3 table DBCON must be maintained.
C. The correct database library 'dboraslib.>ext<' must exist in the kernel directory.
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.
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.
dbmssslib.dll
2. 配置连接信息
配置TCODE: dbco
任何配置信息都存储在DBCON表中.
配置示例:
A. 访问MSSQL的配置示例(参见SAP Notes 178949)
CON_NAME: >my_conn_name<
DBMS: MSS
USER_NAME: >db_user<
PASSWORD: >password<
CON_ENV: MSSQL_SERVER=>server_name< MSSQL_DBNAME=>db_name<
DBMS: MSS
USER_NAME: >db_user<
PASSWORD: >password<
CON_ENV: MSSQL_SERVER=>server_name< MSSQL_DBNAME=>db_name<
db_user could be sapr3 for example if the server is running R/3. The password field may be blocked from view by asterisks in sm30. USER_NAME can be left blank in order to use integrated security (4.6d kernel and later). In that case make sure that the OS User running R/3 has the required privilege on the remote server. A dummy password must be entered in sm30, it will not be used when the user name is blank.
B. 访问ORACLE的配置示例()
Connection name logical name of the connection
DBMS ORA
User name Oracle users
DB password password for the above-mentioned Oracle user
Conn.info TNS alias
Permanent Usually should not be set for a secondary connection.
3. 程序中如何使用
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
Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1144319
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- 如何从SAP中连接其他数据库
- MySQL 如何从其他主机连接数据库
- 如何从SAP中查找BADI
- 如何从SAP中查找BADI
- 如何从SAP中查找BADI
- 如何从SAP中查找BADI
- 转:如何从SAP中查找BADI
- 如何:从C#中启动其他进程
- 如何从其他应用程序中“借用”资源。
- SAP连接数据库
- SAP Lumira连接数据库
- 如何将openCRX数据从HSQLDB迁移到其他数据库
- SD--如何编程提取SD的定价信息
- 许多的图书下载连接列表
- 如何编写上传(PC->AS)和下载(AS->PC)程序示例
- ABAP--编写下载(AS->PC)并在客户端打开的程序示例
- ABAP--编写应用服务器执行外部命令的程序示例
- 如何从SAP中连接其他数据库
- 2006最新版个人所得税计算器
- ABAP--SAP的SCreen录入的简单模板
- 如何使用SMOD和CMOD进行SD的用户增强
- SAP和ABAP内存的区别
- ABAP--SAP显示处理进度的函数
- 获取当前使用某个TCODE的用户的程序样例
- 将EXCEL文件上传到SAP AS的内表
- ABAP--如何创建动态结构的报表