Sign In
MSDN Blogs
Microsoft Blog Images
More ...
December, 2008
Common Tasks
Blog Home
About
RSS for comments
RSS for posts
Atom
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Recent Posts
(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
Posted
over 4 years ago
by
Michael Aspengren - MSFT
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
Create a LINQ/WCF/Silverlight application in 10 simple steps.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
What version of a particular dll is my application running? Find out using code.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
The importance of selecting the correct Sql provider for the job. Sqlncli vs. Sqlncli10
Posted
over 4 years ago
by
Michael Aspengren - MSFT
Blogs I read
Fabulous Adventures In Coding
If broken it is, fix it you should
SQL in Stockholm
SQL Protocols
Tags
Access
ADO
ADO.Net
BID
CLR
Data Provider
Data Reader
Exception
Linked Server
LINQ to SQL
Login
ODBC
OleDb
Oracle
OracleClient
Remote Debugging
sqlcmd
SqlException
sqlncli
TCP
Timeout
t-sql
WCF
Windbg
Xml
Archives
Archives
February 2012
(1)
January 2012
(2)
December 2011
(1)
November 2011
(1)
October 2011
(3)
June 2011
(2)
May 2011
(1)
March 2011
(2)
February 2011
(1)
January 2011
(1)
December 2010
(2)
November 2010
(2)
October 2010
(2)
June 2010
(1)
May 2010
(3)
April 2010
(2)
March 2010
(4)
February 2010
(3)
January 2010
(4)
December 2009
(6)
November 2009
(3)
October 2009
(4)
September 2009
(7)
August 2009
(4)
July 2009
(3)
June 2009
(2)
May 2009
(3)
April 2009
(3)
March 2009
(4)
February 2009
(4)
January 2009
(2)
December 2008
(6)
November 2008
(3)
October 2008
(3)
September 2008
(6)
August 2008
(3)
July 2008
(9)
December, 2008
Common tips and tricks from a SQL Developer Support perspective
While some cases may start of as complex, they sometimes turn out to be caused by something not that complex. As the case always is once you have the solution. So I thought I would share some of the things that I've come across, and hopefully tha
RSS for posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Common tips and tricks from a SQL Developer Support perspective
(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
Posted
over 4 years ago
by
Michael Aspengren - MSFT
1
Comments
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: -------------------------------------------------------------...
Common tips and tricks from a SQL Developer Support perspective
Unable to find the requested .Net Framework Data Provider. It may not be installed.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
1
Comments
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...
Common tips and tricks from a SQL Developer Support perspective
Create a LINQ/WCF/Silverlight application in 10 simple steps.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
1
Comments
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. ...
Common tips and tricks from a SQL Developer Support perspective
What version of a particular dll is my application running? Find out using code.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
0
Comments
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...
Common tips and tricks from a SQL Developer Support perspective
The importance of selecting the correct Sql provider for the job. Sqlncli vs. Sqlncli10
Posted
over 4 years ago
by
Michael Aspengren - MSFT
1
Comments
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...
Common tips and tricks from a SQL Developer Support perspective
SMO Transfer.TransferData() gives: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
Posted
over 4 years ago
by
Michael Aspengren - MSFT
0
Comments
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...
Page 1 of 1 (6 items)
MSDN Blogs
>
Common tips and tricks from a SQL Developer Support perspective
>
December, 2008