<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Well I did manage to get something to work. I'm not sure if setting
the path to the Postgres libraries was important or not.<br>
<br>
In QGIS I'm able to connect to the database in QGIS using <br>
<span style="font-weight: 600;">db.connect driver=pg database=postgis
schema=public<br>
</span><br>
and then I'm able to import a shapefile into the PostGIS database using<br>
<br>
<span style="font-weight: 600;">v.in.ogr
dsn=C:\MontgomeryShapefiles\Autauga\BLDG_FOOTPRINT.shp
output=bldg_footprint2 -o</span>
<p style="margin: 0px; text-indent: 0px;"><br>
</p>
That put a table in the database from the shapefile. Not sure what to
do with it now, because I guess grass vector layers aren't PostGIS
tables, and when I try to add it as a GRASS vector layer QGIS crashes.
But it's movement foreward anyways. <br>
<br>
Thanks for caring, I'll struggle some more and try to figure this thing
out. I think I have a paradigm problem in that I'm expecting
everything to be stored in a PostGIS database using PostgreSQL, but
Grass seems to be insisting on keeping things in its own dbf files
instead. <br>
<br>
--<br>
John <br>
<br>
Moritz Lennert wrote:
<blockquote cite="mid:473503C1.5060701@club.worldonline.be" type="cite">John
Abraham wrote:
<br>
<blockquote type="cite">I am having a heck of a time getting a
connection to PostGIS/PostgreSQL to work.
<br>
</blockquote>
<br>
[...]
<br>
<br>
I can't say anything about QGIS, but:
<br>
<br>
<blockquote type="cite"><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>
</blockquote>
<br>
This could be because GRASS doesn't find the path to your postgres
libraries.
<br>
<br>
For the standalone wingrass binary, you can set the path in the
grass63.bat file using something like this:
<br>
<br>
set PATH=c:\PathToPostgres\lib;%PATH%
<br>
<br>
Be sure to put the postgres path at the beginning, not after the %PATH%
because this could cause a library conflict.
<br>
<br>
<blockquote type="cite"><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>
</blockquote>
<br>
ODBC is not compiled as a driver in the current version of the windows
GRASS binaries. See
<a class="moz-txt-link-freetext" href="http://geog-pc40.ulb.ac.be/grass/wingrass/winconfig.log">http://geog-pc40.ulb.ac.be/grass/wingrass/winconfig.log</a> for a list of
what is and is not compiled.
<br>
<br>
It will in a future version.
<br>
<br>
<br>
</blockquote>
<br>
</body>
</html>