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

[Dan Blomberg]

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 <mailto: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 <mailto: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>
> [mailto: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 <mailto: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 <mailto: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/20080601/2965b0d8/attachment.html>