Creating a 64bit DSN for vCenter Server
NOTE: (as per vmware administrative guide)
It’s important to understand which kind of DSN you have. On an x64 system, you can create an ODBC connection(DSN) on the 32-bit side of the system or on the 64-bit side of the system. 32-bit applications will only see ODBC connections created in the 32-bit side, and 64-bits applications will only see ODBC connections from the 64-bit side. Each kind of application has is own registry. To setup DSN for 32-bit application you must use: %WINDIR%\SysWOW64\odbcad32.exe and for 64-bit application you must use: %WINDIR%\System32\odbcad32.exe
The vCenter Server system must have a 64-bit DSN. This requirement applies to all supported databases.
Note: Update Manager still requires the use of a 32-bit DSN. For more information on creating the DSN, see Minimum requirements for installing Update Manager 5.0 (2005084).
To create a 64-bit DSN for vCenter Server:
- Select Control Panel > Administrative Tools > Data Sources (ODBC).
- If you do not see SQL Server Native Client 10.0 in the above windows, download the sqlcli.msi package from the Microsoft website located here (Microsoft® SQL Server® 2008 R2 Feature Pack).
- Use the application to create a system DSN and choose the appropriate driver according to the requirements by the database vendor.
Note: For example, if you have a Microsoft SQL database, create the system DSN for the SQL Native Client driver.
- Test the connectivity.