[GRASS5] ODBC ready

[John Huddleston]

Also, FYI, I have attached a note from the Cygnus email list
on using Oracle DLLs and the Cygnus linker.

----- Original Message -----
From: DJ Delorie <dj at delorie.com>
To: <richard.jones at ibahealthcare.com>
Cc: <cygwin at sourceware.cygnus.com>
Sent: Tuesday, May 23, 2000 8:08 AM
Subject: Re: Linking in to Windows DLL's

>
> If you have a recent linker, it can link directly against a DLL
> without needing an import library.  However, this only works if the
> import library doesn't include any special name mappings or extra
> static code.
>
> > Just a quick note to say that I have managed to link cygwin code against
> > Oracle 8 for NT by just renaming the dll's library file to oci32.o.
> > This seems to work fine (all the manuals and FAQ's require extracting
the
> > symbol's out of the dll itself), and it "seems" to work correctly.
>

----- Original Message -----
From: Radim Blazek <Radim.Blazek at dhv.cz>
To: <grass5 at geog.uni-hannover.de>
Sent: Tuesday, May 23, 2000 3:41 AM
Subject: [GRASS5] ODBC ready


> 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'


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