SQL Server connection string keywords act as case-sensitive, although they should not be

Question

I use .NET OdbcConnectionStringBuilder to update the connection string read from the configuration file, which makes its keys more strict, as described in MS ("Data Source" → "Data Source").

The connection string is used to access MS SQL Server (2008, if that matters).

It works fine on my machine (Windows 7 32 bit), and according to MS documentation it should work:

Keywords are not case sensitive.

However, on several other machines (at least some of them are 64 bits), the database connection cannot be opened in this lower case. Only after changing the keywords manually in the source case (upper case on the letter of each word) was a connection to DB opened.

Keywords in the connection string (all changed in lowercase):

• Data Source
• Initial Catalog
• Integrated Security

Answer 1

Have you looked at the sort settings?

http://msdn.microsoft.com/en-us/library/ms143508(v=sql.105).aspx