Topic "Using Putty commands in SQL Server Enterprise ActiveX Script"

Author Message
Kiran Gilhotra

Guest


Please help. I would like to use pscp commands in my SQL Server Enterprise ActiveX Script tp move files from my Access Database to a clients server. The server name I am calling is an IP address.

In the automatically activated batch file, it does not run.

my commands read as follows

'Create Prod upload File
set conBatchFileTest = oFS.CreateTextFile("g:\uploads\load_latest_TESTsup.bat", True)
conBatchFileTest.Writeline("g:\pscp -pw XXXX g:\uploads\" & strFolder & "\*supplier* dtf@167.30.155.205:/export/home/dtf/in/prod")
conBatchFileTest.Close

set conBatchFileProd = oFS.CreateTextFile("g:\uploads\load_latest_PRODsup.bat", True)
conBatchFileProd.Writeline("g:\pscp -pw XXXX g:\uploads\" & strFolder & "\*supplier* dtf@167.30.154.205:/export/home/dtf/in/prod")
conBatchFileProd.Close

The problem is, it always prompts this warning sign

The server's host key is not cached in the registry. You have no guarantee that the server is the computer you think it is. The server's key fingerprint is ****

If you trust this host, press YEs. To connect without adding host key to the cache, press No. To abandon the connection press Cancel.

Continue connecting and add host key to the cache ?

Yes, No, Cancel ?

I think that is why the code does not execute, could you tell me how to overcome this problem ?
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24530
Location: Prague, Czechia
Please read PuTTY wish accept-host-keys. If you still have questions to ask, try again Smile or better ask at Putty support forum.
_________________
Martin Prikryl
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