请问两个数据库怎么连接??

来源:百度知道 编辑:UC知道 时间:2024/05/12 20:34:16
操作系统分别是xp和server2000,数据库分别是个人版和企业版,请问两个为数据库能互访吗?若可以,怎么才能实现?谢谢赐教

你可以这么做
transaction mytrans1,mytrans2
mytrans1=create transaction
mytrans2=create transaction
mytrans1.dbms="驱动程序类型"
mytrans1.dbparm="这里填连接sql6.5的字串"
mytrans2.dbms="驱动程序类型"
mytrans1.dbparm="这里填连接sql7.0的字串"
connect using mytrans1;
connect using mytrans2;
剩下的你知道该怎么做了?

eg:
transaction mytrans1,mytrans2
mytrans1=create transaction
mytrans2=create transaction
mytrans1.dbms = "odbc"
mytrans1.autocommit = false
mytrans1.dbparm = "connectstring=''dsn=yourdsnforsql6.5db''"
connect using mytrans1;
if mytrans1.sqlcode = -1 then
messagebox("",yourmessage)
disconnect using mytrans1;
halt
end if

mytrans2.dbms = "odbc"
mytrans2.autocommit = false
mytrans2.dbparm = "connectstring=''dsn=yourdsnforsql7.0db''"
connect using mytrans2;