Navigation:  Features >

ODBC

Top  Previous  Next

Update ODBC DSN configurations and driver files on remote hosts.

 

UpdateODBC

 

Stop Sign 32 n g

All ODBC actions, with the exception of Query DSN, cannot be undone and are permanent. Use these features with care.

 

System DSN

The System DSN (Data Source Name) that for the action. The drop-down list is initialized from the local system.

 

Copy DSN

The selected System DSN will be copied to the remote system.

 

Delete DSN

The selected System DSN will be removed from the remote system. The options to copy additional files are unavailable.

 

Query DSN

The selected DSN will be will be queried and information about the driver and database will be displayed. The options to copy additional files are unavailable. This is action is non-destructive.

 

Attempt to Copy Driver Files

Check this box if AutoAdministrator should attempt to copy the driver file that is associated with the ODBC driver as well.

 

Why "attempt"? Many ODBC drivers (e.g. MS SQL Server) consist of dozens of files that make up the ODBC driver, all of which may depend on other ODBC DLLs. Copying drivers like these using AutoAdministrator will not produce the desired result since AutoAdministrator doesn't know which files to copy. Copy additional driver file(s) can be used to specify additional extra files (see below).

 

Stop Sign 24 n g

This option should be used with extreme care, as overwriting system files can destabilize parts (e.g. ODBC) of or the entire Operating System. NETIKUS.NET ltd cannot be held responsible for any damage caused by  incorrect use of this option.

 

The good news is that some ODBC drivers (e.g. MySQL) only consist of one file (the file referenced in the ODBC configuration) and can therefore easily be copied and rolled out with AutoAdministrator.

 

Alert or Warning 1 24 n g

The file that will be copied when using this option is the one specified by the Driver value in the HKLM\Software\ODBC\ODBCINST.INI\<Driver> registry key, where <Driver> is the name of the referenced ODBC driver.

 

Always Overwrite Existing Settings

By default, AutoAdministrator does not overwrite existing settings and files. If the specified DSN name does already exist on the remote machine then the configuration will not be copied. This also applies to files that already exist on the remote machine.

 

Activate this option to force AutoAdministrator to always copy the ODBC settings (and files), regardless to whether they exist on the remote machine or not.

 

Copy Additional Driver Files

This option provides a mechanism to copy extra files in cases where the ODBC driver consists of more than a single file. Files specified here will be copied to %systemroot%\system32, regardless of their original location. See File Copy for a description of file dialog controls.

 

Stop Sign 24 n g

This option should be used with extreme care, as overwriting system files can destabilize parts (e.g. ODBC) of or the entire Operating System. NETIKUS.NET ltd cannot be held responsible for any damage caused by  incorrect use of this option.

 

Replace locked files during next reboot

This option can be used to schedule the replacement of files that are locked by the operating system (e.g. the file is currently in use). The files will be copied to %systemroot% and moved to %systemroot%\system32 when the machine is rebooted. AutoAdministrator can be used to schedule a subsequent reboot on remote machines, see Shutdown / Reboot.

 

Stop Sign 24 n g

This option should be used with extreme care, as overwriting system files can destabilize parts (e.g. ODBC) of or the entire Operating System. NETIKUS.NET ltd cannot be held responsible for any damage caused by  incorrect use of this option.