Re: Db connexion mode ???

In this case, the Connection pool (which resides on the client) is created
for each client application--even if they are identical. The Connection Pool
was designed to deal with ASP issues and does not really help Windows Forms
application performance--as a matter of fact, it can hurt performance and
can cut back on the number of data access alternatives.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E0A1842-A393-4FC5-8DCA-7AAF93E9ECCC@xxxxxxxxxxxxxxxx
This is a windows forms application.
IN fact I have different windows forms application in separate exe file
each.
Each also make some requets to database

"William (Bill) Vaughn" wrote:

Ah, is this an ASP.NET application or a Windows Forms application? If the
latter, the Connection pool is not a factor. Each process/program gets
its
own pool.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"serge calderara" <sergecalderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:3F10235E-E02D-4726-99E4-5E23A3E0F92B@xxxxxxxxxxxxxxxx
Dear all,

I have different .NET library which request a connection to an SQL
server
database.
As far as I understoo authentication methode for SQL, as long as we
have
windows oprating system everywhere we can select SSI authentication
methode
for the database connection string. But in case if I have 5 different
login
user connecting at the same time to the database using such method, it
will
create 5 different connection string that will be aplce in the pool (
if
pooling is sued right) right ?

So in oder to use a single connection string ro all my library
accessing
to
the sever, would it be more eficcient to define an SQL authentication
method
with a unique user credential that everyone will use concurantly ?
Does this solution will simplify and improve connection performance by
having such unique conenction string ? in that way we do not need to
handle
pooling.

As also I do not want to make any login tracing, windows authentication
might not be necesary in that case.

Any comment ?

Thanks for help
Regards





.

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Connection Problems
    ... What I didn't understand before, is that you can create a database that is not attached to the SQL server. ... The common connection strings I've encountered only work when the database is provided by the SQL server. ... connection string not working. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server BE behind firewall
    ... You have mixed ODBC with OLEDB parameters in your connection string. ... > and the code proceeds, but when I look at the SQL Server logs, I see no ... >>> Is the user actually hitting the SQL Server machine? ...
    (microsoft.public.access.formscoding)
  • Re: Session state not working
    ... Check your connection string. ... If you specify a trusted connection to your SQL Server in the configuration file using the ... if you haven't installed the SQL Server database with the Aspnet_regsql.exe tool. ...
    (microsoft.public.dotnet.framework.aspnet)