Connection string

<h2 id="examples">Examples</h2>
<p>This example shows a <a href="/facts/Postgres/LHdXuHfl">Postgres</a> connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds:
</p>

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

<p>Users of <a href="/facts/Oracle_database/FHv5g732">Oracle databases</a> can specify connection strings:
</p>
<ul><li>on the <a href="/facts/Command_line/R9JpGmXQ">command line</a> (as in: sqlplus scott/tiger@connection_string )</li>
<li>via <a href="/facts/Environment_variable/WxkrJQpP">environment variables</a> ($TWO_TASK in Unix-like environments; %TWO_TASK% in Microsoft Windows environments)<a class="footnote-ref" id="fnref:1" href="#fn:1"><sup>1</sup></a></li>
<li>in local <a href="/facts/Configuration_file/DDzU0FLJ">configuration files</a> (such as the default $ORACLE_HOME/network/admin.tnsnames.ora)<a class="footnote-ref" id="fnref:2" href="#fn:2"><sup>2</sup></a></li>
<li>in <a href="/facts/LDAP/KgpfD8nR">LDAP</a>-capable <a href="/facts/Directory_service/6fsVdntu">directory services</a></li></ul>

<h2 id="external-links">External links</h2>
<ul><li><a href="https://docs.microsoft.com/en-us/sql/odbc/microsoft/connection-string-format-and-attributes?view=sql-server-2017">"Connection strings in SQL Server 2017"</a>. Retrieved 15 June 2019.</li></ul>

<h2 id="references">References</h2>

<ol>
<li id="fn:1"><p>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. <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref360" target="_blank">http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref360</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li>
<li id="fn:2"><p>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). <a href="978-1-59059-530-5" target="_blank">978-1-59059-530-5</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li>
</ol>

Connection string open-in-new

Connection string