I used the code from http://www.example-code.com/sql/ftp.asp to create a store procedure to transfer file via ftp protocal In the script, I added some info below:
EXEC @hr = sp_OACreate 'Chilkat.Ftp2', @ftp OUT
After I ran the store procedure and got the message below:
Because I want to connect to that ftp folder via port 22. Should I use
"SFTP" is the Secure File Transfer Protocol over SSH. It is a protocol unrelated to the FTP protocol. The Chilkat SSH / SFTP component is used for "SFTP". SFTP is achieved by connecting to an SSH server at port 22.
On the other hand, the Chilkat FTP2 component is for FTP. FTP servers listen at port 21 (non-SSL/TLS) and port 990 (SSL). FTP over SSL (i.e. port 990) is called "FTPS".
answered May 02 '13 at 07:28
Thank you very much for your answer. I'm a newbie to this topic.
The unlock code is a valid one, but for the wrong product. If the Chilkat Bundle was purchased, find and use the unlock code containing the following product substring: requiredProductSubstring: SSH For a 30-day trial, pass a string such as "Hello World" to UnlockComponent.
This mean I got unlock code for Ftp2 product. And now if I want to use Ssh, I should buy another unlock code, right? Thank you
answered May 02 '13 at 21:39