Connection String
0/5 (0 vote)
The connection string specifies information about how to initialize a connection to a data store.It contains keyword/value pairs. the first pair is
The connection string specifies information about how to initialize a connection to a data store.
It contains keyword/value pairs. the first pair is always the Provider or Driver. The following pairs will correspond with the data required to initialize the provide / driver.
Some Example Keywords:
SQL ODBC: Server, Database, Uid (user), Pwd (password), Trusted_Connection, MARS_Connection (multiple active record sets), Encrypt, AttachDbFilename,
SQLOLEDB: Data Source, Initial Catalog (database to connect to), UserId, Password, Integrated Security, Failover Partner (for mirroring).
Some example connection strings:
SqlConnection (.NET) standard Security:
"Data Source=ServerAddress;Initial Catalog=DataBase;User Id=username;Password=password;"
ODBC - PostgreSQL driver:
"Driver={PostgreSQL};Server=IP address;Port=5432;Database=DataBase;Uid=username;Pwd=password;"
More example connection string:
http://www.connectionstrings.com/