System DSN command prompt

Question

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

I'm trying this on both x86 and x64, doing this on the system32 or the syswow64 folders. — Bernat, Nov 16 '12 at 07:33

score 1 · Answer 1 · answered Nov 15 '12 at 16:03

1

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

answered Nov 15 '12 at 16:03

Frank Thomas

1

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 07:36

score 1 · Accepted Answer · answered Nov 15 '12 at 16:05

1

That parameter you are looking for is: LANGUAGE=Espanol

Or you can use gui tool odbcad32.exe

answered Nov 15 '12 at 16:05

week

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 07: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

2 Answers2