A simple example on how to get Return and Out parameter values using Ado.Net

Another short one.   How to capture OUT and RETURN parameter values from a stored procedure in .Net.   Well, I’ll let the example speak for itself.   First create a stored procedure, this just take an in parameter and an out parameter, it declares a local variable that will be used as the return…

2

(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

Command prompt utilities, some resources in one place.

Sometimes there is some confusion on the different Command Prompt utilities.   I will not go into detail on this, rather providing a collection of the online resources.   The short summary is this: –          ISQL is no longer supported, use SQLCMD –          ISQL uses DB-LIB (6.5 client level), some SQL 2000 features are not…

0