The Excel SQL Connector Application is a VBA-based application that allows you to connect an Excel file to a Microsoft SQL Server and manipulate the data using a user-friendly form.

This project is a Data Access layer that can be used in any VBA application to connect to SQL Server. The purpose is to keep database connectivity tidy and core database commands centralized within a ...

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.

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 ...