Am Mittwoch, den 02.03.2016, 21:03 +0100 schrieb Markus Schatten: > Dear friends, > > I'm trying to do a simple thing, connect a DataSource to a ODBC > connection (unixODBC). The DSN points to a simple sqlite3 database > which has a table test(a integer, b varchar(10)) in it. The unixODBC > seems to be working fine, since I can connect to the database using > isql and see all defined tables and data. The problem is when I try to > do it with Gambas, when setting the Table attribute of DataSource I > get the error: > > Result is not available > > The connection seems to load the schema of the table (I can see a and > b in the header of the DataBrowser) but not the data. > > Here is what I do: > > ' Gambas class file > > Public $con As New Connection > > Public Sub _new() > $con.type = "odbc" > $con.Host = "sqlite" 'name of the DSN > $con.Login = "mylogin" > $con.Password = "mypass" > $con.port = "" > $con.name = "" > $con.Open > DataSource1.Connection = $con > Try DataSource1.Table = "test" > If Error Then > Print Error.Text > Print Error.Where > Print Error.Backtrace > Print Error.Class > Print Error.Code > Endif > > End > > The fun part is that the same code works fine with a PostgreSQL > database over the ODBC connection (no error is risen, both schema and > data are loaded fine into the DataBrowser). I'm using the following > entry in /etc/odbc.ini : > > [sqlite] > Description=My SQLite database > Driver=SQLite3 > Database=/home/markus/test.sqlite3 > UserName = mylogin > Password = mypass > > What am I doing wrong? > > All the best, > > M.
Salut Markus, does your sqlite3 tables have primary keys ? -- Amicalement Charlie ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
