[GRASSLIST:9236] Re: v.in.db from MS Accesss

[Radim Blazek]

On 11/28/05, Josip Vrlić <josip.vrlic at plovput.hr> wrote:
>
> Hello!
>
> I have database in MS Access and I want to make vector map from that
> database. I use Cygwin for run Grass 6.1.
> When I try to connect I have folowing error:
>
> v.in.db driver=odbc
> database=$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/svjetla.mdb
> table=svjetlo x=x y=y key=id_svjetlo output=svjetla
> DBMI-ODBC driver error: SQLConnect():
> [unixODBC][Driver Manager]Invalid string or buffer length (0)

The 'database' parameter for odbc driver is odbc DSN.
First you have to get odbc working. Define DSN using
ODBCConfig and then try connection with DataManager.

You need to have MDBTools installed of course.

Radim


> Cannot open database
> '$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/svjetla.mdb'
>
> Cannot open database
> $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/svjetla.mdb by driver
> odbc
>
> What I have to do?
>
> Thanks!
>
> Josip Vrlic