我如何从SQLite检索数据到VB6？-howdoiretrievedatafromSQLitetoVB6?

3  

Refer here for the connection string properties: http://www.connectionstrings.com/sqlite

有关连接字符串属性，请参阅此处：http：//www.connectionstrings.com/sqlite

You should also specify the version (3 or 2).

您还应指定版本（3或2）。

Edit: try to remove: LOngNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0 And add the version: version=3 If it works, try to add a property at a time until it won't work anymore, to identify the broken property.

编辑：尝试删除：LOngNames= 0; Timeout = 1000; NoTXN = 0; SyncPragma = NORMAL; StepAPI = 0并添加版本：version = 3如果有效，请尝试一次添加一个属性，直到它不会工作了，找出破碎的财产。

2  

These are available connect string options for SQLite3 ODBC Driver

这些是SQLite3 ODBC Driver的连接字符串选项

Description=
Database=<
Timeout=
StepAPI=0
SyncPragma=
NoTXN=0
ShortNames=0
LOngNames=0
NoCreat=0
NoWCHAR=0
FKSupport=0
LoadExt=

I just created a system DSN and looked in registry at HKLM\SOFTWARE\ODBC\ODBC.INI\<>

我刚刚创建了一个系统DSN并在HKLM \ SOFTWARE \ ODBC \ ODBC.INI \ <>的注册表中查找