有高手进来帮我解决这个动态数据库连接问题吗??急急急!!!
我通过SQLCA做了个动态的SQL数据库连接,我用的是PB8+SQLServer2K个人版,因为系统是XP。在DBprofiles里连接数据库成功,但是动态连接就不通了,不知道哪里出了错,高手来帮我看下哈.....
应用对象open事件里脚本如下:
string startupfile='文件名'
sqlca.DBMS = ProfileString (startupfile, "database", "dbms", "")
sqlca.database = ProfileString (startupfile, "database", "database", "")
sqlca.userid = ProfileString (startupfile, "database", "userid", "")
sqlca.dbpass = ProfileString (startupfile, "database", "dbpass", "")
sqlca.logid = ProfileString (startupfile, "database", "logid", "")
sqlca.logpass = ProfileString (startupfile, "database", "LogPassWord", "")
sqlca.servername = ProfileString (startupfile, "database", "servername", "")
sqlca.DBParm = profileString (startupfile, "database", "dbparm", "")
SQLCA.AutoCommit = false
Connect using SQLCA;
IF SQLCA.SQLCODE <> 0 THEN
MESSAGEBOX('提示','数据库连接失败,请稍后再试!')
RETURN
END IF
string ls_sql="SET QUOTED_IDENTIFIER ON"
EXECUTE IMMEDIATE :ls_sql;
If SQLCA.SQLCode <> 0 Then
MessageBox ("Cannot Connect to Database", SQLCA.SQLErrText )
return
End If
open(.....)
文件内容如下:
[Database]
DBMS=MSS Microsoft SQL Server 6.x
Database=数据库名
UserId=
DatabasePassword=
LogPassword=
ServerName=SQL服务器名
LogId=sa
Lock=
DbParm=StaticBind=0
Prompt=0
AutoCommit=1
没设密码的,SQL登陆是混合模式
有什么地方写错了吗??还是SQLServer是个人版的原因???系统和SQL都重装过问题还是没变。。。。。。
急啊~~~~~~谁来帮帮我哦,谢谢啦!!!