[GRASS5] ODBC ready

Radim Blazek Radim.Blazek at dhv.cz
Tue May 23 05:41:44 EDT 2000


ODBC driver (limited functionality) is ready FOR TESTING. 

Quick start:
- Download, compile, install and configure ODBC (http://www.unixodbc.org/)
- Copy ODBC include files to /usr/include/odbc
- Compile src/libes/dbmi/drivers/odbc
- Add row for ODBC driver to dbmscap file (see src/libes/dbmi/clients/man/db_connect.html)
- Configure your ODBC DSN
- Now you can run modules (examples expect driver:odbc, DSN: db, 
  user:usr, table: tb(id int, val int)):

db.connect  driver=odbc database=db [user=usr password=mypwd]
(see src/libes/dbmi/clients/man/db_connect.html)


db.tables driver=odbc database=db

db.columns driver=odbc database=db table=tb

db.describe driver=odbc database=db table=tb

db.select -hc  input=sel.sql
( sel.sql contains: select * from tb)

db.execute driver=odbc database=db input=ins.sql
(ins.qsl contains: insert into tb (id, val) values ( 11,  123))

db.droptable driver=odbc database=db table=tb
(drop table!)

v.db.reclass input=map output=rmap rules=a.rcl table=tb type=area
(see src/mapdev/v.db.reclass/man/v_db_reclass.html)

That's all for now.

Anybody who want to help is welcome:
- write missing functions in driver (src/libes/dbmi/drivers/odbc/TODO)
- test various RDBMS and data types (binary not supported)
- write more modules
- translate manuals from my english to real english

I work on v.to.db (load categories, areas, lenghts, x,y, nr. of elem.,....)


If you want to unsubscribe from GRASS Development Team mailing list write to:
minordomo at geog.uni-hannover.de with
subject 'unsubscribe grass5'

More information about the grass-dev mailing list