[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. odbc  |    Platform:  MSWindows Vista          
      Cpu:  x86-32              |  
--------------------------------+-------------------------------------------
Changes (by hellik):

  * keywords:  wingrass, db => wingrass, db. odbc


Comment:

 Replying to [comment:1 hellik]:
 >
 >
 > tested with osgeo4w-wingrass7-nightly build and attached sample dataset
 (DEBUG=3)

 and also tested with osgeo4w-wingrass6.4.2

 {{{
 GRASS 6.4.2 (nc_spm_08)> g.gisenv set=DEBUG=3

 GRASS 6.4.2 (nc_spm_08)> v.in.db driver=odbc
 database="C:\dl\mdb\testinput.mdb" table=grassinput x=xcoor y=ycoor
 key=keyid out=vindb5
 D2/3: dbDbmscap(): opendir [C:\OSGeo4W\apps\grass\grass-6.4.2\driver\db\]
 D2/3: Vect_open_new(): name = vindb5
 D1/3: Vect_set_thresh(): thresh = 0.000000
 D1/3: V1_open_new_nat(): name = vindb5
 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 14
 D3/3: dig_init_plus()
 D1/3: dig_spidx_init()
 D3/3: dig_cidx_init()
 D3/3: Vect_hist_command()
 D3/3: G_recreate_command()
 D1/3: Vect_default_field_info(): map = vindb5 field = 1
 D2/3: drv = dbf db = $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
 D3/3: db_start_driver_open_database():
   drvname = odbc, dbname = C:\dl\mdb\testinput.mdb
 D2/3: dbDbmscap(): opendir [C:\OSGeo4W\apps\grass\grass-6.4.2\driver\db\]
 D3/3: win_spawn: args = C:\windows\system32\cmd.exe /c
 "C:\OSGeo4W\apps\grass\grass-6.4.2\driver\db\odbc.exe"
 DBMI-ODBC driver error: SQLConnect():
 [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht
 gefunden, und es wurde kein Standardtreiber angegeben (0)

 WARNUNG: Kann die Datenbank <C:\dl\mdb\testinput.mdb> nicht mit dem
 Treiber
          <odbc> ÷ffnen.
 FEHLER: Kann Datenbank <$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/> nicht mit
         dem Treiber <dbf> ÷ffnen.
 }}}

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