oledb para la cadena de conexión del servidor sql ejemplo de código c #

Ejemplo 1: cadena de conexión del servidor SQL

Standard Security
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connection to a SQL Server instance
The server/instance name syntax used in the server option is the same for all SQL Server connection strings.
Server=myServerNamemyInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

Using a non-standard port
If your SQL Server listens on a non-default port you can specify that using the servername,xxxx syntax (note the comma, it's not a colon).
Server=myServerName,myPortNumber;Database=myDataBase;User Id=myUsername;Password=myPassword;
The default SQL Server port is 1433 and there is no need to specify that in the connection string.

Ejemplo 2: cadena de conexión del nombre del proveedor del servidor SQL

providerName="System.Data.SqlClient"

---

---

Utiliza Nuestro Buscador