I had recently a clean install of grass (6.2.3 from ubuntu
repositories) and grass 6.3.cvs (configured with
"--with-sqlite=yes", compiled and installed).
Yet, whenever I try to import a shapefile (created for
instance with OpenEV) I get an error "cannot open database
... .... / cannot open database ... ... by driver sqlite).
I have checked that sqlite is installed...
Any ideas?
...
Thank you,
Nikos
On Tue, January 8, 2008 12:37, nikos.alexandris@felis.uni-freiburg.de wrote:
I had recently a clean install of grass (6.2.3 from ubuntu
repositories) and grass 6.3.cvs (configured with
"--with-sqlite=yes", compiled and installed).Yet, whenever I try to import a shapefile (created for
instance with OpenEV) I get an error "cannot open database
... .... / cannot open database ... ... by driver sqlite).I have checked that sqlite is installed...
Any ideas?
What does db.connect -p tell you ?
Can you connect to the database with sqlite ?
Moritz
"> db.connect -p" gives:
driver:sqlite
database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
schema:(null)
group:(null)
( and in the gui of v.in.ogr, among other I get:
"DBMI-SQLite driver
error:
Cannot open database: unable to open database file" )
On Tue, 8 Jan 2008 12:55:48 +0100 (CET)
"Moritz Lennert" <mlennert@club.worldonline.be> wrote:
On Tue, January 8, 2008 12:37,
nikos.alexandris@felis.uni-freiburg.de wrote:
> I had recently a clean install of grass (6.2.3 from
ubuntu
> repositories) and grass 6.3.cvs (configured with
> "--with-sqlite=yes", compiled and installed).
>
> Yet, whenever I try to import a shapefile (created for
> instance with OpenEV) I get an error "cannot open
database
> ... .... / cannot open database ... ... by driver
sqlite).
>
> I have checked that sqlite is installed...
>
> Any ideas?What does db.connect -p tell you ?
Can you connect to the database with sqlite ?
Moritz
.
Nikos Alexandris - Ph.D. Candidate
.
Department of Remote Sensing
and
Landscape Information Systems
(FeLIS)
.
Faculty of Forestry and Natural Environment
Albert-Ludwigs-University Freiburg
.
Tel. +49 (0) 761 203 3697
Fax. +49 (0) 761 203 3701
Skype: Nikos.Alexandris
.
Address: Tennenbacher str. 4
D-79106 Freiburg i. Br.
Germany
.
The strange thing here is that you have the database driver set do
sqlite but the database set to dbf... Either change the driver to dbf
or the database to a sqlite file.
The db.connect man page has some nice exemples
http://grass.ibiblio.org/grass61/manuals/html61_user/db.connect.html
Daniel
On Jan 8, 2008 10:46 AM, <nikos.alexandris@felis.uni-freiburg.de> wrote:
"> db.connect -p" gives:
driver:sqlite
database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
schema:(null)
group:(null)( and in the gui of v.in.ogr, among other I get:
"DBMI-SQLite driver
error:
Cannot open database: unable to open database file" )On Tue, 8 Jan 2008 12:55:48 +0100 (CET)
"Moritz Lennert" <mlennert@club.worldonline.be> wrote:
> On Tue, January 8, 2008 12:37,
> nikos.alexandris@felis.uni-freiburg.de wrote:
> > I had recently a clean install of grass (6.2.3 from
> ubuntu
> > repositories) and grass 6.3.cvs (configured with
> > "--with-sqlite=yes", compiled and installed).
> >
> > Yet, whenever I try to import a shapefile (created for
> > instance with OpenEV) I get an error "cannot open
> database
> > ... .... / cannot open database ... ... by driver
> sqlite).
> >
> > I have checked that sqlite is installed...
> >
> > Any ideas?
>
> What does db.connect -p tell you ?
>
> Can you connect to the database with sqlite ?
>
> Moritz
>
>.
Nikos Alexandris - Ph.D. Candidate
.
Department of Remote Sensing
and
Landscape Information Systems
(FeLIS)
.
Faculty of Forestry and Natural Environment
Albert-Ludwigs-University Freiburg
.
Tel. +49 (0) 761 203 3697
Fax. +49 (0) 761 203 3701
Skype: Nikos.Alexandris
.
Address: Tennenbacher str. 4
D-79106 Freiburg i. Br.
Germany.
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user
On Tue, January 8, 2008 13:56, Daniel Victoria wrote:
The strange thing here is that you have the database driver set do
sqlite but the database set to dbf... Either change the driver to dbf
or the database to a sqlite file.
Just to complete: for the sqlite driver, the database is a file, not a
directory as for the dbf driver.
Moritz
Thank you a lot!
I never experienced the same problem in the past... So I
must have messed up something while re-installing
grass(6.2.3 and 6.3.svn... now).
On Tue, 8 Jan 2008 14:01:37 +0100 (CET)
"Moritz Lennert" <mlennert@club.worldonline.be> wrote:
On Tue, January 8, 2008 13:56, Daniel Victoria wrote:
> The strange thing here is that you have the database
driver set do
> sqlite but the database set to dbf... Either change the
driver to dbf
> or the database to a sqlite file.Just to complete: for the sqlite driver, the database is
a file, not a
directory as for the dbf driver.Moritz
.
Nikos Alexandris - Ph.D. Candidate
.
Department of Remote Sensing
and
Landscape Information Systems
(FeLIS)
.
Faculty of Forestry and Natural Environment
Albert-Ludwigs-University Freiburg
.
Tel. +49 (0) 761 203 3697
Fax. +49 (0) 761 203 3701
Skype: Nikos.Alexandris
.
Address: Tennenbacher str. 4
D-79106 Freiburg i. Br.
Germany
.
I followed the man page... and it works!
(db.connect driver=sqlite
database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db')
On Tue, 08 Jan 2008 14:08:41 +0100
nikos.alexandris@felis.uni-freiburg.de wrote:
Thank you a lot!
I never experienced the same problem in the past... So I
must have messed up something while re-installing
grass(6.2.3 and 6.3.svn... now).On Tue, 8 Jan 2008 14:01:37 +0100 (CET)
"Moritz Lennert" <mlennert@club.worldonline.be> wrote:
> On Tue, January 8, 2008 13:56, Daniel Victoria wrote:
> > The strange thing here is that you have the database
> driver set do
> > sqlite but the database set to dbf... Either change
the
> driver to dbf
> > or the database to a sqlite file.
>
> Just to complete: for the sqlite driver, the database
is
> a file, not a
> directory as for the dbf driver.
>
> Moritz