Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

帖子地址:http://gcdn.gcpowertools.com.cn/showtopic-21597-1-1.html

1.添加数据源,选择ODBC驱动,输入连接字符串

下载链接:http://www.ch-werner.de/sqliteodbc/

SQLite的连接字符串不正确导致的。
连接字符串中应包含:  DRIVER=SQLITE3 ODBC DRIVER;DATABASE=C:\Users\Documents\SQLite_Test1.db


2. 添加数据集

SELECT * FROM MAIN.Customers


3. 在数据集中添加参数,使用“?”占位符来代替参数引用

如SELECT * FROM MAIN.Customers
WHERE  CustomerID= ? 




  • No labels