[Gambas-user] Seg fault, rev 3903, odbc db selecting... how to...

[Ricardo Díaz Martín]

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 <Gambas at ...1950...>

> 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 <Gambas at ...1950...>
> >         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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>