EOLEDBError with message 'QueryInterface failed'.[OK]

[rafakwolf]

Hello...

The error EOLEDBError with message 'QueryInterface failed' when i execute this simple query:

Code: Select all

var cmd : TDBXCommand;
    reader: TDBXReader;
begin
  cmd := getDBXCommand;
  cmd.Text := 'SELECT i.id_instituicao FROM dbo.gc1_ac_instituicao i WHERE i.id_cliente_theossystem = '+IntToStr(id);
  reader := cmd.ExecuteQuery;

  if reader.Next then
    Result := reader.Value['id_instituicao'].AsInt32
  else
    Result := 0; 

Thanks in advance.

[AndreyZ]

Hello,

I cannot reproduce the problem. Please specify the following:
- the exact version of your IDE;
- the exact version of dbExpress driver for SQL Server you are using;
- the exact version of your SQL Server server and client.

[rafakwolf]

Hello...

Delphi version = Xe3 update 2.

Devart Driver Version = 6.1.2.0

sql server native Client DLL = 2007.100.5500.0

thanks and waiting

[AndreyZ]

Unfortunately, I still cannot reproduce the problem. Please try creating a small sample that demonstrates this problem and send it to andreyz*devart*com , including the script to create and fill the gc1_ac_instituicao table.

[rafakwolf]

Hello...

my problem is solved...

in this line "cmd := getDBXCommand;"

reuse TDBXCommand object does not works...

but when I created a new one every execution, it works...

thanks!

[AndreyZ]

It's good to see that you have found a solution. If any other questions come up, please contact us.