[GRASS-dev] Re: [GRASS GIS] #1629: v.in.db - odbc-driver - access-database: not working

[GRASS GIS]

#1629: v.in.db - odbc-driver - access-database: not working
--------------------------+-------------------------------------------------
 Reporter:  hellik        |       Owner:  grass-dev@…              
     Type:  defect        |      Status:  new                      
 Priority:  critical      |   Milestone:  6.4.3                    
Component:  Database      |     Version:  svn-releasebranch64      
 Keywords:  wingrass, db  |    Platform:  MSWindows Vista          
      Cpu:  x86-32        |  
--------------------------+-------------------------------------------------

Comment(by hellik):

 Replying to [ticket:1629 hellik]:
 >
 > [...] tested WinGRASS-7.0.svn-r51155-194-Setup.exe
 >

 tested with osgeo4w-wingrass7-nightly build and attached sample dataset
 (DEBUG=3)


 {{{
 GRASS 7.0.svn> v.in.db driver=odbc database="C:\dl\mdb\testinput.mdb"
 table=grassinput x=xcoor y=ycoor key=keyid out=vindb1

 WARNING: Unable to open database <C:\dl\mdb\testinput.mdb> by driver
 <odbc>
 ERROR: Unable to open database
 <$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db>
        by driver <sqlite>

 GRASS 7.0.svn> g.gisenv set=DEBUG=3
 GRASS 7.0.svn> v.in.db driver=odbc database="C:\dl\mdb\testinput.mdb"
 table=grassinput x=xcoor y=ycoor key=keyid out=vindb2
 D2/3: dbDbmscap(): opendir
 [C:\OSGeo4W\apps\grass\grass-7.0.svn\driver\db\]
 D2/3: Vect_open_new(): name = vindb2
 D1/3: Vect_set_thresh(): thresh = 0.000000
 D1/3: V1_open_new_nat(): name = vindb2
 D1/3: Vect_get_thresh(): thresh = 0.000000
 D1/3: dig__write_head()
 D1/3: write coor size (0) to head
 D2/3: coor body offset 18
 D3/3: dig_init_plus()
 D3/3: dig_cidx_init()
 D1/3: Vect_open_sidx(): name = vindb2 mapset= g7 mode = new
 D1/3: Memory based spatial index
 D2/3: G__read_Cell_head
 D2/3: G__read_Cell_head_array
 D3/3: region item: proj:       99
 D3/3: region item: zone:       0
 D3/3: region item: north:      228500
 D3/3: region item: south:      215000
 D3/3: region item: east:       645000
 D3/3: region item: west:       630000
 D3/3: region item: cols:       1500
 D3/3: region item: rows:       1350
 D3/3: region item: e-w resol:  10
 D3/3: region item: n-s resol:  10
 D3/3: region item: top:        1
 D3/3: region item: bottom:     0
 D3/3: region item: cols3:      1500
 D3/3: region item: rows3:      1350
 D3/3: region item: depths:     1
 D3/3: region item: e-w resol3: 10
 D3/3: region item: n-s resol3: 10
 D3/3: region item: t-b resol:  1
 D3/3: Vect_hist_command()
 D3/3: G_recreate_command()
 D1/3: Vect_default_field_info(): map = vindb2 field = 1
 D2/3: drv = sqlite db = $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db
 D3/3: db_start_driver_open_database(): drvname='odbc',
 dbname='C:\dl\mdb\testinput.mdb'
 D2/3: dbDbmscap(): opendir
 [C:\OSGeo4W\apps\grass\grass-7.0.svn\driver\db\]
 D3/3: win_spawn: args = C:\windows\system32\cmd.exe /c
 "C:\OSGeo4W\apps\grass\grass-7.0.svn\driver\db\odbc.exe"
 D1/3: db_d_init_error(): ODBC



 WARNING: Unable to open database <C:\dl\mdb\testinput.mdb> by driver
 <odbc>
 ERROR: Unable to open database
 <$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db>
        by driver <sqlite>
 GRASS 7.0.svn>
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/1629#comment:1>
GRASS GIS <http://grass.osgeo.org>