Connection string
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.
Examples
This example shows a PostgreSQL connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds:
DRIVER={PostgreSQL Unicode};SERVER=www.wikipedia.com;SSL=true;SSLMode=require;DATABASE=wiki;UID=wikiuser;Connect Timeout=180;PWD=ashiknoor
Users of Oracle databases can specify connection strings:
- on the command line (as in:
sqlplus scott/tiger@connection_string) - via environment variables (
$TWO_TASKin Unix-like environments;%TWO_TASK%in Microsoft Windows environments)[1] - in local configuration files (such as the default
$ORACLE_HOME/network/admin.tnsnames.ora)[2] - in LDAP-capable directory services
See also
References
- ^
Watt, Simon; et al. (June 2005). "Configuring SQL*Plus". SQL*Plus User's Guide and Reference: Release 10.2. Redwood City: Oracle Corporation. Retrieved 26 August 2010.
LOCAL [:] Windows environment variable to specify a connection string. Performs the same function as TWO_TASK on UNIX.
- ^
Kyte, Thomas (2005). Expert Oracle database architecture: 9i and 10g programming techniques and solutions. Apress series. Apress. p. 60. ISBN 978-1-59059-530-5. Retrieved 26 August 2010.
The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called
tnsnames.ora. 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).
External links
- "Connection strings in SQL Server 2017". Retrieved 15 June 2019.
 | This computer science article is a stub. You can help Wikipedia by adding missing information. |
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.