Export/Import ODBC Settings

Science & Technology Information Technology, Gaming, Machines, Gadgets
1

Any easy way to export and import ODBC settings other then MS instructions( export registry and import to new pc)?
I tried MS way and now its BSOD:bummer:

2

Re: Export/Import ODBC Settings

blue screen just from a ODBC? Thats odd....

3

Re: Export/Import ODBC Settings

imported reg keys and BSOD

4

Re: Export/Import ODBC Settings

Is this what you used?

Copy ODBC Configurations from one PC to another

5

Re: Export/Import ODBC Settings

Another one:

export - Exporting ODBC System DSNs from a windows 2003 machine? - Stack Overflow

6

Re: Export/Import ODBC Settings

copied/exported ODBC reg keys and imported on another pc.

7

Re: Export/Import ODBC Settings

…and another one:

How do I import my old ODBC settings?

8

Re: Export/Import ODBC Settings

tried this too…same error

9

Re: Export/Import ODBC Settings

which OS is this?

10

Re: Export/Import ODBC Settings

same thing

11

Re: Export/Import ODBC Settings

exporting from XP to Win7

12

Re: Export/Import ODBC Settings

Any difference between 64 and 32 bit?

13

Re: Export/Import ODBC Settings

i am using ODBC(32).exe on win7
looks like i have to manually add all the drivers and bs:what:

14

Re: Export/Import ODBC Settings

but is the OS 32 or 64?

15

Re: Export/Import ODBC Settings

ohh
its 64bit

16

Re: Export/Import ODBC Settings

that could be the issue.

You can export ODBC setting from registry and restore it on other machine. Don’t know if there is script that can do it, but it should be easy. Be aware, because more and more Windows machines are 64 bit versions and there registry location differs for 32 and 64 bit applications. Have a look at: http://serverfault.com/questions/239002/registry-for-odbcad32-on-window-server-2003-64-bit/240112#240112

Reference: vbscript - ODBC Connection Information Export script from Windows XP to Windows 7? - Stack Overflow

17

Re: Export/Import ODBC Settings

I compared the entries on 32 and 64 bit os. I am copying the correct keys.
ohh wait.... can it be bitlocker?

18

Re: Export/Import ODBC Settings

Could be. Also, could be the ODBC files located in the Program Files (x86)

19

Re: Export/Import ODBC Settings

I copied everything from common files under x86.
All the imported entries are imported in to right container. I can see them in reg editor in correct folders.