ODBC Connection Fix

This article will walk you through how to resolve an ODBC connection error such as: "ODBC--connection to (database name) failed."

Add ODBC Data Source

1. Click Start button
2. Type ODBC into search box (if you do not see a search box, just start typing ODBC)
3. Click on ODBC Data Sources. If you see "Data Sources (ODBC)", choose the 32-bit option
   
   
   
4. Click Add on the right side
   
   
   
5. Choose SQL Server (may need to scroll down) then click Finish
   
   
   
6. Enter in the following information: