[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Linq to SQL connection error

Hello Experts,

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?

Thanks.
Connection-errors-using-Linq.doc
0
sschuman220
Asked:
sschuman220
  • 2
1 Solution
 
Fernando SotoCommented:
Hi sschuman220;

The Linq to SQL is supported using Microsoft SQL Server or Microsoft SQL Server Express using the "Microsoft SQL Server (SqlClient)" as the Data Source and ".Net Framework Data Provider for SQL Server" as the Data Provider and is not supported on the ".Net Framework Data Provider for OLE DB" Data Provider.

Are you using VS 2008 with SP 1 Beta?

I am using VS .Net 2008 with SP 1 and have had no issues like you are having but I have heard that with SP 1 Beta installed but do not know if updateing to SP 1 full release will fix it.

Fernando
0
 
Fernando SotoCommented:
Does this mean that you had SP 1 Beta and updated to SP 1 and it worked?
0
 
sschuman220Author Commented:
I had SP1 installed.  I uninstalled it and reinstalled it and got the LINQ connection to work.  I don't know what the problem was but that solved it.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now