Devart Forums

Posted: **Mon 13 May 2013 19:02**

Hello...

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

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.

Posted: **Tue 14 May 2013 14:17**

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.

Posted: **Tue 14 May 2013 18:28**

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

Posted: **Wed 15 May 2013 10:20**

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.

Posted: **Mon 20 May 2013 11:20**

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!

Posted: **Mon 20 May 2013 12:49**

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

Devart Forums

EOLEDBError with message 'QueryInterface failed'.[OK]

EOLEDBError with message 'QueryInterface failed'.[OK]

Re: EOLEDBError with message 'QueryInterface failed'.

Re: EOLEDBError with message 'QueryInterface failed'.

Re: EOLEDBError with message 'QueryInterface failed'.

Re: EOLEDBError with message 'QueryInterface failed'. [RESOLVED]

Re: EOLEDBError with message 'QueryInterface failed'.[OK]