Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Data Provider   (RSS)
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
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
Friday, November 14, 2008 3:08 PM

Connectionstrings, mixing usernames and windows authentication. Who goes first?

When connecting to Sql Server from .Net, there are three namespaces containing classes to do so: System.Data.SqlClient / System.Data.OleDb / System.Data.Odbc The one should use is System.Data.SqlClient since this contains functions specific to Sql Server,
Posted by maspeng | 1 Comments
Filed under: , , ,
Friday, July 18, 2008 4:13 PM

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
Posted by maspeng | 1 Comments
Filed under:
 
Page view tracker