Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .