Link to home
Start Free TrialLog in
Avatar of Michael Williams
Michael WilliamsFlag for United States of America

asked on

CFFTP: Could not parse response code

I've obviously replaced the import info : )

I get the following error when I run this code:
An error occurred while establishing an FTP connection.  
Error: Could not parse response code. Server Reply: SSH-2.0-0.0 .

I'm a newbie using this CF Tag. What does this mean ?
<p>cfftp lets users implement File Transfer Protocol operations. By default, cfftp caches
    an open connection to an FTP server.</p>
<p>cfftp operations are usually of two types:</p>
 
<ul>
    <li>Establishing a connection
    <li>Performing file and directory operations
</ul>
 
<p>This example opens and verifies a connection, lists the files in a directory, and closes
    the connection.</p>
 
<p>Open a connection</p>
 
<cfftp action = "open"
    username = "USER"
    connection = "My_query"
    password = "PASS"
    port="22"
    server = "TEST_SERV"
    passive="yes"
    stopOnError = "Yes">
 
<p>Did it succeed? <cfoutput>#cfftp.succeeded#</cfoutput>
 
<p>Close the connection:</p>
 
<cfftp action = "close"
    connection = "My_query"
    stopOnError = "Yes">
 
<p>Did it succeed? <cfoutput>#cfftp.succeeded#</cfoutput>

Open in new window

Avatar of duncancumming
duncancumming
Flag of United Kingdom of Great Britain and Northern Ireland image

the remote host is expecting SSH instead of FTP.  Are you sure about your port number?  The default for FTP is 21, and for SSH is 22.  
Avatar of Michael Williams

ASKER

When I use 21 I get the following response:
An error occurred while establishing an FTP connection.  
Error: Connection reset.

Try changing stopOnError = "Yes" to stopOnError = "No" and see what difference if any that makes
Now I get the following:
Invalid connection specified.
The connection attribute you specified, 'My_query', is invalid or does not exist.

Did it succeed? NO
So that would fail because there's isn't a connection right ? It fails on the close.
You're sure the FTP server is up and running, and when you try and do a normal FTP connection to it, with those settings, from that CF server it works?
Like I said before I'm a newbie. As far as I know the server I'm trying to connect to is up and runnung. I will verify that.

What do I need to do on my end ?
Avatar of gdemaria
start by connecting to the web service using your ftp program on your PC.  If you don't have one try entering  ftp.theDomainName.com  as the address into your browser.  

Your code is showing "TEST_SERVER"  and dummy values for username and password.   I assume your code has the real values for these parameters and you're just altering it for public display..
Yes, I'm altering the values.

The ftp would be: fileserv.fmcsa.dot.gov

Is this FTP or is this SSH ? If it is a true FTP would it be ftp.******* ?
It doesn't seem to be an ftp site, I think you should find out what it is
If it is a true FTP would it be ftp.******* ?

not necessarily.
Ok

I will wait for the guy from the vendor to call me. I'll let yall know what happens : )
There's a chance that ftp is disallowed and that SSL-SFTP is operating on port 22. Try downloading core ftp le and connect to the site via ssh on port 22. If you're prompted about a security certificate, just accept it. If it connects, then I'd say there's no open ftp allowed to the server.

http://www.coreftp.com/download/

On windows, you want coreftplite.exe
Ok, so I download coreftp. I have to switch to SSL-SFTP and use port 22. It comes back with: "SFTP connection error - Invalid username or password reported by server"

So obviously I need the correct Username or Password. I was told I had the correct one. I'm currently waiting for the Vendor to get back with me.

Lets say I get the correct Username and Password, will I be able to connect via CFFTTP using SSL-SFTP ?
ASKER CERTIFIED SOLUTION
Avatar of v2Media
v2Media
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Well I can get to the directory if I use the Private Key provided. The directory doesn't actually have anything in it. I need to deal with them for this.

I guess my question would be how I can handle this FTP with SQL Server 2005 ? Any resources you all may no off for this type of FTP ?
FTP is FTP, either the files get there or they dont. Core FTP can connect and transfer the files yes? What more do you need...
I guess I was trying to have a process out of one application : )

I guess it makes more sense to get an FTP Program and schedule a job to run at a certian time. I can then use what ever form of application or scripting to manipulate the downloaded file. This process would also be scheduled.
Told you I was new at this : )
Welcome to dreamweaver. Perfect one day, hell the next.