好贷网好贷款

如何从SAP中连接其他数据库

发布时间:2016-12-5 0:28:35 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"如何从SAP中连接其他数据库",主要涉及到如何从SAP中连接其他数据库方面的内容,对于如何从SAP中连接其他数据库感兴趣的同学可以参考一下。

  1.       工作环境需求     A. The operating system user <sid>adm must be able to log on to the secondary database.     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. dbmssslib.dll 2.       配置连接信息 配置TCODE: dbco 任何配置信息都存储在DBCON表中. 配置示例: A.      访问MSSQL的配置示例(参见SAP Notes 178949) CON_NAME: <my_conn_name>DBMS: MSSUSER_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. 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. 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 SVERSENDEXEC.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 SVERSENDEXEC.WRITE: / 'current database name', DBN.EXEC SQL.  SET CONNECTION DEFAULTENDEXEC.EXEC SQL.  SELECT db_name() INTO :DBN FROM SVERSENDEXEC.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

上一篇:应用框架的设计与实现学习手札之类工厂服务——反射
下一篇:在Option条目中填充前导空格的方法

相关文章

相关评论