WinGRASS 6.4.1: SQLite driver errors: `Unable to open database'
|Reported by:||rvanderweide||Owned by:|
|Keywords:||wingrass, SQLite driver||Cc:|
I keep on getting SQLite driver errors when trying to use a newly created SQLite database ('unable to open database'). By default, GRASS starts up connected to DBF. Connecting to an SQLite database works fine -- when the database does not yet exist, it seems to create an empty database, but i can't seem to access it. For example, errors emerge when i wish to import a shapefile, OR copy an attribute table from a shapefile that was previously imported using the DBF driver. I recall that an earlier version of GRASS 6.4 used SQLite as the default driver. With this version, all worked well, i.e. i did NOT have the problems described below.
Let me attach the command lines for both examples:
(1) Problem importing shapefile while connected to a SQLite database:
GRASS 6.4> db.connect driver=sqlite database="c:\Test\sqlite.db" GRASS 6.4> v.in.ogr dsn=C:\Test\pse.shp layer=pse output=pse Datum <Palestine_1923> not recognised by GRASS and no parameters found Projection of input dataset and current location appear to match Layer: pse DBMI-SQLite driver error: Unable to open database: unable to open database file Unable to open database <c:\test\sqlite.db> by driver <sqlite> ERROR: Unable open database <c:\test\sqlite.db> by driver <sqlite> (Fri May 06 13:33:01 2011) Command finished (0 sec)
(2) Problem copying attribute table (imported in DBF) to SQLite database):
GRASS 6.4> db.connect driver=sqlite database="c:\Test\sqlite.db" GRASS 6.4> g.copy vect=pse@pov4,pse_sqlite Copy vector <pse@pov4> to current mapset as <pse_sqlite> DBMI-SQLite driver error: Unable to open database: unable to open database file
WARNING: Unable to open database <sqlite> by driver <c:\Test\sqlite.db> no database is open WARNING: Unable to copy table <pse_sqlite> WARNING: Cannot copy <pse@pov4> to current mapset as <pse_sqlite>