關鍵：怎樣對SQLlite資料庫加密？加密后怎樣連接。
registryset("HKEY_LOCAL_MACHINE\software\odbc\ODBCINST.INI\SQLite3 ODBC Driver","Driver",regstring!,gs_buffer+'\sqlite3odbc.dll')
registryset("HKEY_LOCAL_MACHINE\software\odbc\ODBCINST.INI\SQLite3 ODBC Driver","Setup",regstring!,gs_buffer+'\sqlite3odbc.dll')
registryset("HKEY_LOCAL_MACHINE\software\odbc\ODBCINST.INI\SQLite3 ODBC Driver","UsageCount",ReguLong! ,1)
registryset("HKEY_LOCAL_MACHINE\software\odbc\ODBCINST.INI\ODBC Drivers","SQLite3 ODBC Driver",regstring!,'Installed')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\ODBC Data Sources","sqws",regstring!,'SQLite3 ODBC Driver')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Database",regstring!,gs_buffer+'\資料庫.DB')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Description",regstring!,'')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Driver",regstring!,gs_buffer+'\sqlite3odbc.dll')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","LoadExt",regstring!,'')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","LongNames",regstring!,'0')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","NoCreat",regstring!,'0')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","NoTXN",regstring!,'0')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","NoWCHAR",regstring!,'1')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","ShortNames",regstring!,'0')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","StepAPI",regstring!,'0')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","SyncPragma",regstring!,'NORMAL')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Timeout",regstring!,'100000')
ls_database = gs_buffer+'\sqws.mic'
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = true
SQLCA.DBParm = "ConnectString='DSN=sqws;database="+ls_database//+"';PWD=zkss2011"
connect using sqlca;
加PWD根本沒用，在網上看了些帖子，都很復雜，請各位高手解答！
uj5u.com熱心網友回復：
你的SQLite是怎么加密的呢uj5u.com熱心網友回復：
SQLCA.DBParm = "ConnectString='DSN=sqws;UID=;PWD=zkss2011"指定了DSN了就不需要再設定database了， 另外是否需要用戶名UID呢
uj5u.com熱心網友回復：
SQLCA.DBParm = "ConnectString='內容'"內容試著這么寫：
1.
Provider=MSDASQL.1;Extended Properties="Driver={SQLite3 ODBC Driver};Database=C:\SampleDB.db;PWD=123456;"
2.
DSN=SQLite3 Datasource;Database=C:\SampleDB.db;PWD=123456;
3.
Driver=SQLite3 ODBC Driver;Database=C:\SampleDB.db;PassWord=123456
uj5u.com熱心網友回復：
樓上的方法均試過，還是不行！uj5u.com熱心網友回復：
樓主可能是加密與解密的動態庫不同引起.我現在是碰到讀70個列的表時, PB報錯,郁悶. 直接用SQL陳述句沒有問題, 用PB環境就例外退出.
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/75012.html
標籤：數據庫相關