如何实现在pb中同时连接两个sql数据库~~

[freeguestx]

例如同时连接master 和 sqltest数据库，该如何实现，请写出详细代码~~谢谢

[嘘嘘兔]

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "master "
SQLCA.LogPass = 'password'
SQLCA.ServerName = "server name"
SQLCA.LogId = "user"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
connect using sqlca;

trans_sqltest=create transaction
trans_sqltest.DBMS = "MSS Microsoft SQL Server 6.x"
trans_sqltest.Database = "sqltest"
trans_sqltest.LogPass = 'password'
trans_sqltest.ServerName = "server name"
trans_sqltest.LogId = "user"
trans_sqltest.AutoCommit = False
trans_sqltest.DBParm = ""
connect using trans_sqltest;

[艳阳天11]

定义两个事务对象就是了

[feixianzhi]

trans_sqltest=create transaction //定义另外一个连接对象，sqlca是系统默认的
trans_sqltest.DBMS = "MSS Microsoft SQL Server 6.x"
trans_sqltest.Database = "sqltest"
trans_sqltest.LogPass = 'password'
trans_sqltest.ServerName = "server name"
trans_sqltest.LogId = "user"
trans_sqltest.AutoCommit = False
trans_sqltest.DBParm = ""
connect using trans_sqltest;

用此方法可以连接多个数据库！

[chenlong9610]

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "master "
SQLCA.LogPass = 'password'
SQLCA.ServerName = "server name"
SQLCA.LogId = "user"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
connect using sqlca;

transaction trans_sqltest(先定义trans_sqltest)
trans_sqltest=create transaction
trans_sqltest.DBMS = "MSS Microsoft SQL Server 6.x"
trans_sqltest.Database = "sqltest"
trans_sqltest.LogPass = 'password'
trans_sqltest.ServerName = "server name"
trans_sqltest.LogId = "user"
trans_sqltest.AutoCommit = False
trans_sqltest.DBParm = ""
connect using trans_sqltest;

[amekoxiao]

定义两个事务处理，create 一个事务对象就可以了

[freeguestx]

二楼的兄弟

trans_sqltest=create transaction 发生错误

undefined variable : transaction

再次请求帮忙

[freeguestx]

ok封贴

[thelazyman]

创建事物,要先声明事物对象!!

transaction trans_sqltest //声明事物对象
trans_sqltest=create transaction
......

[TGWall]

解决了吧

[wscft]

对，要先声明事务对象，
transaction SQLCA_1 //声明事物对象
SQLCA_1 = create transaction

[freeguestx]

上面的连接是可以了，但是还是无法同时操作阿