Creating ODBC Connections on Windows
Thanks to: http://help.bluemangolearning.com/ Launch the Administrative Tools Application From the Control Panel, launch Administrative Tools . Important Note: If you are running a 64-bit version of Windows you need to open the 32-bit version of the ODBC Administrator which you can find here: c:\windows\sysWOW64\odbcad32.exe For more information you may refer to this article on the Microsoft website: http://msdn.microsoft.com/en-us/library/ms712362(VS.85).aspx Open Data Sources (ODBC) Within the Administrative Tools folder you will find a shortcut to Data Sources (ODBC) . Launch this application. Install a System DSN 1) After the application finishes launching click on the System DSN tab. You can install a DSN that is available to any user that logs into the computer from here. 2) Click on the Add button. Select SQL Server Native Client Driver If you are using SQL Server 2008 or later than select the SQL Server Na