Connect A Database Thru ODBC WITHOUT DSN

xiaoxiao2021-03-06  14

In PowerBuilder, You CONNECT A DATABASE thRU ODBC, But no need to create a dobc DNS. For Example, To Connect A MS Access Database (.mdb):

string ls_connstrstring ls_dbname = d: /database.mdbls_connstr = "ConnectString = 'driver = {Microsoft Access Driver (* .mdb)}; dbq =" ls_dbname "'" SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = trueSQLCA.DBParm = LS_ConnstrConnect Using Sqlca; if Sqlca.sqlcode <> 0 Then MessageBox ('Connect Error ", Sqlca.sqlerrtext) Endix

Handiz@163.com; handiz@gmail.com

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

New Post(0)