怎样设置PB程序直接连接SQL Server2000数据库?

[fifa]

我想将SQLCA直接与SQL Server2000连接，不通过ODBC,
应该怎样设置SQLCA的相关属性

[tchatcha]

up
主要是sql server2000要用混合模式才行

[wuhanjuan]

单击database图标 然后按步操作就可以了吧。。。。

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "你的数据库名称"
SQLCA.ServerName = "你的计算机名称"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
好象不是很难，不过难表达
试试看吧

[coolnan]

// ini文件动态连接
SQLCA.DBMS = ProFileString("db.ini","DataBase","DBMS","")
SQLCA.DataBase = ProFileString("db.ini","DataBase","DataBase","")
SQLCA.LogID = ProFileString("db.ini","DataBase","LogID","")
SQLCA.LogPass = ProFileString("db.ini","DataBase","LogPass","")
SQLCA.ServerName = ProFileString("db.ini","DataBase","ServerName","")

//db.ini文件内容
[DataBase]
DBMS=MSS Microsoft SQL Server 2000
DataBase=Pub
LogId=sa
LogPass=*******
ServerName=(local)
AutoCommit=TRUE

[lihuihit]

配置sqlca的链接参数便可

楼上的都行
coolnan(天涯海阁) 的方法
比较灵活
推荐采用

[你的昵称已存在]

up

[runsoft]

// Profile HwMain
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "Hwmain"
SQLCA.ServerName = "runsoft"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""

[jeff_107]

SQLCA.DBMS="MSS Microsoft SQL Server 6.x"
SQLCA.DATABASE='databasename'
SQLCA.LOGID='sa'
SQLCA.LOGPASS='123'
SQLCA.SERVERNAME='192.168.10.11'
SQLCA.DBPARM="CommitOnDisconnect='No'"

[guojing590]

string sqlserver_set_file
string sqlserver_name
string sqlserver_data_name,sqlserver_data_ip
sqlserver_set_file = "sqlserver_setup.ini"
//操作配置文件，功能是
sqlserver_name = "sqlserver set"
sqlserver_data_name = ProfileString (sqlserver_set_file, sqlserver_name, "name", "")
sqlserver_data_ip = ProfileString (sqlserver_set_file, sqlserver_name, "ip", "")
RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo", &
sqlserver_data_name, RegString!, sqlserver_data_ip)

string ls_startupfile
string ls_db
ls_startupfile="setup.ini"
ls_db="PROFILE xsdapb"

sqlca.DBMS = ProfileString (ls_startupfile, ls_db, "dbms", "")
sqlca.servername = ProfileString (ls_startupfile, ls_db, "servername", "")
sqlca.database = ProfileString (ls_startupfile, ls_db, "database", "")
sqlca.logid = ProfileString (ls_startupfile, ls_db, "logid", "")
sqlca.dbparm = ProfileString (ls_startupfile, ls_db, "dbparm", "")
SQLCA.AutoCommit = False

setup.ini的内容如下：
[Profile xsdapb]

DBMS =MSS Microsoft SQL Server 6.x
Database =xsdadb
ServerName =210.44.16.14(你所要连的sqlserver机的ip地址)
LogId =sa
AutoCommit = False
DBParm =