1. Home

Product groups

Support

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 (6355 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

locked
  1894 views

Re: Syntax error in parameters or arguments.

by wodSupport, Friday, December 22, 2006, 17:50 (6355 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

locked
  1910 views

Re: Syntax error in parameters or arguments.

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

server.HTMLEncode(fileName)

encoding the filename string worked

locked
  1919 views

Re: Syntax error in parameters or arguments.

by wodSupport, Friday, December 22, 2006, 18:19 (6355 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

locked
  1937 views

Re: Syntax error in parameters or arguments.

by wodSupport, Friday, December 22, 2006, 18:21 (6355 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

locked
  1904 views

The people at WeOnlyDo are amazing! ... I always get a super fast response from customer service, and the products are great too. Thanks WeOnlyDo

Jeff Hall
Occupational Health Research

Your support is fantastic.

Douglas Michael Panchyshyn
The Net Software Group

...not only that you provide these components at very reasonable cost, your responsiveness to emailed technical questions is simply outstanding...

Michael Thomas
ClownRed Media

The people at WeOnlyDo are amazing! ... I always get a super fast response from customer service, and the products are great too. Thanks WeOnlyDo

Jeff Hall
Occupational Health Research

Thanks! We love your software and your great support!

Sandy Fliderman
Primary Development Corporation

...with WOD's excellent support I was able to bypass Winsock and focus on the task at hand...

Sander Pool
Rhapsody Networks

Thanks! We love your software and your great support!

Sandy Fliderman
Primary Development Corporation

...wodFtpDlx was exactly what I needed, it worked, and it was priced right...

David Keenan
Serengeti Systems Incorporated

...wodFtpDlx was exactly what I needed, it worked, and it was priced right...

David Keenan
Serengeti Systems Incorporated

I can only hope I will have the pleasure to work with other products by "We Only Do" in the future.

Tomer Spivak
Verint Systems Ltd