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

[Paragon Corporation]

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 list
> postgis-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