How to Establish an ODBC Connection to the SQL Database. Windows 7 includes an ODBC manager that lets you connect from your desktop to a SQL server. You create a data source name (DSN) to save ...

Increase your application's flexibility and make the installation simpler by connecting to the database without generating a DSN in the ODBC Data Source Administrator. Instead, use VB code to ...

Tom Fenton shows you two ways to overcome the gotchas when setting up an ODBC connection to a remote database.

What I think I need to do is create an ODBC connection between a computer that has the Access file and the computer running the SQL Server.