Articles of level

A connection string provides the information that a provider needs to communicate with a particular database. The Connection String includes parameters such as the name of the driver, Server name and Database name , as well as security information such as user name and password.
An ADO.NET Data Provider is a class that can communicate with a specific type of database or data store. Usually Data Providers use a connection string containing a collection of parameters to establish the connection with the database through applications. The .NET Framework provides mainly three data providers, they are-

  • OLEDB
  • ODBC

From the following section you can find different types of providers and its connection strings in detail.

Setup SQL Server Alerts to notify SQL Server Agent Operators on a failure condition.
Include RAISERROR or TRY/CATCH logic in your backup or restore code to send an email on a failure condition.

Need Help? Contact Us.

Log in

*
*

Forgot password?

*

New User

*
*
*
*