Tuesday, November 16, 2010

Bits of ODBC advice for vCenter Update Manager

VMware vCenter Update Manager is a 32-bit application. If you install VUM on a 64-bit OS (ie. Windows Server 2008 R2) you’ll need to use the 32-bit ODBC Data Source Administrator tool to create the database connection. If you use the 64-bit tool, you will receive the following error message.

The DSN, ‘VUM’ does not exist or is not a 32 bit system DSN. Update Manager requires a 32 bit system DSN.(where VUM is the name of your ODBC connection)

Cause: Using the ODBC tool in the Control Panel will create a 64-bit DSN. You need to use the 32-bit ODBC tool which is located at C:\Windows\SysWOW64\odbcad32.exe. Do NOT use the odbcad32.exe located in the C:\Windows\System32 folder. While it has the same file name, they are two different files.