1.一定要将pb8升级到8.04或更高,,,否则在使用数据库管理面板时经常会无缘无故的关掉,,,特别是在使用oledb时...
2.在使用oledb时连接access用pb8编辑表结构不好,不比直接用office来编辑,,,使用的联接参数如下,,,
// Profile aaaaabc
SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='d:\test.mdb'"
或者
// Profile aaaaabc
SQLCA.DBMS = "OLE DB"
SQLCA.LogId = "admin"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='d:\test.mdb'"
如果要联系sqlserver时还要加上 database=数据库名 在extented properties扩展属性中...
结查如下
// Profile sqlserver7
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <******>
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='B2',PROVIDERSTRING='database=guide'"