Posted on: 3/9/2015 9:04:45 PM | Views : 634

I have a VB program that I'm trying to connect to an SQL database. First on the ODBC system DSN I don't know which driver to use, SQL native client or SQL server. On the new data source I know the name of the data source but which server to connect to is a problem because if I drop down the list is empty. Do I use windows  authentication or SQL server authentication. When I run the connection test, it fails. All the connection code is already in the program the only problem is at the ODBC. Where I'm I going wrong. Please help.

Go to the complete details ...