wsh upload puzzle :: fails when accessing server file

Hi Guys,

I would appreciate some help in my age-long struggle to wsh (ftp upload) a
small file (access .mdb) to our remote web host...

It works great when I do the upload from the local drive.

BUT, when I try to upload the file from across the networked server machine
the script hanges WITHOUT generating an error with the cmd.exe line showing:

ftp> ftp> _

Now, I know from past experience that this could be permissions error. But,
If I check the SECURITY for the parent folder I see:

Adminsistrator
Authenticated
Everyone
G Cuadros

Full Contol = yes/ticked
Modify = yes
Read and execute = yes
etc
etc

INHERITABLE PERMISSIONS =yes = allow inheritable permissions is enabled and
ticked

Thus, what is causing the script to hange and not upload the file when I
attempt this across the network towards our remote web host....??

This has been an ongoing battle for me and I really need somebody
knowledgeable to help me get a handle on this.

I have posed my short, full . VBS code below:
'//----------------------------------------


set fso=createobject("scripting.filesystemobject")
set sll=createobject("wscript.shell")
set f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
true)
with f
.writeline "open site.maximumasp.com"
.writeline "username"
.writeline "password"
.writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
end with
sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
f.close

That's it - but something is making it unstuck and I am receiving no error -
it just hanges towards the end with the cmd.exe remaining open.

I would appreciate your help in solving this problem.

- Jason

Paul
Wed Jul 30 12:51:59 CDT 2003

Additionaly you want to add
.writeline "bin"
before the put otherwise the db will be corrupted.

"jason" <jason@catamaranco.com> wrote in message
news:e9j8HtrVDHA.2316@TK2MSFTNGP09.phx.gbl...
> Hi Guys,
>
> I would appreciate some help in my age-long struggle to wsh (ftp upload) a
> small file (access .mdb) to our remote web host...
>
> It works great when I do the upload from the local drive.
>
> BUT, when I try to upload the file from across the networked server
machine
> the script hanges WITHOUT generating an error with the cmd.exe line
showing:
>
> ftp> ftp> _
>
> Now, I know from past experience that this could be permissions error.
But,
> If I check the SECURITY for the parent folder I see:
>
> Adminsistrator
> Authenticated
> Everyone
> G Cuadros
>
> Full Contol = yes/ticked
> Modify = yes
> Read and execute = yes
> etc
> etc
>
> INHERITABLE PERMISSIONS =yes = allow inheritable permissions is enabled
and
> ticked
>
> Thus, what is causing the script to hange and not upload the file when I
> attempt this across the network towards our remote web host....??
>
> This has been an ongoing battle for me and I really need somebody
> knowledgeable to help me get a handle on this.
>
> I have posed my short, full . VBS code below:
> '//----------------------------------------
>
>
> set fso=createobject("scripting.filesystemobject")
> set sll=createobject("wscript.shell")
> set f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
> true)
> with f
> .writeline "open site.maximumasp.com"
> .writeline "username"
> .writeline "password"
> .writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
> end with
> sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
> f.close
>
> That's it - but something is making it unstuck and I am receiving no
error -
> it just hanges towards the end with the cmd.exe remaining open.
>
> I would appreciate your help in solving this problem.
>
> - Jason
>
>
>
>

jason
Wed Jul 30 13:29:36 CDT 2003

Thanks...

But, all this really does is tweak the robustness of the script ...I ran the
revised script with the ".quit" and ".bin" included and now the script has
ended prematurly without the upload being complete...

I am still left with the puzzle on why the script is failing.....?

Regards
- Jason

ps: What is the significance of the ".bin" command ???anyway
"Paul R. Sadowski" <xpert@mailshell13.mailshell.com> wrote in message
news:uTFgINsVDHA.1280@tk2msftngp13.phx.gbl...
> Additionaly you want to add
> .writeline "bin"
> before the put otherwise the db will be corrupted.
>
> "jason" <jason@catamaranco.com> wrote in message
> news:e9j8HtrVDHA.2316@TK2MSFTNGP09.phx.gbl...
> > Hi Guys,
> >
> > I would appreciate some help in my age-long struggle to wsh (ftp upload)
a
> > small file (access .mdb) to our remote web host...
> >
> > It works great when I do the upload from the local drive.
> >
> > BUT, when I try to upload the file from across the networked server
> machine
> > the script hanges WITHOUT generating an error with the cmd.exe line
> showing:
> >
> > ftp> ftp> _
> >
> > Now, I know from past experience that this could be permissions error.
> But,
> > If I check the SECURITY for the parent folder I see:
> >
> > Adminsistrator
> > Authenticated
> > Everyone
> > G Cuadros
> >
> > Full Contol = yes/ticked
> > Modify = yes
> > Read and execute = yes
> > etc
> > etc
> >
> > INHERITABLE PERMISSIONS =yes = allow inheritable permissions is enabled
> and
> > ticked
> >
> > Thus, what is causing the script to hange and not upload the file when I
> > attempt this across the network towards our remote web host....??
> >
> > This has been an ongoing battle for me and I really need somebody
> > knowledgeable to help me get a handle on this.
> >
> > I have posed my short, full . VBS code below:
> > '//----------------------------------------
> >
> >
> > set fso=createobject("scripting.filesystemobject")
> > set sll=createobject("wscript.shell")
> > set
f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
> > true)
> > with f
> > .writeline "open site.maximumasp.com"
> > .writeline "username"
> > .writeline "password"
> > .writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
> > end with
> > sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
> > f.close
> >
> > That's it - but something is making it unstuck and I am receiving no
> error -
> > it just hanges towards the end with the cmd.exe remaining open.
> >
> > I would appreciate your help in solving this problem.
> >
> > - Jason
> >
> >
> >
> >
>
>

jason
Wed Jul 30 13:33:30 CDT 2003

Hi Ross,

I added this line in an ran the script along with Paul S suggestion of
adding in ".bin" prior the "put" command....

set fso=createobject("scripting.filesystemobject")
set sll=createobject("wscript.shell")
set f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
true)
with f
.writeline "open V032U10DUW.maximumasp.com"
.writeline "maximumasp\V032U10DUW"
.writeline "sjHNyTTRD7fm"
.writeline "bin"
.writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
.writeline "quit"
end with
sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
f.close


But, now my script just ends prematurely without giving any error message
and NO file is uploaded. Where do I go from here?

- Jason




"Ross Presser" <rpresser@NOSPAM.imtek.com.invalid> wrote in message
news:Xns93C887149A9F0pt101594@129.250.170.90...
> "jason" <jason@catamaranco.com> wrote in news:e9j8HtrVDHA.2316
> @TK2MSFTNGP09.phx.gbl:
>
> > the script hanges WITHOUT generating an error
>
> Add this before "End With":
>
> .writeline "quit"
>
>
>
> --
> Ross Presser -- rpresser AT imtek DOT com
> "... VB is essentially the modern equivalent of vulgar Latin in 13th
> Centurary Europe. Understand it, and you can travel to places you never
> heard of and still understand some people." -- Alex K. Angelopoulos

jason
Wed Jul 30 13:51:52 CDT 2003

Solved! I transerred the scripts to the server itself and executed it from
the server itself rather than trying to it from local machine. It was
really this simple - After six months I finally found a way to do an
automatic upload!

Thanks
Jason
"jason" <jason@catamaranco.com> wrote in message
news:e9j8HtrVDHA.2316@TK2MSFTNGP09.phx.gbl...
> Hi Guys,
>
> I would appreciate some help in my age-long struggle to wsh (ftp upload) a
> small file (access .mdb) to our remote web host...
>
> It works great when I do the upload from the local drive.
>
> BUT, when I try to upload the file from across the networked server
machine
> the script hanges WITHOUT generating an error with the cmd.exe line
showing:
>
> ftp> ftp> _
>
> Now, I know from past experience that this could be permissions error.
But,
> If I check the SECURITY for the parent folder I see:
>
> Adminsistrator
> Authenticated
> Everyone
> G Cuadros
>
> Full Contol = yes/ticked
> Modify = yes
> Read and execute = yes
> etc
> etc
>
> INHERITABLE PERMISSIONS =yes = allow inheritable permissions is enabled
and
> ticked
>
> Thus, what is causing the script to hange and not upload the file when I
> attempt this across the network towards our remote web host....??
>
> This has been an ongoing battle for me and I really need somebody
> knowledgeable to help me get a handle on this.
>
> I have posed my short, full . VBS code below:
> '//----------------------------------------
>
>
> set fso=createobject("scripting.filesystemobject")
> set sll=createobject("wscript.shell")
> set f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
> true)
> with f
> .writeline "open site.maximumasp.com"
> .writeline "username"
> .writeline "password"
> .writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
> end with
> sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
> f.close
>
> That's it - but something is making it unstuck and I am receiving no
error -
> it just hanges towards the end with the cmd.exe remaining open.
>
> I would appreciate your help in solving this problem.
>
> - Jason
>
>
>
>

Ratty
Wed Jul 30 15:06:04 CDT 2003

Jason - should the "f.close" line happen BEFORE you call the FTP client??
--
Ratty

