Re: [gnome-db] How to use with SQLite ?

[Vivien Malerba <vmalerba gmail com>]

2005/8/3, e-Jah <e-Jah ejahworld net>:
> Le mercredi 03 août 2005 à 13:49 +0200, Vivien Malerba a écrit :
> > On 8/3/05, e-Jah <e-Jah ejahworld net> wrote:
> > > Hi,
> > >
> > > I try to access to my SQLite database with mergeant, but when i click on
> > > connect i get the message error "could not open the connection to the
> > > DBMS for datasources 'mySQLiteDB'"
> > >
> > > My ~/.libgda/config is :
> > > $ cat ~/.libgda/config
> > > <?xml version="1.0"?>
> > > <libgda-config>
> > >   <section path="/apps/libgda/Datasources/mySQLiteDB">
> > >     <entry name="DSN" type="string"
> > > value="URI=/home/ejah/Coding/Gecca/Gecca/Camps/Camps.db"/>
> > >     <entry name="Description" type="string" value="Test of SQLite
> > > provider"/>
> > >     <entry name="Password" type="string" value=""/>
> > >     <entry name="Provider" type="string" value="SQLite"/>
> > >     <entry name="Username" type="string" value=""/>
> > >   </section>
> > > </libgda-config>
> > >
> >
> > Can you tell me about the versions of libgda/libgnomedb/mergeant you are using?
> 
> Of course:
> ii  libgda2-1      1.1.99-1       GNOME Data Access library for GNOME2
> ii  libgnomedb2-3  1.1.99-1ubuntu Database UI widget library for GNOME2
> ii  mergeant       0.52-1~5.04ubp GNOME Database admin tool GUI for
> GNOME2
> 
> $ mergeant --version
> Gnome mergeant 0.52
> 
> For the database I try with a sqlite db and a sqlite3 db and the results
> are the same.

A lot of work has gone into the SQLite provider lately and It works
quite nicely for me.

As the problem does not come from the config file, I suggest that you
take into account a more recent version of those libraries (1.3.4 or
CVS for example). In the new versions, the SQLite provider is embedded
with libgda (version 3.2.1 or 3.2.2).

Regards,

Vivien