Case Sensitivity Of Datasource Names

Question

All,

I Have a small confusion about Case sensitivity of ODBC DSN names. Say, you have configured a DSN in your machine with lower case "serverabcd" but in the web.config it's written in upper case "SERVERABCD".

Does that make for a problem OR does the DSN get resolved properly. Any idea?

Thanks.

score 3 · Accepted Answer · answered Mar 15 '11 at 20:49

No. ODBC DSN names are not case sensitive.

You can easily test this by running odbcad32.exe from your command line. Attempt to create a new DSN connection with the same name, but different case, as an existing connection. You'll be notified that the DSN you're trying to create already exists and whether or not you want to overwrite it.

score 1 · Answer 2 · answered Mar 15 '11 at 20:46

1

DSN aren't case sensitive so it will be resolved properly !

answered Mar 15 '11 at 20:46

Arnaud F.

8,252
11
53
102

Case Sensitivity Of Datasource Names

2 Answers2