Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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

2 Answers 2

up vote 0 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
    
I don't think I need another one, but how can I read the parameters? In the gui I can see only Spanish, but not Español. –  Bernat Nov 16 '12 at 10:48

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

 
discard

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.