PB connects to access through ODBC or oledb

PB connects to access through ODBC or oledb

1. ODBC
1.1 create 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
Sqlca. dbparm = "connectstring = 'dsn = MS Access database; Pwd = password; DBQ = database name '"
MS Access database this is installed after MDAC default has such an odbc dsn, can be used 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 '"