连接字符串是:Driver=SQLite3 ODBC DriverDatabase=数据库路径。
可能是ODBC方式,某些权限受到限制吧(比如不能查master表),这种方式我没用过,我现在是用vb.net,用connecting 、adapter 等访问的,这样好像没有遇到过问题。例如:
Dim DataSource As String, sql As String
Dim conn As SQLite.SQLiteConnection
DataSource = Application.StartupPath + "\StoreExecl.db"
' //连接数据库
conn = New SQLite.SQLiteConnection()
Dim connstr As SQLite.SQLiteConnectionStringBuilder = New SQLite.SQLiteConnectionStringBuilder()
connstr.DataSource = DataSource
Try
conn.ConnectionString = connstr.ToString()
conn.Open()
Me.RTxt1.Text = "系统已连接本地数据库,成功!"
catch
endtry
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)