Garbled parameters
Posted: Wed 23 Jun 2010 14:23
I've downloaded your Sql Server driver in order to investigate whether I can convert a web service to use dbExpress. However, in the context of a small test program my stored procedure parameters are getting garbled.
In the Delphi code I set:
ParamByName('UserID').AsString := 'Tim';
ParamByName('Qualifier').AsString := 'DATACRAFT';
but in the SQL Server profiler I see:
exec dwsAuthenticate 'Tim ¬Ì`N“v €t EcvE¢Ì`N3v €','DATACRAFT wéÕK €æ '
The garbage characters are not the same every time.
To rule out other problems with my code I did the same thing purely in the form designer, with similar results.
Any idea what I may be doing wrong?
Hope you can help
Tim
In the Delphi code I set:
ParamByName('UserID').AsString := 'Tim';
ParamByName('Qualifier').AsString := 'DATACRAFT';
but in the SQL Server profiler I see:
exec dwsAuthenticate 'Tim ¬Ì`N“v €t EcvE¢Ì`N3v €','DATACRAFT wéÕK €æ '
The garbage characters are not the same every time.
To rule out other problems with my code I did the same thing purely in the form designer, with similar results.
Any idea what I may be doing wrong?
Hope you can help
Tim