This post gives the exact description of how to connect database to ODBC. Each step is explained in detail with screenshot so you can easily follow them while connecting database to ODBC.The information on this blog is very useful.