473,405 Members | 2,154 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

InetTransferLib error -2147219289.

Access collective,

I am running WinNT4.0, Acc2000 SR1 and IE 6.0.
I converted (from Acc97) and imported Dev Ashish's InetTransferLib add-in
modules into my Acc2000 database. Using the sample FTP upload code provided
by Dev, I can connect to my FTP server but it will not upload the specified
file. However, it can create a non-existent directory if I set
..AutoCreateRemoteDir = True.

Dev's sample code with my modifications:
****************************************
Sub TestFTPUpload()
On Error GoTo ErrHandler
Dim objFTP As FTP
Const conTARGET = "ftp://***.***.***.***"

Set objFTP = New FTP
With objFTP
.FtpURL = conTARGET
.SourceFile = "C:\TEMP\File_Name.txt"
.DestinationFile = "/Parent_Dir/Sub_Dir/File_Name.txt"
.AutoCreateRemoteDir = True
If Not .IsConnected Then .DialDefaultNumber
.ConnectToFTPHost "UserName", "PassWord"
.UploadFileToFTPServer
End With

ExitHere:
On Error Resume Next
Set objFTP = Nothing
Call SysCmd(acSysCmdRemoveMeter)
Exit Sub
ErrHandler:
MsgBox Err.Number & vbCrLf & Err.Description, vbCritical + vbOKOnly, Err.Source
Resume ExitHere

End Sub
****************************************

The error I am getting is:
-2147219289
200 Type Set to I

Using my local FTP client from the DOS command line, I can connect,
cd to the desired directory, change type to binary and upload the
file all without error. Also, the FTP server puts me in the root
"/" directory, not a /home/user directory somewhere off root.

In a previous posting concerning this error, I noticed the next
command after "200 Type Set to I" was to set the PASSIVE MODE. I
don't think my FTP server supports passive transfers as some
accompanying documentation says to disable this setting. How and
where can this setting be manipulated?

Also, how can I view what is sent to and passed from the FTP client?
While I have stepped through Dev's code, I can't say I completely
understand all of it. I do see where apiInetGetLastResponse captures
what is presumably the last response from the FTP server when a
command from the FTP object is rejected. How can I see what commands
the FTP object is sending that may be causing the error?

Thanks for any and all help,

Tony
Nov 13 '05 #1
2 2282
I have the same problem, but i i have realiced that it is a problem with
the firewall, if i open all ports the error disapier, but i only onpen
ports 20 and 21 ftp doesn't work.

Nov 13 '05 #2
The problem is as follow:
- first start with active ftp
- my firewall doesn't allow the connection, becouse they are not ports 20
or 21.
- ftp try unsuccessfuly to change to pasive ftp.

any idea about how to solve it?

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Peter | last post by:
Can someone help me with mvps.org's InetTransferLib demo? I successfully brought in InetTransfer sample .mdb and the modules. I can bring up frmTestCases form and when click on any of the...
13
by: deko | last post by:
I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next
0
by: Owen Jenkins | last post by:
I've been using Dev's fantastic InetTransferLib to upload and download files via ftp. Now I'm using the http procedures to have my application download zip files from my website. Although the...
1
by: Owen Jenkins | last post by:
Reposting this message from last week since I have not had a reply so far. Hopefully someone will have an idea? --- I've been using Dev's fantastic InetTransferLib to upload and download files...
0
by: Owen Jenkins | last post by:
My Access application downloads file from my website using the InetTransferLib http functions. One of my clients working from a hospital network gets an error message 'proxy authentication...
0
by: Zarqy | last post by:
I have a DB that dl's graphics. I wold like to be able to display the latest graphics before I get the next one, but currently I get an error (2220) due to the last file not being saved before the...
7
by: p | last post by:
WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying....
2
by: Owen Jenkins | last post by:
Hi again. No responses to the first post 4 days ago, so just trying my luck again. Anyone have any hints where I might get an answer to this? It is an Access problem, but if you can point me to...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.