Topic "Problems with VBA"

Author Message
ES_Light
[View user's profile]

Joined: 2013-01-02
Posts: 2
Hi from Barcelona,
I've readed all documentation about connect WinScp with VBA. I'm using the example code published... But I'cant connect! The message is allways the same "server key is not validated".
The code is:

...
' Setup session options
Dim mySessionOptions As New SessionOptions
With mySessionOptions
.Protocol = Protocol_Sftp
.HostName = "ifs.correos.es"
.userName = "xxx"
.Password = "xxx"
.SshPrivateKeyPath = "c:\xxx.ppk"
.SshHostKeyFingerprint = "ssh-dss 1024 fe:34:03:a0:55:e7:82:23:7e:84:98:91:70:e1:31:e3"

End With

' Connect
mySession.Open mySessionOptions 'IT FAILS!!!!
...

I take the KeyFingerprint from PuttyGen...
If I tray to connec by WinScp directly, it works! But with VBA not....

Can you help me what I'm doing wrong?

Thanks and Happy New Year!
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25014
Location: Prague, Czechia
Please attach a complete session log file both from GUI and the .NET.
ES_Light
[View user's profile]

Joined: 2013-01-02
Posts: 2
prikryl wrote:
Please attach a complete session log file both from GUI and the .NET.


Hi prikryl,
I've tryed to do it... But Log of Winscp is not launched if I'm using VBA... Neither I know how I can send you a Log file from Access application...
Please, help me on it!

Thanks!
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License