<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I am having a heck of a time getting a connection to PostGIS/PostgreSQL
to work.<br>
<br>
Quantum GIS 0.9.0 connects just fine by itself. I can add a layer to
Quantum GIS. My connection info for QGIS is<br>
Name local<br>
Host localhost<br>
Database postgis<br>
Port 5432<br>
Username John<br>
<br>
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<br>
<br>
<span style="font-weight: 600;">v.in.ogr 'dsn=PG:host=localhost
dbname=postgis port=5432 user=John' layer=locationmap output=stuff -o<br>
</span><br>
and I get the following result:<br>
<p>
<p style="margin: 0px; text-indent: 0px;">Unable to open data source </p>
<p style="margin: 0px; text-indent: 0px;"><span
style="font-weight: 600;">Finished with error</span></p>
</p>
<br>
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<br>
Unable to open datasource.<br>
<br>
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.<br>
<br>
I see this web page
<a class="moz-txt-link-freetext" href="http://grass.itc.it/grass63/manuals/html63_user/grass-odbc.html">http://grass.itc.it/grass63/manuals/html63_user/grass-odbc.html</a> but it
seems to be unix specific. I'm on Windows.<br>
<br>
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!<br>
<br>
Thanks,<br>
<br>
--<br>
John Abraham<br>
University of Calgary<br>
<a class="moz-txt-link-abbreviated" href="mailto:jabraham@ucalgary.ca">jabraham@ucalgary.ca</a><br>
</body>
</html>