Hello
While the installation of View Composer 2 (Build 210930) I get the error "The database cannot be found or a connection cannot be established. Check the DSN name to ensure that it is correctly entered."
This error was on a Windows Server 2008 SP2 x64 Englisch and on a Windows Server 2008 R2 x64 German (this one is not supported, just for sandbox).
After some troubleshooting I found out, that if you use the "ODBC DSN Setup..." Button on a x64 system, the setup opened the WOW ODBC Administration (used for x32 compatibilty). View Composer seems to use the x64 odbc connection. So you just have to use the normal odbc administration interface to setup the odbc connection and the setup will run without any problem!
Hope this helps someone!
Greetings
Thanks! I had the same issue until I read this.
My vCenter is on Windows 2003 Standard x64 and View Composer DB created on MS SQL 2008 Enterprise x64 on Windows 2008 R2 Enterprise.
I love this community. This solved my issue immediately.
Windows Standard 2008 x64
SQL Standard 2008 x64
Charles Killmer, VCP4
If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
Hi,
As VMware offered installation of vCenter 4 on Windows x64, i've installed vCenter 4 on Windows 2003 Enterprise x64 SP2.
But now I have the same problem when I want to setup Composer 2.I've tried this way but cannot continue and still setup can't find the database.
It's very worth situation that vmware created, which support x64 windows server for vcenter but bot for composer.
Any suggestion?
Hi tavakkoli
Can you give some aditional informations about your Database (SQL Express/Std, local/remote)?!
Does the ODBC Check work?
Hi vBaw
I'm using Microsoft SQL 2005 Enterprise on remote server and used the DB server for vCenter 4 installation before. I've created ODBC connection the way exactly as I did it for vCenter 4. As you know on VMware documentation for installing vCenter 4 describes how to create ODBC connection on 64-bit operating systems by using %windir%\SysWOW64\odbcad32.exe like what you said on this topic.
And about ODBC Connection working. I have to say, yes. As I said ODBC connection for vCenter 4 on this server created before and it's working now.
Thanks for you attention.
Please Help!
Hi,
Thank you! This does the trick!
vCenter on windows 2003 SP2 64bits
SQL express
Chakrit