[GRASS-dev] [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        |  
--------------------------+-------------------------------------------------
 from the dev-ML:

 http://lists.osgeo.org/pipermail/grass-dev/2012-March/058224.html

 {{{
 ODBC and GRASS for Windows

 Have posted some weeks ago on a problem with the ODBC driver in the user
 list
 but got no answer until now. I am working on a master thesis and would
 like
 to use GRASS as the core of a solution with FOSGIS, but there seem to be
 problems with the ODBC driver in GRASS for Windows. Beeing not a
 programmer
 I am not really sure about this and would like to consult the developers
 of
 GRASS for a suggestion how to proceed. Please correct me, if my point of
 view should be wrong !

 My former post in the user list is this
 http://osgeo-org.1560.n6.nabble.com/ODBC-driver-in-GRASS-td4558182.html

 Is there any chance to solve the problem with reading ODBC data bases
 (particularly MS Access) in the near future? Havn't opened a ticket yet.

 Thanks a lot for any feedback,
 regards, Christine
 }}}

 attached a simple test access database (testinput.mdb - zipped) - simple
 x,y-point-data - for the nc-sample dataset.

 tested here both with WinGRASS-6.4.3svn-r51149-195-Setup.exe and
 WinGRASS-7.0.svn-r51155-194-Setup.exe

 the v.in.db-wxgui freezes if database (i.e. C:\wd\access\testinput.mdb) is
 entered in the gui

 in the wxgui-commandline

 {{{
 v.in.db driver=odbc database="C:\wd\access\testinput.mdb" table=grassinput
 key=ID x=xcoor y=ycoor output=mdbvector
 }}}

 a error message pops up that odbc.exe isn't working.

 Helmut

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