已知SQLlite的資料庫名為aaa.db,密碼為：ccss 請問怎樣在PB12連接這個帶密碼的aaa.db
registryset("HKEY_LOCAL_MACHINE\software\odbc\ODBCINST.INI\SQLite3 ODBC Driver","Driver",regstring!,'c:sqlite3odbc.dll')
registryset("HKEY_LOCAL_MACHINE\software\odbc\ODBCINST.INI\SQLite3 ODBC Driver","Setup",regstring!,'c: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","aaa",regstring!,'SQLite3 ODBC Driver')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Database",regstring!,'c:\aaa.db')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Description",regstring!,'')
registryset("HKEY_CURRENT_USER\software\odbc\ODBC.INI\sqws","Driver",regstring!,'c: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 ='c:\aaa.db'
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = true
SQLCA.DBParm = "ConnectString='DSN=aaa;database="+ls_database+";PWD=ccss'"
以上方法我已經試過，不行。
請高手賜教！
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熱心網友回復：
你的問題很簡單:那就是鏈接資料庫的動態庫(sqlite3odbc.dll)要與建庫的動態庫(sqlite3.dll)相同.
這樣才能保存加密解密的一致性. 不要錯誤的認為它們是通用的, 記住: 開源的東西很難有人給你來做兼容性, 都是各自為陣,各搞各的.
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/75009.html
標籤：數據庫相關