[GRASS5] ODBC ready
Radim Blazek
Radim.Blazek at dhv.cz
Tue May 23 05:41:44 EDT 2000
Hi,
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.drivers
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.,....)
Radim
----------------------------------------
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