PB Connect Access via ODBC or OLEDB
1. ODBC 1.1 establish an ODBC data source 1.2 // profile sqlca.dbms = "ODBC" SQLCA.AUTOCOMMIT = false sqlca.dbparm = "connectString = 'DSN = Xtktv; uid = admin; pwd = 000000'"
2. Direct connection does not configure odbc, sqlca.dbparm = "connectstring = 'DSN = MS Access Database; PWD = password; DBQ = Database Name'" MS Access Database This is the default after installing MDAC, there is such an ODBC DSN, you can use it directly. // profile sqlca.dbms = "odbc" sqlca.autocommit = false sqlca.dbparm = "connectstring = 'DSN = MS Access Database; UID = admin; pwd = 000000; DBQ = xtktv.mdb'"
3. OLE DB / / PROFILE SQLCA.DBMS = "OLE DB" SQLCA.AUTOCOMMIT = false sqlca.dbparm = "provider = 'microsoft.jet.oledb.4.0', Datasource = 'h: /js.mdb'"