<div>
Does this mean that you had SP 1 Beta and updated to SP 1 and it worked?<br />

</div>


Does this mean that you had SP 1 Beta and updated to SP 1 and it worked?


<div>
I had SP1 installed. &nbsp;I uninstalled it and reinstalled it and got the LINQ connection to work. &nbsp;I don't know what the problem was but that solved it.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I am trying to use Linq to SQL in a VS 2008 app in c#. &nbsp;I have created a DBML file in my project. &nbsp;I go into the Server Explorer and try to connect to my database using &quot;Microsoft SQL Server (SqlClient)&quot; as my data source and &quot;.Net Framework Data Provider for SQL Server&quot; as my data provider. &nbsp;Then I choose the server and database. &nbsp;I use Windows Authentication which works in Management Studio. &nbsp;I test the connection and it works but when I click OK to establish the conntection I get an error. &nbsp;A screen print is in the attached file.<br />
<br />
Then my boss tried to connect using &quot;.Net Framework Data Provider for OLE DB&quot; for my data provider. &nbsp;I did that and was able to connect to the database. &nbsp;But when I tried to drag and drop a table from the database onto the DBML Designer, I got another error. &nbsp;It is also included in the attached file.<br />
<br />
Can you help me?<br />
<br />
Thanks.<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/10_w42/68241/Connection-errors-using-Linq.doc" target="_blank" class="file-inline" title="Connection errors described above (42 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Connection-errors-using-Linq.doc</a>
</div>
</div>


Connection-errors-using-Linq.doc

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.

Linq to SQL connection error

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

.NET application servers, a Windows Server role in an application role, includes Internet Information Services (IIS) to provide web server support, the .NET Framework to provide application support, ASP.NET to provide server side scripting, COM+ for application component communication, Message Queuing for multithreaded processing, and the Windows Communication Foundation (WCF) for application communication. There are also third party server systems that provide .NET support, including Mono, Base4, TNAPS and cc Devnet Data Access Server.