[GRASSLIST:9228] v.in.db from MS Accesss

GRASS GRASS user
1

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)

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

2

Support of MS Acces on Linux is very poor -- GRASS does not support it
as well. Try to convert it to DBF or PostgreSQL.

Jachym

On Mon, Nov 28, 2005 at 03:09:22PM +0100, Josip Vrliæ 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)

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

--
Jachym Cepicky
e-mail: jachym.cepicky@centrum.cz
URL: http://les-ejk.cz
GPG: http://les-ejk.cz/gnupg_public_key/
-----------------------------------------
OFFICE:
Department of Geoinformation Technologies
LDF MZLU v Brnì
Zemìdìlská 3
613 00 Brno
e-mail: xcepicky@node.mendelu.cz
URL: http://mapserver.mendelu.cz
Tel.: +420 545 134 514

3

On 11/28/05, Josip Vrliæ <josip.vrlic@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