(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: ———————————————————————————————————————————————————— System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify…

1

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)”   http://msdn.microsoft.com/en-us/library/bb677335.aspx “SQL Server 2008 Books Online (October 2008) – datetime (Transact-SQL)”  …

1

Failed to find or load the registered .Net Framework Data Provider

When using a 3rd party .Net data provider. Or when you dynamically load a .Net provider you may get the following error:   Failed to find or load the registered .Net Framework Data Provider   There does not seem to be that much information about this and this post is not intended to resolveall possible…

1