[GRASS-user] Postgres import on Windows = "ERROR: Unable to open data source"

[Aren Cambre]

On Sat, Dec 29, 2012 at 3:28 PM, Markus Metz
<markus.metz.giswork at gmail.com>wrote:

> On Sat, Dec 29, 2012 at 7:14 PM, Aren Cambre <aren at arencambre.com> wrote:
> > When it try to run this in 6.4.3svn (last night's build) or 6.4.2:
> > v.in.ogr -t -o dsn=C:\Users\Aren Cambre\Desktop\DEEM
> documents\TxDOT\grass
> > connection.dsn output=crashes
> >
> > ...all I get this this:
> > ERROR: Unable to open data source <C:\Users\Aren Cambre\Desktop\DEEM
> > documents\TxDOT\grass connection.dsn>
> >
> > That error is vague.
> >
> > The DSN was generated by v.in.ogr.qgis in Quantum GIS, and it does work
> in
> > QGIS's bundled GRASS 6.4.2. In the grass connection.dsn file is this:
> > PG:dbname='de' host=localhost port=5432 user='development'
> > password='XXXXXXXX' sslmode=disable
> > (of course, XXXXX is replaced with the actual password)
>
> Does
>
> v.in.ogr -t -o dsn="PG:dbname='de' host=localhost port=5432
> user='development' password='XXXXXXXX' sslmode=disable" output=crashes
>
> work? I.e. not using the file "grass connection.dsn" but its contents.
>

Here's the command that I tried to run manually:
*v.in.ogr dsn="PG:dbname='de' host=localhost port=5432 user='development'
password='XXXXXXXXX' sslmode=disable" layer="raw.TxDOT consolidated
crashes" output=crashesX snap=-1 min_area=0.0001 -o*

I get this dialog:


[image: Inline image 1]

In case the dialog doesn't come through, the error is *Unable to parse
command*, then it repeats my command encapsulated in single quote marks.

Aren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20121230/51bef0db/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 36363 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20121230/51bef0db/attachment-0001.png>