Caveat, After my last post, I was trying to connect to mdb file using ODBC in Ubuntu 11.04. I can connet using isql with no problems (connection is ok and I can exec some basics "select").
You got a mistake in the code above. Try: PRIVATE myDB as NEW Connection ... WITH myDB .Type = "odbc" .Host = "PutHereTheNameOfTheDatabaseDSN" '<- the name from /etc/odbc.ini whitout [ ]. In my obc.ini example, I have to put test .Login = "Admin" ' <- It's necesary. Don't be in blank .Name = "" '-> in odbc keep always in blank END WITH TRY myDB.Open An example of a odbc.ini to a mdb file [test] Description = TestDatabase Driver = /usr/lib/libmdbodbc.so.0 Database = /home/ricardo.diaz/Escritorio/EstudiosEconomicosAuxiliares.mdb I can connect to mdb file using ODBC from gambas3 but I get no data when I exec any sql sentences. I think it's some problem with libmdbodbc because from openoffice base I can connect but after I can't see any tables in the schema. More tests with other odbc databases drivers are necessary. Regards, 2011/6/29 Caveat <gam...@caveat.demon.co.uk> > Thanks Ricardo > > I just tried back in Gambas2 and got a sig11 <sigh> > > I used > PRIVATE myDB as NEW Connection > ... > WITH myDB > .Type = "odbc" > .Host = "localhost" > .Login = "Admin" > .Name = "E4Y" > END WITH > > TRY myDB.Open > > I think it may be time to give up on Gambas (for *this* task) and look > at Java. > > Regards, > Caveat > > On Wed, 2011-06-29 at 15:50 +0200, Ricardo Díaz Martín wrote: > > Hi Caveat, > > > > You can look for Ian Roper in this mailing list. I remember he was to > > be able to to. > > > > go http://sourceforge.net/mailarchive/message.php?msg_id=26630386 > > > > Regards, > > Ricardo Díaz > > > > 2011/6/29 Caveat <gam...@caveat.demon.co.uk> > > Hi Rolf, > > > > Many thanks for the reply. Yes, I do have libmdbodbc > > installed, and the > > mdbtools. The Gnome MDB Viewer I mention is just a kind of > > GUI wrapper > > on top of the mdbtools MDB File Viewer, and that is all > > working fine. > > > > I see tables, reports, forms, and macros in the database. > > > > I have the mdb odbc driver installed (libmdbodbc.so.0) and an > > entry > > defined in odbc.ini as per my previous mail, but it seems > > Gambas3 can't > > even see that entry. > > > > So my question is intended as a kind of sanity-check... does > > someone > > else have odbc working with Gambas3? > > > > Thanks and regards, > > Caveat > > > > > > > > On Wed, 2011-06-29 at 10:29 +0200, Rolf Schmidt wrote: > > > Caveat: > > > > > > ODBC is not the problem. > > > The problem is an odbc driver for mdb-files > > > > > > > The .mdb file has no password set on it. > > > > > > As far as I could see there is a very limited version of the > > driver > > > available. > > > Do you have "libmdbodbc" installed? Can you access your mdb > > file with > > > the "MDB File Viewer" i.e. have you install the mdbtools > > (incl. > > > mdbtools-gmdb - which has the MDB-File-Viewer). > > > > > > HTH > > > Rolf > > > > > > > > > ------------------------------------------------------------------------------ > > All of the data generated in your IT infrastructure is > > seriously valuable. > > Why? It contains a definitive record of application > > performance, security > > threats, fraudulent activity, and more. Splunk takes this data > > and makes > > sense of it. IT sense. And common sense. > > http://p.sf.net/sfu/splunk-d2d-c2 > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > > > > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user