Re: ODBC/OLE DB Connection Pool
From: Stuart Carnie (StuartCarnie_at_newsgroup.nospam)
Date: 11/29/04
- Next message: Scotter: "pause using ASP or MS Access?"
- Previous message: jason_at_catamaranco.com: "Add Join/lookup to sp in sql server"
- In reply to: Erland Sommarskog: "Re: ODBC/OLE DB Connection Pool"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 15:48:03 -0700
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns95B0EC9C1A6B6Yazorman@127.0.0.1...
> Stuart Carnie (StuartCarnie@newsgroup.nospam) writes:
> > "Provider=SQLOLEDB;Data Source=mySQLServer;Initial Catalog=pubs;User
> > ID=sa"
> >
> > is treated differently to
> >
> > "Provider=SQLOLEDB;Data Source=mySQLServer;Initial Catalog=pubs;User
> > ID=SA"
> >
> > where I have changed the case of SA, despite the fact SQL Server treats
> > these the same.
>
> That depends on the server collation. If the server collation is case-
> sensitive - and mines always are - then 'sa' and 'SA' are two different
> users.
>
> Thanks for a very interesting post!
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Fair enough :) My demonstration was the sensitivity of the string and / or
properties - other things such as one connection containing a Workstation ID
property and another lacking it will also cause a new connection to be
established..
No worries - hope it helps!
Cheers,
Stu
- Next message: Scotter: "pause using ASP or MS Access?"
- Previous message: jason_at_catamaranco.com: "Add Join/lookup to sp in sql server"
- In reply to: Erland Sommarskog: "Re: ODBC/OLE DB Connection Pool"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
