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.