"jason" <jason@catamaranco.com> wrote in message
news:e9j8HtrVDHA.2316@TK2MSFTNGP09.phx.gbl...
> Hi Guys,
>
> I would appreciate some help in my age-long struggle to wsh (ftp upload) a
> small file (access .mdb) to our remote web host...
>
> It works great when I do the upload from the local drive.
>
> BUT, when I try to upload the file from across the networked server machine
> the script hanges WITHOUT generating an error with the cmd.exe line showing:
>
> ftp> ftp> _
>
> Now, I know from past experience that this could be permissions error. But,
> If I check the SECURITY for the parent folder I see:
>
> Adminsistrator
> Authenticated
> Everyone
> G Cuadros
>
> Full Contol = yes/ticked
> Modify = yes
> Read and execute = yes
> etc
> etc
>
> INHERITABLE PERMISSIONS =yes = allow inheritable permissions is enabled and
> ticked
>
> Thus, what is causing the script to hange and not upload the file when I
> attempt this across the network towards our remote web host....??
>
> This has been an ongoing battle for me and I really need somebody
> knowledgeable to help me get a handle on this.
>
> I have posed my short, full . VBS code below:
> '//----------------------------------------
>
>
> set fso=createobject("scripting.filesystemobject")
> set sll=createobject("wscript.shell")
> set f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
> true)
> with f
> .writeline "open site.maximumasp.com"
> .writeline "username"
> .writeline "password"
> .writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
> end with
> sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
> f.close
>
> That's it - but something is making it unstuck and I am receiving no error -
> it just hanges towards the end with the cmd.exe remaining open.
>
> I would appreciate your help in solving this problem.
>
> - Jason
>
>
>
>

jason
Wed Jul 30 15:18:15 CDT 2003

I'm not sure....

- Jason
"Ratty" <donanderNOSPAM@bigpond.net.au> wrote in message
news:MyVVa.960$bo1.891@news-server.bigpond.net.au...
> Jason - should the "f.close" line happen BEFORE you call the FTP client??
> --
> Ratty
>
> "jason" <jason@catamaranco.com> wrote in message
> news:e9j8HtrVDHA.2316@TK2MSFTNGP09.phx.gbl...
> > Hi Guys,
> >
> > I would appreciate some help in my age-long struggle to wsh (ftp upload)
a
> > small file (access .mdb) to our remote web host...
> >
> > It works great when I do the upload from the local drive.
> >
> > BUT, when I try to upload the file from across the networked server
machine
> > the script hanges WITHOUT generating an error with the cmd.exe line
showing:
> >
> > ftp> ftp> _
> >
> > Now, I know from past experience that this could be permissions error.
But,
> > If I check the SECURITY for the parent folder I see:
> >
> > Adminsistrator
> > Authenticated
> > Everyone
> > G Cuadros
> >
> > Full Contol = yes/ticked
> > Modify = yes
> > Read and execute = yes
> > etc
> > etc
> >
> > INHERITABLE PERMISSIONS =yes = allow inheritable permissions is enabled
and
> > ticked
> >
> > Thus, what is causing the script to hange and not upload the file when I
> > attempt this across the network towards our remote web host....??
> >
> > This has been an ongoing battle for me and I really need somebody
> > knowledgeable to help me get a handle on this.
> >
> > I have posed my short, full . VBS code below:
> > '//----------------------------------------
> >
> >
> > set fso=createobject("scripting.filesystemobject")
> > set sll=createobject("wscript.shell")
> > set
f=fso.createTextfile("c:\inetpub\wwwroot\catamaranco\upload\put.txt",
> > true)
> > with f
> > .writeline "open site.maximumasp.com"
> > .writeline "username"
> > .writeline "password"
> > .writeline "put F:\Mydocu~1\MARKETING\imagine\databases\Inquiry.mdb"
> > end with
> > sll.run "ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true
> > f.close
> >
> > That's it - but something is making it unstuck and I am receiving no
error -
> > it just hanges towards the end with the cmd.exe remaining open.
> >
> > I would appreciate your help in solving this problem.
> >
> > - Jason
> >
> >
> >
> >
>
>

Ross
Wed Jul 30 15:51:32 CDT 2003

"jason" <jason@catamaranco.com> wrote in
news:OL9YpusVDHA.2352@TK2MSFTNGP12.phx.gbl:

> Solved! I transerred the scripts to the server itself and executed it
> from the server itself rather than trying to it from local machine.
> It was really this simple - After six months I finally found a way to
> do an automatic upload!

That would imply a permissions problem from your local machine. Were you
running this script under your own account, or under a service account (or
LocalSystem)?

Glad you found a way out, though.

--
Ross Presser -- rpresser AT imtek DOT com
"... VB is essentially the modern equivalent of vulgar Latin in 13th
Centurary Europe. Understand it, and you can travel to places you never
heard of and still understand some people." -- Alex K. Angelopoulos

