PB怎样连接加密过的sqlLite数据库

F12YLING 2011-05-22 11:29:21
关键:怎样对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根本没用,在网上看了些帖子,都很复杂,请各位高手解答!
...全文
522 点赞 收藏 5
写回复
5 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
wangleibo1 2011-09-14
楼主可能是加密与解密的动态库不同引起.
我现在是碰到读70个列的表时, PB报错,郁闷. 直接用SQL语句没有问题, 用PB环境就异常退出.
回复
F12YLING 2011-06-02
楼上的方法均试过,还是不行!
回复
yyoinge 2011-05-23
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
回复
yyoinge 2011-05-23
SQLCA.DBParm = "ConnectString='DSN=sqws;UID=;PWD=zkss2011"
指定了DSN了就不需要再设置database了, 另外是否需要用户名UID呢
回复
yyoinge 2011-05-23
你的SQLite是怎么加密的呢
回复
相关推荐
发帖
数据库相关
创建于2007-09-28

734

社区成员

PowerBuilder 数据库相关
申请成为版主
帖子事件
创建了帖子
2011-05-22 11:29
社区公告
暂无公告