[Gambas-user] Seg fault, rev 3903, odbc db selecting... progress!
Caveat
Gambas at ...1950...
Thu Jun 30 09:52:19 CEST 2011
Thank you so much Ricardo... now I don't get the signal 11 any more...
no time today as IRL I have to go out on an emergency fix job for a
client, but I'll get back to it later.
I'll keep you posted but it looks good for starting to get somewhere at
last...the connect worked!
Thanks again and best regards,
Caveat
On Thu, 2011-06-30 at 09:46 +0200, Ricardo Díaz Martín wrote:
> 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
>
>
More information about the User
mailing list