I have an application that works perfect in oracle and interbase, but when using sql server, it open more than one connection.
the example below shows this: (using delphi7 sqlserver dbexpress connection):

procedure TForm1.Button1Click(Sender: TObject);
begin
SQLQuery1.sql.text:='select name from syscolumns');
SQLQuery2.sql.text:='select name from syscolumns');
SQLQuery1.Open;
SQLQuery2.Open;
end;

In Analyser, type sp_who and you will see two connections.

A way to correct this is use client components in all applications, other is using 3rt part sqlserver dbexpress drivers.

Any other options using native delphi drivers??