Paul & Regina,
Paul: I noticed there is no -f option. Would I be able to run a
command direct to psql (with the | ) without having to open the
command prompt first?
Regina: I tried that, good idea though.
More diagnosing: I am able to run pgsql from my program without an
issue. I tried to run shp2pgsql.exe from a .bat file I wrote and it
also has the same error. Anyone else have any ideas?
Thanks
Dan
QUOTED:
------------------------------
Message: 4
Date: Sun, 1 Jun 2008 06:39:09 -0400
From: "Paragon Corporation" <[EMAIL PROTECTED]>
Subject: RE: [postgis-users] Can't Call shp2pgsql.exe From "Run" or VB
Program, only works with DOS prompt opened first
To: "'PostGIS Users Discussion'"
<[email protected]>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset="us-ascii"
Dan,
Could also be the VB code or run statement is being truncated. How are you
escaping out your double quotes in VB.
E.g. if you copy the files to root of C and then try it does it work?
Hope that helps,
Regina
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Ramsey
Sent: Saturday, May 31, 2008 6:05 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Can't Call shp2pgsql.exe From "Run" or VB
Program,only works with DOS prompt opened first
The redirect may not work when running it from Run... or exec inside a
program. This sort of argues for a -f option to write out to file without
needing a stdout redirect.
P
On Sat, May 31, 2008 at 2:49 PM, Daniel Blomberg <[EMAIL PROTECTED]>
wrote:
Hi,
I am trying to run shp2pgsql.exe from inside a visual basic program I
am writing. Its not working so i tested the command I am sending from
the "Run" dialog box in windows and it doesn't work. The dos box pops
up and goes away too fast but here is what I caught:
http://www.gpsfiledepot.com/shp2pgsql.jpg
The command I am trying to run is:
"C:\gps_maps\postgis_sql\shp2pgsql.exe"
"C:\gps_maps\mississippi_topo\transportation\all_lines.shp" all_lines
"C:\gps_maps\mississippi_topo\transportation\all_lines.sql"
If I run the command when the dos prompt is open it works. Ideas/help
would be much appreciated.
Thanks in advance
Dan
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
