how can i solve it?

Posted on 2007-11-28
Medium Priority
Last Modified: 2008-02-01
Hello Experts,
i got the same error "runtime error 35764 the connection is still on execution"
i am usgin a my ftp connection application and it send my file one by a timer funciont
any idea where is the cause?
Question by:aitsu01

Expert Comment

ID: 20367172
what is the code?
LVL 10

Accepted Solution

3_S earned 150 total points
ID: 20367838
you should disable the timer when it start the routine
timer.enable = false
timer.enable = true
when the routine is finished

between you set the code for your ftp connection

If you do not disable the timer and the routine takes longer to run than the time set for the timer the timer will start the routine several times (every time the interval of the timer is reached)

Author Comment

ID: 20372355
Hello Experts,
well it seems solved now
i will attach here the problem's code:

Private Sub Timer1_Timer()
Kill "c:\lmyfile.txt" " the ftp application was still on execution on the text file"
 Load my function

Private Sub TimerHook_Timer()

On Error Resume Next " it will be ignored"
Kill "c:\myfile.txt"
 Load myfuncion

this solution can be a bit dirty but it works,anyway i listen new more suitable solutions
for example now the problem that the new text file willl append at ever ftp sending with the old text file content,so it will be pretty big after.any good advice?Thank you ina dvance


Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question