PB9中如何动态连接远程数据库
有大虾说这样做:
建一个conn.ini文件:
内容:
[Database]
DBMS=MSSQL SQL Server 2000
Database=elite
UserId=
DatabasePassword=
LogId=sa
LogPassword=admin
ServerName=IP地址
DbParm=
Lock=
Prompt=0
clicked事件中这样写:
sqlca.DBMS = ProfileString ("conn.INI", "database", "dbms", "")
sqlca.database = ProfileString ("conn.INI", "database", "database", "")
sqlca.logid = ProfileString ("conn.INI", "database", "logid", "")
sqlca.logpass = ProfileString ("conn.INI", "database", "LogPassWord","")
sqlca.servername=ProfileString("conn.INI","database", "servername", "")
sqlca.dbparm = ProfileString ("conn.INI", "database", "dbparm", "")
sqlca.autocommit=true;
connect using sqlca;
if sqlca.sqlcode<>0 then
MessageBox("错误提示","无法连接数据库",question!)
HALT Close
return
else
MessageBox("提示","连接数据库成功",question!)
end if
不知道为什么连接不上,服务器的用户名是:sa 密码是:admin
我都填上了。不知道为什么连接不上数据库,郁闷中!!!