Jump to content

Connection string

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 38.105.120.70 (talk) at 19:24, 5 November 2009. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

In computing, a connection string is a string that specifies information about a data source and the means of connecting to it. It is passed in code to an underlying driver or provider in order to initiate the connection. Whilst commonly used for a database connection, the data source could also be a spreadsheet or text file.

The connection string may include attributes such as the name of the driver, server and database, as well as security information such as user name and password. The formatting rules for connection strings are shown at WHERE IS IT?!?!?!

Example

This is a example of a Postgres Connection string that will try to connect to wikipedia.com with SSL and a Connection timeout of 180 sec.

DRIVER={PostgreSQL Unicode};SERVER=www.wikpedia.com;SSL=true;SSLMode=require;DATABASE=wiki;UID=wikiuser;Connect Timeout=180;PWD=ashiknoor


References