I am trying to use Linq to SQL in a VS 2008 app in c#. I have created a DBML file in my project. I go into the Server Explorer and try to connect to my database using "Microsoft SQL Server (SqlClient)" as my data source and ".Net Framework Data Provider for SQL Server" as my data provider. Then I choose the server and database. I use Windows Authentication which works in Management Studio. I test the connection and it works but when I click OK to establish the conntection I get an error. A screen print is in the attached file.
Then my boss tried to connect using ".Net Framework Data Provider for OLE DB" for my data provider. I did that and was able to connect to the database. But when I tried to drag and drop a table from the database onto the DBML Designer, I got another error. It is also included in the attached file.
Can you help me?