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

[John Abraham]

I am having a heck of a time getting a connection to PostGIS/PostgreSQL 
to work.

Quantum GIS 0.9.0  connects just fine by itself.  I can add a layer to 
Quantum GIS.   My connection info for QGIS is
Name local
Host localhost
Database postgis
Port 5432
Username John

But if I try to do anything with the grass plugin to QGIS (I am trying 
to us v.in.ogr) QGIS gives me the command

v.in.ogr 'dsn=PG:host=localhost dbname=postgis port=5432 user=John' 
layer=locationmap output=stuff -o

and I get the following result:

Unable to open data source

Finished with error


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.

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.

I see this web page 
http://grass.itc.it/grass63/manuals/html63_user/grass-odbc.html but it 
seems to be unix specific.  I'm on Windows.

What the heck am I doing wrong?  Any and all ideas are much 
appreciated.  Arghh.  QuantumGIS just doesn't do what I need, and I can 
see the grass functionality, but can't use it!  It's *so* frustrating!

Thanks,

--
John Abraham
University of Calgary
jabraham at ucalgary.ca
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20071109/23f746d5/attachment.html