PowerBuilder如果连接SQL数据库?

[mynamelj]

初学者还望各位指点!

[qinluo]

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "YourDatabaseName"
SQLCA.LogPass = "yourpassword"
SQLCA.ServerName = "yourServerNname OR IP"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
不就好了么，唉

• 打赏
• 举报

回复 赞

[daijintao]

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "数据库名称"
SQLCA.LogPass = "登陆数据库的密码"
SQLCA.ServerName = "服务器名称"
SQLCA.LogId = "登陆数据库的id"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

Connect Using SQLCA;

IF SQLCA.SQLCode <> 0 THEN
MessageBox("信息提示", "无法与数据库连接，请与管理员联系！")
HALT
END IF

• 打赏
• 举报

回复 赞

[召棠]

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "DBName"
SQLCA.LogPass = "password"
SQLCA.ServerName = "ServerName"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

Connect Using SQLCA;

• 打赏
• 举报

回复 赞

[plming]

在PB中数据库连接配置中设定好连接，察看其Preview的配置语句，copy就可以了
不要对每个数据库都记

• 打赏
• 举报

回复 赞

[mynamelj]

非常感谢!

• 打赏
• 举报

回复 赞

[windy_jdf]

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "DBName"
SQLCA.LogPass = "password"
SQLCA.ServerName = "ServerName"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

Connect Using SQLCA;

• 打赏
• 举报

回复 赞

[cxwsoftware]

同意楼上
SQLCA是默认事务
你自己可以新建的

• 打赏
• 举报

回复 赞