Syntax error in parameters or arguments. (wodSFTP / wodSFTP.NET / wodSFTPdll)

I am getting an error when trying to put a file on a remote server over and sFTP connection

[code]
oFTP.PutFile fileName , rs( FTPDropOffDir )
fileName = D:Program Files\XXXXXX\XXXXXXXXX\XXXXXX\XXXXXX\XXXXX\XXXXX\ASG_AM_Patient_122220060842.txt
rs( FTPDropOffDir )= /users/xxxxxx/
[/code]
WeOnlyDo.wodFtpDLXCom.1 error '800a9e35'

Syntax error in parameters or arguments.

Any ideas? thanks

Ogedei,

if you hardcode those values instead of

rs( FTPDropOffDir )

just for a test, does it work? Could it be that your 'rs' function doesn't return string, but perhaps variant, or something else that wodFtpDLX cannot determine what it is? If you change it to

Dim a as string
a = rs( FTPDropOffDir )
FtpDlg.PutFile(a,....)

does that work? That way you explicitly give strings to PutFile.

Kreso

server.HTMLEncode(fileName)

encoding the filename string worked

What if you use string variable to store that value, and then pass that to wodFtpDLX (my 2nd suggestion)? Did you try that?

Kreso

BTW if this is ASP then I think you should also use

Ftp1.PutFile cstr(xxxxxxx), cstr(xxxxxx)

that should work too.

Kreso