[GRASS-user] PostgreSQL connection just not working - v.in.ogr and QuantumGIS

Moritz Lennert mlennert at club.worldonline.be
Fri Nov 9 20:05:05 EST 2007


John Abraham wrote:
> I am having a heck of a time getting a connection to PostGIS/PostgreSQL 
> to work.

[...]

I can't say anything about QGIS, but:

> 
> I also installed grass63RC1 standalone.  I got it running, but can't 
> connect to my data.  I've tried every connection string I can think of, 
> and I always get
> Unable to open datasource.

This could be because GRASS doesn't find the path to your postgres 
libraries.

For the standalone wingrass binary, you can set the path in the 
grass63.bat file using something like this:

set PATH=c:\PathToPostgres\lib;%PATH%

Be sure to put the postgres path at the beginning, not after the %PATH% 
because this could cause a library conflict.

> 
> I went into the ControlPanel -> Administrative Tools -> Datasources and 
> defined an ODBC datasource that seems to connect to the database, but I 
> have no idea how to make Grass connect via a pre-defined ODBC connection.

ODBC is not compiled as a driver in the current version of the windows 
GRASS binaries. See 
http://geog-pc40.ulb.ac.be/grass/wingrass/winconfig.log for a list of 
what is and is not compiled.

It will in a future version.




More information about the grass-user mailing list