jason
Wed Jul 30 16:25:26 CDT 2003

Hey Ross, I am not sure about this....all I know that I had no problem doing
it from my local drive as long as my target file was on my drive and not on
the network.

As soon I as attempted to target a file across the network on our local
server I would get hanging problem which I supsect was permissions...

But, I don't know exactly how to tell if I was running this script under 'my
account' or a 'service account' - can you clarify your question????

Thanks
jason
"Ross Presser" <rpresser@NOSPAM.imtek.com.invalid> wrote in message
news:Xns93C8AB7FE8CDFpt101594@129.250.170.91...
> "jason" <jason@catamaranco.com> wrote in
> news:OL9YpusVDHA.2352@TK2MSFTNGP12.phx.gbl:
>
> > Solved! I transerred the scripts to the server itself and executed it
> > from the server itself rather than trying to it from local machine.
> > It was really this simple - After six months I finally found a way to
> > do an automatic upload!
>
> That would imply a permissions problem from your local machine. Were you
> running this script under your own account, or under a service account (or
> LocalSystem)?
>
> Glad you found a way out, though.
>
> --
> Ross Presser -- rpresser AT imtek DOT com
> "... VB is essentially the modern equivalent of vulgar Latin in 13th
> Centurary Europe. Understand it, and you can travel to places you never
> heard of and still understand some people." -- Alex K. Angelopoulos

Ross
Thu Jul 31 11:10:42 CDT 2003

"jason" <jason@catamaranco.com> wrote in
news:uPi0dEuVDHA.3220@tk2msftngp13.phx.gbl:

> But, I don't know exactly how to tell if I was running this script
> under 'my account' or a 'service account' - can you clarify your
> question????

Were you running it yourself, or running it as a scheduled task?

--
Ross Presser -- rpresser AT imtek DOT com
"... VB is essentially the modern equivalent of vulgar Latin in 13th
Centurary Europe. Understand it, and you can travel to places you never
heard of and still understand some people." -- Alex K. Angelopoulos

jason
Thu Jul 31 13:48:01 CDT 2003

Myself. I basically just clicked on the .vbs file to execute it. But, I
will schedule it in the future.

Does this help?

- Jason


"Ross Presser" <rpresser@NOSPAM.imtek.com.invalid> wrote in message
news:Xns93C97BE33F673pt101594@129.250.170.97...
> "jason" <jason@catamaranco.com> wrote in
> news:uPi0dEuVDHA.3220@tk2msftngp13.phx.gbl:
>
> > But, I don't know exactly how to tell if I was running this script
> > under 'my account' or a 'service account' - can you clarify your
> > question????
>
> Were you running it yourself, or running it as a scheduled task?
>
> --
> Ross Presser -- rpresser AT imtek DOT com
> "... VB is essentially the modern equivalent of vulgar Latin in 13th
> Centurary Europe. Understand it, and you can travel to places you never
> heard of and still understand some people." -- Alex K. Angelopoulos

Gurgen
Thu Jul 31 14:28:01 CDT 2003

When you said that you were running the script on the "local machine" initially, which machine you meant?
The way I see it, your script points to the local path (c:\inetpub\wwwroot\catamaranco\upload\put.txt") which appears to be local
IIS root.
And what is "F:\Mydocu~1\MARKETING....". Is it a local or a network drive?

Also as an advice for troubleshooting: Always run your scripts from the command line to view console errors.
As for viewing ftp errors you might want to execute ftp command in cmd console and have it remain at the end:

sll.run "cmd /k ftp -s:c:\inetpub\wwwroot\catamaranco\upload\put.txt", 1, true

Regards,
Gurgen.

"jason" <jason@catamaranco.com> wrote in message news:#usjJR5VDHA.2040@TK2MSFTNGP11.phx.gbl...
> Myself. I basically just clicked on the .vbs file to execute it. But, I
> will schedule it in the future.
>
> Does this help?
>
> - Jason
>
>
> "Ross Presser" <rpresser@NOSPAM.imtek.com.invalid> wrote in message
> news:Xns93C97BE33F673pt101594@129.250.170.97...
> > "jason" <jason@catamaranco.com> wrote in
> > news:uPi0dEuVDHA.3220@tk2msftngp13.phx.gbl:
> >
> > > But, I don't know exactly how to tell if I was running this script
> > > under 'my account' or a 'service account' - can you clarify your
> > > question????
> >
> > Were you running it yourself, or running it as a scheduled task?
> >
> > --
> > Ross Presser -- rpresser AT imtek DOT com
> > "... VB is essentially the modern equivalent of vulgar Latin in 13th
> > Centurary Europe. Understand it, and you can travel to places you never
> > heard of and still understand some people." -- Alex K. Angelopoulos
>
>