<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><DIV>Dear Micha and Martin,</DIV><DIV> </DIV><DIV>Many thanks for your help.</DIV><DIV> </DIV><DIV>Hope the bug in WinGRASS will soon be resolved.</DIV><DIV> </DIV><DIV>Greetings,</DIV><DIV> </DIV><DIV>Roy</DIV><DIV><BR> </DIV><FONT color=#990099>-----Martin Landa <landa.martin@gmail.com> wrote: -----<BR><BR></FONT><BLOCKQUOTE style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">To: Micha Silver <micha@arava.co.il><BR>From: Martin Landa <landa.martin@gmail.com><BR>Date: 05/08/2011 05:29AM<BR>Cc: rvanderweide@worldbank.org, grass-user@lists.osgeo.org<BR>Subject: Re: [GRASS-user] SQLite driver errors: `Unable to open database'<BR><BR><FONT size=2 face="Default Monospace,Courier New,Courier,monospace">Hi,<BR><BR>2011/5/8 Micha Silver <micha@arava.co.il>:<BR>> GRASS 6.4.0 (UTM36):~ > eval `g.gisenv`<BR>> GRASS 6.4.0 (UTM36):~ > db.connect driv=sqlite<BR>> database=$GISDBASE/$LOCATION_NAME/$MAPSET/geodata.db<BR>> GRASS 6.4.0 (UTM36):~ > db.connect -p<BR>> driver:sqlite<BR>> database:/home/micha/geodata/grass/UTM36/Israel/geodata.db<BR>> schema:<BR>> group:<BR><BR>first of all, you don't need to run `g.gisenv`, just<BR><BR>$ db.connect driv=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/geodata.db'<BR><BR>is enough.<BR><BR>> GRASS 6.4.0 (UTM36):~ > ll /home/micha/geodata/grass/UTM36/Israel/geodata.db<BR>> ls: cannot access /home/micha/geodata/grass/UTM36/Israel/geodata.db: No such<BR>> file or directory<BR><BR>right, the database should be created when it's accessed.<BR><BR>After running eg. `g.copy`<BR><BR>$ eval `g.gisenv`<BR>$ file $GISDBASE/$LOCATION_NAME/$MAPSET/geodata.db<BR>/home/martin/grassdata/nc_spm_08/landa6/geodata.db: SQLite 3.x database<BR><BR>The reported behaviour seems to be bug in winGRASS.<BR><BR>Martin<BR><BR>-- <BR>Martin Landa <landa.martin gmail.com> * <A href="http://geo.fsv.cvut.cz/~landa" target=blank>http://geo.fsv.cvut.cz/~landa</A><BR></FONT></BLOCKQUOTE><BR></FONT>