PB Connect Access via ODBC or OLEDB

xiaoxiao2021-03-13  188

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'"

转载请注明原文地址:https://www.9cbs.com/read-129070.html

New Post(0)