Connection string: Difference between revisions
No edit summary |
Ohnoitsjamie (talk | contribs) spam |
||
| Line 1: | Line 1: | ||
In computing, a '''connection string''' is a [[String (computer science)|string]] that specifies information about a data source and the means of connecting to it. It is passed in code to an underlying [[software driver|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. |
In computing, a '''connection string''' is a [[String (computer science)|string]] that specifies information about a data source and the means of connecting to it. It is passed in code to an underlying [[software driver|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 (computing)|server]] and [[database]], as well as security information such as user name and password. The formating rules for connection strings are shown at |
The connection string may include attributes such as the name of the driver, [[server (computing)|server]] and [[database]], as well as security information such as user name and password. The formating rules for connection strings are shown at |
||
==Example== |
==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.<br /> |
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.<br /> |
||
| Line 10: | Line 9: | ||
</blockquote> |
</blockquote> |
||
More examples of connection strings are available at <ref>[http://www.sqlmaestro.com/resources/all/anysql_maestro_connection_strings/ http://www.sqlmaestro.com]</ref> and |
|||
<ref>[http://www.connectionstringexamples.com/ http://www.connectionstringexamples.com/]</ref>. |
|||
==References== |
==References== |
||
{{reflist}} |
{{reflist}} |
||
* [http://www.datadirect.com/developer/odbc/definitions/index.ssp Connection String definition at datadirect.com] |
|||
Revision as of 13:54, 11 September 2009
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 formating rules for connection strings are shown at
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
 | This computer science article is a stub. You can help Wikipedia by expanding it. |