Parameter assignment problem with ADOQuery using Birebird DB and ODBC driver



Hi,
I am using Firebird database with XTG ODBC driver, I have a 'big' problem
with parameter assignment of TADOQuery component uing the following simple
query under Delphi 7:

strSQL := 'select * from ASSOCIATE where LASTNAME = :LName';
ADOQrySelect.Active := False;
ADOQrySelect.SQL.Clear;
ADOQrySelect.SQL.Add(strSQL);
ADOQrySelect.Prepared := True;
ADOQrySelect.Parameters.ParamByName('Lname').DataType := ftString;
ADOQrySelect.Parameters.ParamByName('Lname').Direction := pdInput;
ADOQrySelect.Parameters.ParamByName('LName').Value := 'Bond';
ADOQrySelect.Active := True;

It raises OleException with message: "Parameter object was improperly
define" when the compiler is trying to run "ADOQrySelect.Active := True;".
However, if I use static SQL query string, it works fine.

Can someone please points out what is wrong?

TIA,

GD


.