Registryset (" HKEY_LOCAL_MACHINE \ software \ odbc \ ODBCINST INI \ SQLite3 odbc Driver "and" 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! 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 ", "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 "and" 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'
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=true
The SQLCA. DBParm="ConnectString='DSN=aaa; The database="+ ls_database +"; The PWD=CCSS '"
The above methods I've tried, no,
Please grant instruction!
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:
Your question is very simple:That is the dynamic library link database (sqlite3odbc. DLL) to build library dynamic library (sqlite3. DLL) are the same.
So as to keep the consistency of encryption to decrypt. Don't mistakenly believe that they are universal, remember: what open source is hard to someone to give you to do the compatibility, as are the, each to each.