La conexiones que les voy a mostrar son en dos lenguajes ASP y .NET, bajo una Base de datos “BBDD” Sql Server, eso si da lo mismo que a un SQL Server 2000 ó superior.
Standard Security:
“Driver=SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;”
Trusted connection:
“Driver=SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;”
SQL OLE DB connection strings
Standard Security:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;”
Trusted connection:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;”
SQL OleDbConnection .NET strings
Standard Security:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;”
Trusted connection:
“Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;”
SQL SqlConnection .NET strings
Standard Security:
1. “Data Source=Your_Server_Name;Initial Catalog= Your_Database_Name;UserId=Your_Username;Password=Your_Password;”
2. “Server=Your_Server_Name;Database=Your_Database_Name;UserID=Your_Username;
Password=Your_Password;Trusted_Connection=False”
Trusted connection:
1. “Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;Integrated Security=SSPI;”
2. “Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=True;”
Hola que tal muy buen blog
Chido todo lo de .net
resolvi dudas…jeje
Muy util, me ha salvado la vida.