用OLE DB连接ACCESS数据库,有什么不对呢?
代码:
SQLCA.DBMS = "OLE DB"
SQLCA.AutoCommit = False
MessageBox("", "PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='"+ GetCurrentDirectory() +"\data.mdb'")
SQLCA.DBParm = "PROVIDER='Microsoft.Jet.OLEDB.4.0',DATASOURCE='"+ GetCurrentDirectory() +"\data.mdb'"
//SQLCA.DBMS="ODBC"
//SQLCA.AutoCommit=False
//SQLCA.DBParm="ConnectString='DSN=PlayRent;UID=;PWD='"
connect using SQLCA;
结果:
---------------------------
启动失败!
---------------------------
DBMS OLE DB is not supported in your current installation.
---------------------------
确定
---------------------------
我在Delphi中用这样的语句:
StrConn:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+ExtractFilePath(Application.ExeName)+'DB.mdb;Jet OLEDB:Database Password=;Persist Security Info=False';
ADOCn.ConnectionString:=StrConn;
ADOCn.Open();
是完全没有问题的,也就是说Microsoft.Jet.OLEDB.4.0的Provider在我的机器上是存在的,在PB中怎么就用不了呢?