Connection string: Difference between revisions
Content deleted Content added
ClueBot NG (talk | contribs) m Reverting possible vandalism by 202.124.151.123 to version by ZéroBot. False positive? Report it. Thanks, ClueBot NG. (1511796) (Bot) |
Tag: section blanking |
||
| Line 2: | Line 2: | ||
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 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. |
||
==Examples== |
|||
This example shows a [[Postgres]] connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds: |
|||
<blockquote> |
|||
DRIVER={PostgreSQL Unicode};SERVER=www.wikipedia.com;SSL=true;SSLMode=require;DATABASE=wiki;UID=wikiuser;Connect Timeout=180;PWD=ashiknoor |
|||
</blockquote> |
|||
Users of [[Oracle database]]s can specify connection strings: |
|||
* on the [[command-line]] (as in: <code>sqlplus scott/tiger@connection_string</code> ) |
|||
* via [[environment variable]]s (<code>$TWO_TASK</code> in Unix-like environments; <code>%LOCAL%</code> in Microsoft Windows environments)<ref> |
|||
{{cite web |
|||
| url = http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref360 |
|||
| title = Configuring SQL*Plus |
|||
| first = Simon |
|||
| last = Watt |
|||
| coauthors = ''et al.'' |
|||
| month = June |
|||
| year = 2005 |
|||
| work = SQL*Plus User's Guide and Reference: Release 10.2 |
|||
| publisher = [[Oracle Corporation]] |
|||
| location = Redwood City |
|||
| accessdate = 2010-08-26 |
|||
| quote = LOCAL [:] Windows environment variable to specify a connection string. Performs the same function as TWO_TASK on UNIX. |
|||
}} |
|||
</ref> |
|||
* in local [[configuration file]]s (such as the default <code>$ORACLE_HOME/network/admin.tnsnames.ora</code>)<ref> |
|||
{{cite book |
|||
|last= Kyte |
|||
|first= Thomas |
|||
|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions |
|||
|url= http://books.google.com/books?id=TmPoYfpeJAUC |
|||
|accessdate= 2010-08-26 |
|||
|series= Apress series |
|||
|year= 2005 |
|||
|publisher= Apress |
|||
|isbn= 978-1-59059-530-5 |
|||
|page= 60 |
|||
|pages= 724 |
|||
|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file calles <code>tnsnames.ora</code>. This is a plaint-text configuration file commonly found in the [ORACLE_HOME]\network\admin directory ([ORACLE_HOME] represents the full path to your Oracle installation directory). |
|||
}} |
|||
</ref> |
|||
* in [[LDAP]]-capable [[directory service]]s |
|||
==External links== |
==External links== |
||
Revision as of 01:17, 18 February 2013
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.
External links
References
 | This computer science article is a stub. You can help Wikipedia by expanding it. |