A. Mikkelsen VMware ESX scripts, commands, tools and other nice to know things that will make your virtualization days easier!!!!

Tuesday, September 29, 2009

32-bit ODBC DSN required for vSphere running on 64-bit OS and MSSQL

Filed under: Errors,Microsoft,Troubleshooting,Virtual Center — Tags: , , , , , , — A. Mikkelsen @ 10:33 am

Last week I upgraded a Virtual Center server from Win2003 & MSSQL 2000 (32-bit) to Win2008 & MSSQL 2005 (64-bit).

During the installation of vCenter it asked for a 32-bit ODBC even though all the new systems was running 64-bit.
After a some time on Google i found that Windows 64-bit also includes a 32-bit version of the ODBC.

To set up a 32-bit DSN launch the 32-bit version of the Data Source Administrator. It is located at:
%systemdrive%\Windows\SysWoW64\Odbcad32.exe

Also se
http://www.vmwarewolf.com/32-bit-odbc-dsn-for-vsphere/

2 Comments »

  1. Your five sentence post just saved me the trouble of having to rebuild my 64-bit sever as a 32-bit OS just to support vCenter. Thanks!

    Comment by Todd — Tuesday, November 10, 2009 @ 19:16 pm

  2. Always glad to help.

    Comment by A. Mikkelsen — Wednesday, November 11, 2009 @ 7:48 am

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress