Dear friends,
is it possible to access the sqlite_master table through the ODBC
driver? I connect easily to an SQLite DSN, but when I try to query the
master table I get:
Unknown table: sqlite_master
Here is what I do:
' Gambas class file
Public $con As New Connection
Public Sub _new()
$con.type = "odbc"
$con.Host = "sqlite_dsn"
$con.Login = "login"
$con.Password = "password"
$con.Open
DataSource1.Connection = $con
Try DataSource1.Table = "sqlite_master"
If Error Then
Print Error.Text
Print Error.Where
Print Error.Backtrace
Print Error.Class
Print Error.Code
Endif
End
Also, when I try to select from the table, e.g.:
$con.Exec("SELECT * FROM sqlite_master")
I get an empty result set...
When I connect through the native SQLite driver, I can access the
table without problems, but with ODBC it doesn't work...
What am I doing wrong?
All the best,
M.
--
Markus Schatten, PhD
Assistant professor and head of Artificial Intelligence Lab
University of Zagreb
Faculty of Organization and Informatics
Pavlinska 2, 42000 Varazdin, Croatia
http://www.foi.hr/nastavnici/schatten.markus/index.html
http://www.researchgate.net/profile/Markus_Schatten1
http://ai.foi.hr
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
