Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can create a System DSN connection via the following command:

odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=NAME|Description=DESCRIPTION|SERVER=MYSQLSERVER|Trusted_Connection=Yes|Database=DBNAME"}

I need to create it with an specific option, but I can't find it anywere: establishing the language for SQL Server system messages to Spanish

Does anybody know how to do it?

Thanks in advance

share|improve this question
what OS are you on? – Frank Thomas Nov 15 '12 at 16:02
I'm trying this on both x86 and x64, doing this on the system32 or the syswow64 folders. – Bernat Nov 16 '12 at 7:33
up vote 1 down vote accepted

That parameter you are looking for is: LANGUAGE=Espanol

Or you can use gui tool odbcad32.exe

share|improve this answer
Thanks for your answer. That's what I was looking for!! I tried with Language=Spanish, ES, ES_ES, and so others. The correct one is: Language=Español – Bernat Nov 16 '12 at 7:51
If you'll need another languages or options, use that odbcad32 GUI to create File DSN, then you can read parameters from that file. – week Nov 16 '12 at 10:30

usually they end up in ControlPanel -> Administrative Tools -> Data Sources (ODBC) on Windows systems.

share|improve this answer
Yes I know, but I need this via command line because I have to reproduce in more than 40 computers. – Bernat Nov 16 '12 at 7:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.