[GRASSLIST:1051] Re: vector map <-> db connection

[Massimiliano Cannata]

did you run db.connct?
do you have the correct permission on the dbf file?
hello,
max

Stefán István wrote:

>Hello List!
>
>I have problem connecting a vector map to a database.
>I created a vectormap by the v.digit command, and then I would like to add 
>some information to the digitialized points.
>
>I created a db connection with this command:
>GRASS 6.1.cvs (Ferencvaros):~ > v.db.connect -o map=kietmelo_kutak_1 
>driver=dbf table=kutak1
>WARNING: Table <kutak1> does not exist in database
>         <$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/>
>WARNING: The table <kutak1> is now part of vector map <kietmelo_kutak_1>
>         and may be deleted or overwritten by GRASS modules.
>
>Then I tried to add columns, but I got error message:
>GRASS 6.1.cvs (Ferencvaros):~ > v.db.addcol map=kietmelo_kutak_1 columns="nev 
>varchar(10)"
>DBMI-DBF driver error:
>Table 'kutak1' doesn't exist.
>Error in db_execute_immediate()
>
>ERROR: Error while executing: "ALTER TABLE kutak1 ADD COLUMN nev
>       varchar(10)
>       "
>ERROR: Cannot continue (problem to add column).
>
>
>What did I wrong?
>
>Thanks for the help in advance,
>Istvan
>
>
>
>  
>


-- 

Eng. Massimiliano Cannata
Scuola Universitaria Professionale della Svizzera Italiana
Istituto Scienze della Terra
Via Trevano, c.p. 72
CH-6952 Canobbio-Lugano
Tel: +41 (0)58 666 62 14
Fax +41 (0)58 666 62 09