pb直连SQL SERVER数据库的连接语句怎样写

tengy 2002-11-06 08:36:14

...全文

120 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

wgy2008 2002-11-06

打赏
举报

SQLCA.DBMS = ProfileString("pb.ini","Database","DBMS","")
SQLCA.DATABASE = ProfileString("pb.ini","Database","Database","")
SQLCA.DbParm = ProfileString("pb.ini","Database","DbParm","" )
SQLCA.LogId = ProfileString("pb.ini","Database","LogId","")
SQLCA.LogPass = ProfileString("pb.ini","Databse","LogPass","")
SQLCA.ServerName = ProfileString("pb.ini","Database","ServerName","")
SQLCA.UserId = ProfileString("pb.ini","Database","UserId","")

mmkill 2002-11-06

打赏
举报

// Profile
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "yx_ser" //数据库名
SQLCA.ServerName = "server" //服务器名
SQLCA.LogId = "sa" //数据库登录名
SQLCA.AutoCommit = False //很关键
SQLCA.DBParm = ""
Connect; //连接数据库

winwhere 2002-11-06

打赏
举报

// Profile northwind
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "northwind" //数据库名
SQLCA.ServerName = "ztsrv" //服务器名
SQLCA.LogId = "sa" //数据库登录名
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

pbtech 2002-11-06

打赏
举报

或者
//设置参数从pb.ini提取出来
SQLCA.DBMS = ProfileString("pb.ini","Database","DBMS","")
SQLCA.DATABASE = ProfileString("pb.ini","Database","Database","")
SQLCA.DbParm = ProfileString("pb.ini","Database","DbParm","" )
SQLCA.LogId = ProfileString("pb.ini","Database","LogId","")
SQLCA.LogPass = ProfileString("pb.ini","Databse","LogPass","")
SQLCA.ServerName = ProfileString("pb.ini","Database","ServerName","")
SQLCA.UserId = ProfileString("pb.ini","Database","UserId","")

pbtech 2002-11-06

打赏
举报

建立一个mss ms sql6.x一个连接后，在preview那里copy database connectino syntax 放到程序就可以
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "hospitals"
SQLCA.ServerName = "TJ-0HZSR6BA4ZHU"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
connect using sqlca ;