sap 读取MSSERVER2005问题!急!!!!
请各位帮我看看!
我现在想在ABAP中通过EXECSQL。。。ENDEXEC。来读取另外一台MS SERVER2005数据库中的数据,SAP用的数据库是DB·
我在SAP做了:
在DBCON表中配置
CON NAME =
DBMSWCB
DBMS = MSS
USER NAME = SA
PASSWORD = SA
CON ENV
MSSQL_SERVER=tcp:192.168.108.252 MSSQL_DBNAME=tempdb OBJECT_SOURCE=Table_1
tempdb:数据库名,Table_1:表名.
ABAP:
DATA: dbms like dbcon-con_name,
DBMSWCB like dbcon-con_name.
EXEC SQL.
CONNECT TO :'DBMSWCB'
ENDEXEC.
if sy-subrc = 0.
write :'success!'.
else.
write:'error!'.
endif.