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 <[EMAIL PROTECTED]> 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" <[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 [EMAIL PROTECTED] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > 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
