[postgis-users] Re: Can't Call shp2pgsql.exe From "Run" or VB Program, only works with DOS prompt opened first

[Lê Viết Thanh]

A quick and dirty workaround, you can generate to a batch file and recall it
in VB.

On Mon, Jun 2, 2008 at 4:50 AM, Dan Blomberg <services at gpsfiledepot.com>
wrote:

>  Everyone,
>
> I actually figured out how to make this work by viewing the php code for
> the DCMMS application.  I needed to add the database after the table name
> and now it works.
>
> In case anyone else runs into this the command I now use is:
> "C:\gps_maps\postgis_sql\shp2pgsql.exe" -d
> "C:\gps_maps\mississippi_topo\transportation\all_lines.shp" all_lines
> postgis > "C:\gps_maps\mississippi_topo\transportation\all_lines.sql"
>
> Dan
>
>
> Daniel Blomberg wrote:
>
> 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" <lr at pcorp.us>
> 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'"
> 	<postgis-users at postgis.refractions.net>
> Message-ID: <000501c8c3d3$b936ef00$4d812e40 at l>
>
> 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: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] 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 <services at gpsfiledepot.com>
>
> 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 listpostgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080602/fc4da407/attachment.html>