How to easily connect and query your SQL Server Data through ODBC


Editor: Thanks for this. It’s not bad, but what it’s lacking is showing how to use ODBC from any application or while coding. This appears to just show testing, and there doesn’t seem to be a lot of DSNs in use these days. Without showing some reaosn why this is better than just having a connection string, or how this gets set up for users, it’s not useful. ODBC is built into most desktops, so the install is less relevant or useful. What I’d like to see is less an explanation of what this is or the install, but why