vCenter Server Installation: Creating a 64bit DSN for vCenter Server

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:
  1. Select Control Panel > Administrative Tools > Data Sources (ODBC).
 Image
  1. 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).
  2. 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.
 Image
  1. Test the connectivity.
 Image
 
Advertisements

About cloudray

Predominantly based around Virtualization, but will include other technology related information and anything else I find interesting and feel the need to share with you. I also use this Blog as both a place to store useful information that I think that will come in handy to me at some point in the future, and also a place to help aid my learning. I find a great way to learn about something is to research about it and then write it up in my own words. I'm Pushpal Ray, from India. As a certified VCP3/4/5 professional, I am currently working as an Independent Consultant. Over 10 years of IT-industry experience, currently focused around the Desktop Virtualization(End-User Computing). I also have extensive experience in Windows Administration, Datacenter Migration, Workload profiling & benchmarking. At my leisure, I enjoy hiking, running, photography, spend hours in my fav coffee shop & spend quality time with my wife. Occasionally, catch up with few friends for a drink!
This entry was posted in Enterprise Virtualization, vSphere and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s