Hi!
I have a web service that is used by a smart client (windows forms).
It normally works ok, but occasionally I get the following error-message:
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> System.Exception: System.Data.SyntaxErrorException: Syntax
error: Missing operand after 'Agata' operator.
at System.Data.ExpressionParser.Parse()
at System.Data.DataExpression..ctor(String expression, DataTable table,
Type type)
at System.Data.Select..ctor(DataTable table, String filterExpression,
String sort, DataViewRowState recordStates)
at System.Data.DataTable.Select(String filterExpression)
at JOH.MACH2.TIX.FileGenerator.GenerateFile(DataSet ds, Int32 mode)
at JOH.MACH2.TIX.FileGenerator.ByInvoiceNo(String InvoiceNo)
at CustomsService.TIX.ByInvoice(String Plant, String InvoiceNo)
--- End of inner exception stack trace ---
at MACH2_TIX.Form1.button2_Click(Object sender, EventArgs e)
As you will see from the message, I use the parameters provided by the smart
client, through the web-service, to make database queries.
The strange thing is that this message only seems to occur (occasionally)
when the client is used over a WAN. I am not able to reproduce the error
when running the client on the same LAN as the server (Windows 2000 AS).
Have anyone seen similar behavior?
Jan Ove Halvorsen