Garbled parameters

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
TimRadford
Posts: 1
Joined: Wed 23 Jun 2010 14:01
Location: London

Garbled parameters

Post by TimRadford » 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

Post Reply