General discussion

Locked

Adding an ODBC driver

By bes7252 ·
I have an ODBC driver (a DLL file) that I'd like to use. It was installed on Machine_A with a software package. Now I want to use it on Machine_B, but I'd rather not install the entire package if I don't need to.

Is there a way to install an ODBC driver without using the vendor's installer?

Brian

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Adding an ODBC driver

by sl-campbell In reply to Adding an ODBC driver

You may have a license problem/violation here - if not, then you could try the following:

Create a set-up program, with something like VB, yourself (on the system where the drivers are installed by the vendor's install program) and include only the dll(s) in question. If it/they have a dependency file(s) in the system folder then the installation program should pick up and include those extra files.
OR,
Look for a dependency file for the dll in question (Same file name but with a .Dep suffix).
If there is one somewhere, then open it with a text editor and look for the required files that are needed in addition to run the dll. These will need to be added to the receiving system. Then for each of THOSE files, look if they ALSO have a dependency file and if so then add them as well. All these files should be registered with the Regsvr32.exe , at best at the lowest level of dependency and from there upwards,(you may get by with-out registering some of the files by rebooting the system or just copying all of them into the application folder of the program that is going to use them - but you should register them in case special keys need to be written - in that case you will need to check the registry).

You could also use a dependency walker program on the system where original installation is and easily see which files a dll/exe uses.

Collapse -

Adding an ODBC driver

by bes7252 In reply to Adding an ODBC driver

Poster rated this answer

Collapse -

Adding an ODBC driver

by Shanghai Sam In reply to Adding an ODBC driver

I've seen success with exporting the HKEY_LOCAL_MACHINE\Software\ODBC registry key and importing on the new PC, and copying entries from the ODBC.INI on the old to the INI on the new...

These instructions are for System DSNs, see the note at the bottom for User DSNs

Note that all your registry exports have to be in Regedit 4 format if you are moving your ODBC drivers from W2K to any other OS.

1. Export the datasource name - for example, I have "TestingZebra" - (easy to spot in the registry). So I exported the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources\TestingZebra key to a reg file

use regedit, find the key, highlight, File> Export Registry File, save as Regedit 9x/NT...etc.)

2. Next, export the DSN itself... HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TestingZebra to a reg file. Note what path the "Driver" subkey in the reg file is referring to. You'll need to put your DLL there on the new PC (or change the referring path).

3. Find the references to your DSN in the ODBC.INI file on your originating system, copy them to the ODBC.INI file on the new PC. (refer to the note in step 2 about paths)

Again, watch the path names...

4. Copy the referenced .DLL file from step 2 to your new PC (also referenced in your ODBC.INI file).

5. Change any path names that are needed in your reg keys so they reflect where your driver is located on your new PC, and import the keys into the system registry.

6. Reboot your PC, and the drivers shouldthen appear.

These instructions are for System DSNs, if you are looking for User DSNs, go into HKEY_CURRENT_USER (log in as the user account who owns the DSN) in step 1. and 2. rather than LOCAL MACHINE.

Collapse -

Adding an ODBC driver

by bes7252 In reply to Adding an ODBC driver

Poster rated this answer

Collapse -

Adding an ODBC driver

by bes7252 In reply to Adding an ODBC driver

This question was closed by the author

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums