PDA

View Full Version : Install ODBC Driver Question



NewsArchive
08-23-2007, 11:47 PM
Using the Install ODBC Driver script command, does this modify both the
registry (HKLM\Software\ODBC\ODBC.INI and HKLM\Software\ODBC\ODBCINST.INI) and
configuration files (ODBC.INI and ODBCINST.INI)? I notice when I add this
script command for the TopSpeed ODBC Driver, it automatically enters all the
Data Source Attributes except UsageCount. Is this handled automatically? And,
if so, is it created as a DWORD type?

I am running XP SP2 and was surprised to see ODBC.INI and ODBCINST.INI files in
C:\Windows. They appear to mostly duplicate the information in the
registry.

On a similar note, it would be great to have a script command to Install ODBC
Data Source. By looking at the registry entries, it looks like I can do it
myself by adding entries below HKLM\Software\ODBC\ODBC.INI or
HKCU\Software\ODBC\ODBC.INI. Still. have a "one stop shopping" with a single
install script command would be cool. I guess there would need to be options
for the type of DSN to install and a place to specify the file for a file DSN
if that type was selected.

Peter Gysegem
Beaver Creek Software

NewsArchive
08-23-2007, 11:47 PM
Peter,

The installer does not "touch" the registry for ODBC driver installations.
Instead, the installer calls the appropriate Windows APIs to install
drivers. These APIs handle all the stuff automatically.

To handle ODBC data sources, just use the "Config ODBC Data Source" script
function.

Does this help?

Friedrich

NewsArchive
08-23-2007, 11:48 PM
Thanks Friedrich,

This helps a lot. I'm a little embarassed to say that I never noticed the
Config ODBC Data Source script function. I looked for "Install..." or
"Edit..." but missed Config.

Peter Gysegem
Beaver Creek Software