Re: ODBC/OLE DB Connection Pool

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 22:16:39 +0000 (UTC)

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

Relevant Pages

  • Re: SQL Server 2005 - Save tran save point name case sensitive?
    ... And it's not that it has to do with the server collation. ... with a case-sensitive server collation, but I tried this on a case- ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: ODBC/OLE DB Connection Pool
    ... Stuart Carnie writes: ... > where I have changed the case of SA, despite the fact SQL Server treats ... That depends on the server collation. ... Books Online for SQL Server SP3 at ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... Stuart Carnie writes: ... > where I have changed the case of SA, despite the fact SQL Server treats ... That depends on the server collation. ... Books Online for SQL Server SP3 at ...
    (microsoft.public.data.oledb)
  • Re: ODBC/OLE DB Connection Pool
    ... >> where I have changed the case of SA, despite the fact SQL Server treats ... > That depends on the server collation. ... properties - other things such as one connection containing a Workstation ID ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... >> where I have changed the case of SA, despite the fact SQL Server treats ... > That depends on the server collation. ... properties - other things such as one connection containing a Workstation ID ...
    (microsoft.public.inetserver.asp.db)