How to Config ODBC User/System DSN

[Malay Dave]

There is one file called odbcconf.exe availabel into %
systemroot%/system32 directory. Is it used for config new
User/System DSN. How to create with this file, I mean waht
parameter we have to pass. I want complete sysntax with
example.

If this ustility is not for the same then, how to create
new User/System DSN without using ODBC Administratorin
applet. I want to create through program/command-line.

Kindly help me in the same.

Malay Dave

[Russ Gray [MS]]

Hi Dave

The file ODBCConf.exe doesn't do what you think it does. That file is used
to register the standard ODBC files and drivers, since they don't register
with regsvr32.

I think that what you want is detailed in KB article

HOWTO: Configure ODBC Data Sources on the Fly
ID: 110507

I hope this helps,

Thanks,

Russ Gray
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.