db.tables is unable to open database in Grass 6.5 using sqlite

[epatton]

db.tables gives an error when I try to print a list of tables in my current Location:

db.connect -p 
driver:sqlite
database:/home/epatton/Projects/Canso/PERMANENT/databases/Canso.db
schema:
group:

db.tables -p
DBMI-SQLite driver error:
Unable to open database: unable to open database file

ERROR: Unable to open database
       </home/epatton/Projects/Canso/PERMANENT/databases/Canso.db>

The directory where my database is located is readable, writable, and owned by me. I can also browse the database in question using sqlitebrowser with no problems; I just can't access it through Grass.

Am I overlooking something simple?

~ Eric.

[neteler]

Just for paranoia (copy-paste):

ls -la /home/epatton/Projects/Canso/PERMANENT/databases/Canso.db

?

and how about

sqlite3 /home/epatton/Projects/Canso/PERMANENT/databases/Canso.db

? (leave with CTRL-D).

and then

db.drivers -p

(perhaps SQLite support missing?)

Markus

[epatton]

Thanks for the clue! The problem was that my Grass location 'Canso' was transferred from another computer, and I am now working with it on my laptop; however, my username on the other PC is 'epatton', whereas it is 'eric' on the laptop, and the database connection was looking for epatton.

Thanks!

~ Eric.