Moving ODBC Connections From Windows Server 2003 32bit to Windows Server 2008 64bit

Read Time:48 Sec

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

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Trigger Library JDBTRG1 or JDBTRIG Not Found
Next post Package Build Error on Business Services