[GRASS-user] database(s) in grass

[Markus Neteler]

On Thu, Apr 12, 2007 at 08:38:52AM +0100, Ricardo Oliveira wrote:
> On Wed, 11 Apr 2007 20:20:26 +0200
> Markus Neteler <neteler at itc.it> wrote:
...
> > 1. do
> > 
> > # example for storing DB in mapset directory (keep single quotes):
> > db.connect driver=sqlite
> > database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db' db.connect -p
> 
> Using this approach the result is: "no such file"

So, you do:

db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'

and then
db.connect -p

and it says "no such file"? Are you sure? What is the *exact*
error message? Cannot find a "no such file" message in the
db.connect program, nor sqlite driver, nor DBMI interface.

The db.connect does not create the file. It just sets the connection.

What does
db.connect -p
report?

> > 2. do
> > 
> > v.digit -n newmap

Did you do this *after* running db.connect?
This command will create sqlite.db and the table if you use the
"settings" tab in v.digit to do so.

I suggest that you try in a new mapset.

Markus