Solo programación

Como primer articulo para esta categoria, voy a mencionar los Connections String que se deben utilizar para conectar a bases de datos, esto hasta donde conozco yo, se utiliza en Visual Basic y todas las herramientas de .NET.

Debo mencionar que esta información se encuentra en Connections Strings con más detalle, yo me limitaré a mostrar las conecciones tipicas.

---

SQL Server

ODBC

Standard Security

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Trusted connection

Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;

OLE DB, OleDbConnection (.NET)

Standard Security

Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Trusted connection

Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

SqlConnection (.NET)

Standard Security

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Trusted Connection

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

---

Access 2007

ACE OLEDB 12.0

Standard security

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

---

Sybase

ODBC

Standard Sybase System 12 Enterprise Open Client
Driver={SYBASE ASE ODBC Driver};Srvr=myServerAddress;Uid=myUsername;Pwd=myPassword;

Standard Sybase System 11
Driver={SYBASE SYSTEM 11};Srvr=myServerAddress;Uid=myUsername;Pwd=myPassword;Database=myDataBase;

AseConnection (.NET)

Standard
Data Source='myASEserver';Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

---

DBF / FoxPro

ODBC

Standard
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;

OLE DB, OleDbConnection (.NET)
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=;

Tags: coneccion base datos