Welcome to MSDN Blogs Sign in | Join | Help

December 2008 - Posts

Friday, December 19, 2008 3:15 PM

(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

The scenario: You try to connect to Sql Server but you are getting the following connection error (they vary depending on the provider used): Using the .Net SqlClient provider: ------------------------------------------------------------------------------------------------------------------------------------------------------------
Posted by maspeng | 1 Comments
Friday, December 19, 2008 3:14 PM

Unable to find the requested .Net Framework Data Provider. It may not be installed.

From .Net 2.0 there is an option for you to obtain your dataprovider (usually if using 3 rd party providers) by using the DbProviderFactories/ DbProviderFactory classes . A simple example: string provider = "System.Data.SqlClient" ; DbProviderFactory
Posted by maspeng | 1 Comments
Filed under:
Thursday, December 18, 2008 3:40 PM

Create a LINQ/WCF/Silverlight application in 10 simple steps.

Ok, today I will show how to create a super simple application that uses some of the new stuff you find in .Net 3.5. Try this and then you can throw cool words like Windows Communication Foundation (WCF), LINQ to SQL and Silverlight around you. This is
Posted by maspeng | 1 Comments
Filed under: , ,
Friday, December 12, 2008 2:53 PM

What version of a particular dll is my application running? Find out using code.

Sometimes you may wish to find out what versions of particular dlls’ your application is using. If running on your dev machine it is not hard. But what if you have an application that is to be deployed to hundreds of users? Well, the easiest thing is
Posted by maspeng | 0 Comments
Monday, December 08, 2008 10:00 AM

The importance of selecting the correct Sql provider for the job. Sqlncli vs. Sqlncli10

Imagine this; you have been looking at the new data type DateTime2 in Sql Server 2008 because you have a need for the increased precision this data type offers. Comparison here: "SQL Server 2008 Books Online (October 2008) - datetime2 (Transact-SQL)"
Posted by maspeng | 1 Comments
Thursday, December 04, 2008 2:50 PM

SMO Transfer.TransferData() gives: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Today’s post will deal with something that I do not usually deal with, and that is SMO (Sql Server Management Objects). The reason is that I helped a colleague the other day, and I was a bit confused to start with in regard to why the aptly named method
Posted by maspeng | 0 Comments
 
Page view tracker