pb12.5连sqlserver的问题
pb12.5连sql2005,和sql2008,dbparm 的参数有区别?连2005不需要PROVIDER='SQLNCLI10'?
[解决办法]
// 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的配置,应该一样的吧,希望能帮到你
[解决办法]
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <********>
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "DATASOURCE='10.24.12.159\mss05',PROVIDER='SQLOLEDB'"
这是我用pb12连05的,希望有用对你