Just define your DSN source in your VB code and create an ODBC source with the same name for SQL Server. It's really easy stuff. VB will even create the DSN connection string for you.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

Excel VBA Custom SQL Query Tool Part One) This simple Excel query tool was designed using Excel VBA macros, shapes, Active X Controls, and SQL query code. It queries an Azure SQL server database using ...

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 database setup information, so you can open a connection to ...

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

Now let's write a simple AutoCAD plugin to connect to SQL Server and query data. Setup Database Let's write a Database Manager class to access the `connectionstring`, test the connection, and query ...