pb12.5连sqlserver的问题

[zgxer]

pb12.5连sql2005，和sql2008，dbparm 的参数有区别？连2005不需要PROVIDER='SQLNCLI10'？

[DD]

// Profile dtxskq05
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <********>
SQLCA.ServerName = "hpserver\sql2005"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='dtxskq05'"

这个是我在PB11.5下连接SQL2005的配置，应该一样的吧，希望能帮到你

[zf_08]

SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <********>
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "DATASOURCE='10.24.12.159\mss05',PROVIDER='SQLOLEDB'"

这是我用pb12连05的，希望有用对你