Just have a small incident at a customer.
The customer was using an 32 bit application called Microsoft XAL which I have installed on a Windows 2008 x64 bit server TS Server.
The application uses a SQL database which is located on a remote server.
The program is connecting to the SQL server with an ODBC system DSN.
When I created and tested the System DSN on the server, then it connected to the SQL Server just fine, but the application couldn’t connect to the server.
After some time I found in the x64 bit version of Windows 2008 and Vista there is a 32bit ODBC Data Source Administrator which is I located in %systemroot%sysWOW64 and is called odbcad32.exe.When you run this version instead of the one from Administrative tools the you can create a 32 bit DSN which can be used by 32 bit programs.
Wow…talk about luck. I have the same situation. You just saved me a couple hours. Thanks!
yeah man thanks for the post vSphere vCenter requires 32bit DSN
Thank you !!
Also saved me a couple of hours
Great job… i have lost 2 hours…. but you saved me a lot more…
Thanx man! This was exaktly what i was looking for!
/Johan Ekman
Great post. Solved my problem. Thanks.
Thanks, installing a Vertical market ODBC driven application on 64 bit Server 2008, you saved me time! Thanks
Thanks, this helped out a lot. Can't believe MS didn't either have a link to this in the control panel or at least name the one that's in there so it's obvious that it's for 64bit connections.
This was perfect. Thanks a lot.
Thank you, very much. Saved my day.
bless you! i worked a day or two on this issue with our citrix server – grrr… all fixed now thanks to you
Great post!!! thanks a lot
After banging my head on permissions this came in handy. Thanks.
Man, you got it. Save my day too, thanks
THANK YOU!!! i am building a server that uses a piece of middleware published by Sybase. it requires an ODBC connection to a tiny ACCESS database for initial bootup, to reconfigure it to a SQL server. Without this tidbit i would not have been able to complete my install. Jennifer
Just thank you ! Useful tip !
Thank you for this great post. Also saved me couple hours!
Thank you very much for this post! I couldn't figure this out for hours and then I ran upon this one. Thanks! It worked great!
Thanks a lot .. you saved me a lot of grief
nice post! thanks a lot!
thank you
Your welcome. I’m just glad to help
Anyone configured an ODBC connection via a proxy? I have to set this up and I’m not sure how
Thanks a lot! This saved me a lot of time. Had to connect out of an Excel workbook via ODBC that worked on the previous (32bit) server but not on the new (64bit) one.
Generally I am selfish and just use internet to get my issues fixed, but guys THANKS…. for helping me fix my ODBC issue and also changing my mindset.
Thanks
Ranjan