PowerBuilder Connect SQLite Using ODBC
Step 1: Get driver ODBC SQLite sqlite3odbc.dll from page : http://www.ch-werner.de/sqliteodbc/
Step 2: Registry Regedit With Run file .Reg or PowerBuilder Function RegistrySet()
Step 3: Test Connect
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
String ls_dbSQLite, ls_db ls_dbSQLite = "C:\sqlite.db" //sqlite.sqlite ls_db = "PBSQLITE" Transaction ltran_conn ltran_conn = Create Transaction Disconnect Using ltran_conn ; RegistrySet("HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\"+ls_db+"","AutoStop",RegString!,"yes") RegistrySet("HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\"+ls_db+"" ,"Database",RegString!,ls_dbSQLite) RegistrySet("HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\"+ls_db+"" ,"Driver",RegString!,"sqlite3odbc.dll") // Using ODBC Connect To SQLite ltran_conn.DBMS = "ODBC" ltran_conn.AutoCommit = False ltran_conn.DBParm = "ConnectString='DSN=" + ls_db + "'" Connect Using ltran_conn ; If ltran_conn.SQLCode = -1 Then MessageBox('Warning','Connect Database Error' + ltran_conn.SQLErrText) Else MessageBox('Warning',"Connect Success!") End If Disconnect Using ltran_conn ; |
Find Projects On Github click here
Good Luck!
I would like to thank very Much the builder of the sqlite odbc for powerbuilder. It works very well and allowed me to transfer my Software Expertizers from Sqlanywhere to sqlite. Same functionalities and performance. Many thanks and join me on linkedin #expertizers.
sqlanywhere is way more capable and features rich than sqlite,
mainly the ability of stored procedures and functions. let alone being able to write java library inside a SQLAW db
Excellent read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch because I located it for him smile So let me rephrase that: Thanks for lunch!
How come this site is so slow? Takes like 20 seconds for this page to load!
As a Newbie, I am always exploring online for articles that can help me. Thank you
Utterly understand what your stance in this matter. Though Id disagree on some of the finer particulars, I think you did an superior job explaining it. Certain beats having to analysis it on my own. Thanks. Anyway, in my language, there arent a lot good supply like this.
belinski harp contrivance observe Selma boxington wireless scapula joggle
I’m really impressed with your writing skills as well as
with the layout on your weblog. Is this a paid theme or did you customize it yourself?
Either way keep up the excellent quality writing, it’s rare to see a nice blog like this one today.