Key: how to SQLlite databases encryption? Encrypted connection,
Registryset (" HKEY_LOCAL_MACHINE \ software \ odbc \ ODBCINST INI \ SQLite3 odbc Driver "and" 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! The 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 + '\ database. DB)
Registryset (" HKEY_CURRENT_USER \ software \ odbc \ odbc.ini \ SQWS ", "Description", regstring! ', ')
Registryset (" HKEY_CURRENT_USER \ software \ odbc \ odbc.ini \ SQWS "and" 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'
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=true
The SQLCA. DBParm="ConnectString='DSN=SQWS; The database="+ ls_database//+" '; The PWD=zkss2011 "
Connect using the sqlca;

Add the PWD is useless, watched some posts on the Internet, are very complicated, please expert to solve!

CodePudding user response:

What's the matter with your SQLite is encrypted

CodePudding user response:

The SQLCA. DBParm="ConnectString='DSN=SQWS; UID=; The PWD=zkss2011 "
Specifies the DSN don't need to set up the database again, whether you need another user name UID

CodePudding user response:

The SQLCA. DBParm="ConnectString='content'"
Try to write so:
1.
The Provider=MSDASQL. 1; Extended Properties="Driver={SQLite3 ODBC Driver}; The Database=C: \ SampleDB. Db; The PWD=123456;"

2.
DSN=SQLite3 Datasource. The Database=C: \ SampleDB. Db; The PWD=123456;

3.
Driver=SQLite3 ODBC Driver; The Database=C: \ SampleDB. Db; PassWord=123456

CodePudding user response:

Methods are tried, upstairs or not!

CodePudding user response:

The landlord may be different dynamic library cause of encryption and decryption.
Now I have read 70 columns of table, PB error, depressed. Use SQL statements directly no problem, abnormal exit with PB environment.