Syntax error in parameters or arguments. - WeOnlyDo Discussion board

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

by Ogedei, Friday, December 22, 2006, 17:47 (6546 days ago)

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

Re: Syntax error in parameters or arguments.

by wodSupport, Friday, December 22, 2006, 17:50 (6546 days ago) @ Ogedei

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

Re: Syntax error in parameters or arguments.

by Ogedei, Friday, December 22, 2006, 18:11 (6546 days ago) @ wodSupport

server.HTMLEncode(fileName)

encoding the filename string worked

Re: Syntax error in parameters or arguments.

by wodSupport, Friday, December 22, 2006, 18:19 (6546 days ago) @ Ogedei

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

Kreso

Re: Syntax error in parameters or arguments.

by wodSupport, Friday, December 22, 2006, 18:21 (6546 days ago) @ wodSupport

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

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

that should work too.

Kreso