When trying to run the VB program through the VB IDE, I get the following error message "ODBC Connection to SQL Server could not be created. Please contact your database administrator.
Also, when attempting to compile the program, I get "Compile error: Permission denied". Its probably related to the above problem.
Yes, my data source information is correct, and I have the latest drivers for SQL Server. If I test the data source, it completes successfully.