Problems with VBA

Advertisement

ES_Light
Joined:
Posts:
2

Problems with VBA

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!

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
29,760
Location:
Prague, Czechia

Re: Problems with VBA

Please attach a complete session log file both from GUI and the .NET.

Reply with quote

ES_Light
Joined:
Posts:
2

Re: Problems with VBA

martin 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!

Reply with quote

Advertisement

You can post new topics in this forum