[GRASS-user] GRASS and ODBC help wanted

[Markus Neteler]

"Georg Lösel (privat)" wrote on 11/29/2007 06:40 PM:
> Hi all,
>
> I need some help.
>
> OS: Debian Etch
>
> I try to connect GRASS [1] via odbc to my local PostgreSQL database. The
> case is for a training lession about this gis. I connect to Postgres
> because i have no other db.
>
> The direct contact to the PostgresQL runs without problems.
>   
...
> 2.
> odbcinst.ini
>
> [PostgreSQL]
> Description     = PostgreSQL driver for Linux & Win32
> Driver          = /usr/lib/odbc/libodbcpsqlS.so
> Setup           = /usr/lib/odbc/libodbcpsqlS.so
> Threading       = 2
> UsageCount      = 1
>   

The "Driver" setting above isn't right: It should be (take out 'S'):

Driver          = /usr/lib/odbc/libodbcpsql.so

See: http://www.unixodbc.org/odbcinst.html

Note that ODBC is sloooooooow. Direct connection to PG is
way faster.

Markus