Export (0) Print
Expand All

ODBCCONF.EXE

ODBCCONF.exe is a command-line tool that allows you to configure ODBC drivers and data source names.

Note Note

ODBCCONF.exe will be removed in a future version of Windows Data Access Components. Avoid using this feature, and plan to modify applications that currently use this feature. You can use PowerShell commands to manage drivers and data sources. For more information about these PowerShell commands, see Windows Data Access Components PowerShell Commands.


ODBCCONF [switches] action

switches

Zero or more switch options. For the list of available switches, see the Remarks section, later in this topic.

action

One action to perform. For the list of available options, see the Remarks section.

The following switches are available:

Switch

Description

/A {action}

Specify an action.

/A is optional if only one action is specified.

/?

Display usage for ODBCCONF.EXE.

/C

Processing continues if an action fails.

/E

Erase the response file specified with /F when processing is finished.

/F

Use a response file, such as odbcconf /F my.rsp.

my.rsp might look like this:

REGSVR c:\my.dll

/A is not used in a response file.

/H

Display usage (Help). This switch is the same as /?.

/L[mode] filename

Send program output to a file in one of three modes: normal (n), verbose (v), and debug (d). Debug mode records the DLLs that are loaded by odbcconf.exe.

If you specify /L without a mode, the log file will be empty.

For example, /Lv log.txt.

/R

The action will be performed after a reboot.

/S

Silent mode. Do not display error messages.

The following actions are available:

Action

Description

CONFIGDRIVER driver_name driver-specific configuration params

Loads the appropriate driver setup DLL and calls the ConfigDriver function.

Equivalent to the SQLConfigDriver function.

For example:

/A {CONFIGDRIVER " Driver Name" "CPTimeout=60"}
/A {CONFIGDRIVER " Driver Name" "DriverODBCVer=03.80"}

CONFIGDSN driver_name DSN=name|attributes

Adds or modifies a system data source.

Equivalent to the SQLConfigDataSource function.

For example:

/A {CONFIGDSN "SQL Server" "DSN=name|Server=srv"}

CONFIGSYSDSN driver_name DSN=name|attributes

Adds or modifies a system data source.

Equivalent to the SQLConfigDataSource function.

For example:

/A {CONFIGSYSDSN "SQL Server" "DSN=name|Server=srv"}

INSTALLDRIVER

Equivalent to SQLInstallDriverEx Function.

For information about the keyword-value pairs syntax passed to INSTALLDRIVER, see Driver Specification Subkeys.

For example:

/A {INSTALLDRIVER  "Your Driver|Driver=c:\your.dll|Setup=c:\your.dll|APILevel=2|ConnectFunctions=YYY|DriverODBCVer=03.50|FileUsage=0|SQLLevel=1"}

INSTALLTRANSLATOR translator configuration driver path

Adds information about a translator to the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Translators registry key.

Equivalent to SQLInstallTranslatorEx Function.

For information about the keyword-value pairs syntax passed to INSTALLDRIVER, see Translator Specification Subkeys.

For example:

/A {INSTALLTRANSLATOR  "My Translator|Translator=c:\my.dll|Setup=c:\my.dll"}

REGSVR dll

Registers a DLL.

Equivalent to regsvr32.exe.

For example:

/A {REGSVR c:\my.dll}

SETFILEDSNDIR

When HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN\DefaultDSNDir does not exist, the SETFILEDSNDIR action will create it and assign it the value at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\CommonFilesDir, appended with \ODBC\Data Sources.

The value at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN\DefaultDSNDir specifies the default location used by the ODBC Data Source Administrator when creating a file-based data source.

For example:

/A {SETFILEDSNDIR}
Show:
© 2014 Microsoft