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);
SQLQuery1.sql.text:='select name from syscolumns');
SQLQuery2.sql.text:='select name from syscolumns');
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.