[GRASSLIST:4833] Re: odbc problem

[Glynn Clements]

Miha STAUT wrote:

> I ran into a problem while trying to connect to Grass5.0.0 my database of 
> communalities in Slovenia that I have in PosgreSQL. The problem Grass is 
> complaining about looks like this:
> 
> GRASS:~ > db.connect driver=odbc database=obc user=root
> driver:odbc
> database:commun
> location:(null)
> user:root
> password:(null)
> key:(null)
> GRASS:~ > db.databases
> /usr/local/grass5/driver/db/odbc: error while loading shared libraries: 
> libodbc.so.1: cannot open shared object file: No such file or directory
> dbmi: Protocol error
> Can't run driver (null)
> 
> Seems like I do not have installed this library (is this possible?). Where 
> can I find it?

	www.unixodbc.org

> I would also like to connect it to PostgreSQL as suggested in the help files 
> but PostgreSQL provides within the postgresql-odbc package two libraries: 
> libpsqlodbc.so.0 and postgresql-odbc. Are these two the same type as 
> requested by Grass?

No. The db.* programs require the UnixODBC library.

-- 
Glynn Clements <glynn.clements at virgin.net>