Solved

Linq to SQL connection error

Posted on 2008-10-14
3
372 Views
Last Modified: 2013-12-17
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
Comment
Question by:sschuman220
  • 2
3 Comments
 
LVL 63

Accepted Solution

by:
Fernando Soto earned 500 total points
ID: 22713540
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
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 22713986
Does this mean that you had SP 1 Beta and updated to SP 1 and it worked?
0
 

Author Comment

by:sschuman220
ID: 22720364
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question