Can't create a new ODBC DSN using odbcconf

Detail name	Value
Changelog Number	7954
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, Exasol 6.1.0
Fix Versions	Exasol 6.0.16, Exasol 6.1.4
Resolution Date	2019-06-18

Bug

The tool odbcconf.exe cannot be used to create an Exasol ODBC DSN.

Problem Description

Trying to create an Exasol ODBC DSN using odbcconf.exe the command simply returns without any effects or error messages.

Workaround

An Exasol ODBC DSN has to be manually created or by modifying the registry directly.

Changed behavior

You will be able to use the tool odbcconf.exe to create an Exasol ODBC DSN programaticaly.
To configure a 32 bit Exasol ODBC Driver you need the 32 bit odbcconf:

C:\Windows\SysWOW64\odbcconf.exe

To configure a 64 bit Exasol ODBC Driver you need the 64 bit odbcconf:

C:\Windows\System32\odbcconf.exe

To create a new DSN you can use the parameter "configdsn" for a user DSN and "configsysdsn" for a System DSN.
All Exasol ODBC connection string parameters can be given to the new DSN.

Normally, the Exasol config dialog is displayed. If you want to do the configuration without the dialog, you have to add "silent=Y" to the connection string parameters.

Example

C:\Windows\System32\odbcconf.exe configsysdsn "EXASolution Driver" "DSN=test1;silent=Y;EXAhost=abc;EXAUID=myuser;EXAPWD=mypwd;logfile=some_file;logmode=debug comm"

Changed behavior