How to Create ODBC Data Source for 32bit Application to be run at Windows 2003 64bit

If you are running application that built by Visual Basic (vb6) and it needs connection to the SQL Server 2005, you cannot at ODBC Data Source from default Data Source Administrator at Control Panel -> Administrative Task. You must know that application build by vb6 is the 32bit application, so you cannot connect your SQL server database with the default ODBC Administrator in Windows 2003 64bit. You need to run the ODBC administrator for 32bit application. Windows 2003 64bit itself, has the 32bit ODBC Administrator. You can run it from the following file : C:\WINDOWS\SysWOW64\odbcad32.exe. The rest setup process is remain same as usual.