[GRASS-dev] [GRASS GIS] #1358: WinGRASS 6.4.1: SQLite driver errors: `Unable to open database'

[GRASS GIS]

#1358: WinGRASS 6.4.1: SQLite driver errors: `Unable to open database'
---------------------------+------------------------------------------------
 Reporter:  rvanderweide   |       Owner:  grass-dev@…              
     Type:  defect         |      Status:  new                      
 Priority:  normal         |   Milestone:                           
Component:  Database       |     Version:  6.4.1 RCs                
 Keywords:  SQLite driver  |    Platform:  MSWindows 7              
      Cpu:  x86-64         |  
---------------------------+------------------------------------------------
 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 at pov4,pse_sqlite
 Copy vector <pse at 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 at pov4> to current mapset as <pse_sqlite>

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/1358>
GRASS GIS <http://grass.osgeo.org>