I am having trouble connecting to a sql database.
I have vb.net and it came with vs 03. I have doen a varity of simple programs with vb. I have recently added a server with sql 08 and connected with a workgroup.
When I use vs to put a sql connection into a form a prompt comes up for the connection. I enter the server, username, password and database. I click on the test connection button and get the message "Test Connection Succeeded". However, when I click on the 'OK' button I get the message "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio."