Moving ODBC Connections From Windows Server 2003 32bit to Windows Server 2008 64bit
Share
While trying to upgrade from EnterpriseOne 8.11 SP1 to EnterpriseOne 9.0, we also wanted to upgrade our Deployment server to Windows Sever 2008 64bit. So, that means that in order to runt he upgrade UBEs we needed to get the ODBC Connections onto the new server. So, I exported the desired ODBC connections from the Windows Registry [HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI]. Then modified the file using a text editor so that when we imported them into our new 64bit server the ODBC Connections would be loaded into the 32bit ODBC Connection Manager.
[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INISystem – 811] was changed to [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INISystem – 811]
The 32bit ODBC Connections can be managed using the ODBC Connection Manager that is found at C:WindowsSysWOW64odbcad32.exe
I also had to change the Driver specified for each entry:
"Driver"="C:\WINDOWS\system32\cwbodbc.dll" changed to "Driver"="C:\Windows\SysWOW64\cwbodbc.dll"
Author
Stewart Schatz
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
Average Rating