Connection string - Revision history

Cedar101: /* Examples */ fix syntaxhighlight error

2025-06-12T07:09:31Z

Examples: fix syntaxhighlight error

← Previous revision		Revision as of 07:09, 12 June 2025
Line 4:		Line 4:

	==Examples==		==Examples==
	This example shows a [[~~Postgres~~]] connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds:		This example shows a [[PostgreSQL]] connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds:

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

	Users of [[Oracle database]]s can specify connection strings:		Users of [[Oracle database]]s can specify connection strings:

Frap at 22:25, 16 May 2025

2025-05-16T22:25:18Z

← Previous revision		Revision as of 22:25, 16 May 2025
Line 43:		Line 43:
	</ref>		</ref>
	* in [[LDAP]]-capable [[directory service]]s		* in [[LDAP]]-capable [[directory service]]s

			== See also ==
			* [[Data source name]]

	==References==		==References==

N0099: /* Examples */

2025-05-16T17:06:48Z

Examples

← Previous revision		Revision as of 17:06, 16 May 2025
Line 5:		Line 5:
	==Examples==		==Examples==
	This example shows a [[Postgres]] connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds:		This example shows a [[Postgres]] connection string for connecting to wikipedia.com with SSL and a connection timeout of 180 seconds:
			<syntaxhighlight>
	<blockquote>
	DRIVER={PostgreSQL Unicode};SERVER=www.wikipedia.com;SSL=true;SSLMode=require;DATABASE=wiki;UID=wikiuser;Connect Timeout=180;PWD=ashiknoor		DRIVER={PostgreSQL Unicode};SERVER=www.wikipedia.com;SSL=true;SSLMode=require;DATABASE=wiki;UID=wikiuser;Connect Timeout=180;PWD=ashiknoor
			</syntaxhighlight>
	</blockquote>

	Users of [[Oracle database]]s can specify connection strings:		Users of [[Oracle database]]s can specify connection strings:

Kvng: no hyphen

2023-09-17T16:28:25Z

no hyphen

← Previous revision		Revision as of 16:28, 17 September 2023
Line 11:		Line 11:
	Users of [[Oracle database]]s can specify connection strings:		Users of [[Oracle database]]s can specify connection strings:

	* on the [[command-line]] (as in: <code>sqlplus scott/tiger@connection_string</code> )		* 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>%TWO_TASK%</code> in Microsoft Windows environments)<ref name=":0">		* via [[environment variable]]s (<code>$TWO_TASK</code> in Unix-like environments; <code>%TWO_TASK%</code> in Microsoft Windows environments)<ref name=":0">
	{{cite web		{{cite web

Ingenuity: Reverted edits by 125.27.98.166 (talk) to last version by Gameres

2022-09-30T12:58:07Z

Reverted edits by 125.27.98.166 (talk) to last version by Gameres

← Previous revision		Revision as of 12:58, 30 September 2022
Line 31:		Line 31:
	\|first= Thomas		\|first= Thomas
	\|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions		\|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions
	\|url= https://~~books~~.~~google.com~~/~~books?id=TmPoYfpeJAUC~~		\|url= https://archive.org/details/expertoracledata0000kyte
			\|url-access= registration
	\|accessdate= 2010-08-26		\|accessdate= 2010-08-26
	\|series= Apress series		\|series= Apress series
Line 37:		Line 38:
	\|publisher= Apress		\|publisher= Apress
	\|isbn= 978-1-59059-530-5		\|isbn= 978-1-59059-530-5
			\|page= [https://archive.org/details/expertoracledata0000kyte/page/60 60]
	\|page= 60
	\|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called <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).		\|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called <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).
	}}		}}

125.27.98.166: Undid revision 945799728 by InternetArchiveBot (talk)

2022-09-30T12:48:29Z

Undid revision 945799728 by InternetArchiveBot (talk)

← Previous revision		Revision as of 12:48, 30 September 2022
Line 31:		Line 31:
	\|first= Thomas		\|first= Thomas
	\|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions		\|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions
	\|url= https://~~archive~~.~~org/details~~/~~expertoracledata0000kyte~~		\|url= https://books.google.com/books?id=TmPoYfpeJAUC
	\|url-access= registration
	\|accessdate= 2010-08-26		\|accessdate= 2010-08-26
	\|series= Apress series		\|series= Apress series
Line 38:		Line 37:
	\|publisher= Apress		\|publisher= Apress
	\|isbn= 978-1-59059-530-5		\|isbn= 978-1-59059-530-5
			\|page= 60
	\|page= [https://archive.org/details/expertoracledata0000kyte/page/60 60]
	\|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called <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).		\|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called <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).
	}}		}}

Gameres at 13:42, 3 January 2022

2022-01-03T13:42:52Z

← Previous revision		Revision as of 13:42, 3 January 2022
Line 12:		Line 12:

	* on the [[command-line]] (as in: <code>sqlplus scott/tiger@connection_string</code> )		* 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 name=":0">		* via [[environment variable]]s (<code>$TWO_TASK</code> in Unix-like environments; <code>%TWO_TASK%</code> in Microsoft Windows environments)<ref name=":0">
	{{cite web		{{cite web
	\| url = http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref360		\| url = http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch2.htm#sthref360

InternetArchiveBot: Bluelink 1 book for verifiability (goog)) #IABot (v2.0) (GreenC bot

2020-03-16T05:37:51Z

Bluelink 1 book for verifiability (goog)) #IABot (v2.0) (GreenC bot

← Previous revision		Revision as of 05:37, 16 March 2020
Line 31:		Line 31:
	\|first= Thomas		\|first= Thomas
	\|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions		\|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions
	\|url= https://~~books~~.~~google.com~~/~~books?id=TmPoYfpeJAUC~~		\|url= https://archive.org/details/expertoracledata0000kyte
			\|url-access= registration
	\|accessdate= 2010-08-26		\|accessdate= 2010-08-26
	\|series= Apress series		\|series= Apress series
Line 37:		Line 38:
	\|publisher= Apress		\|publisher= Apress
	\|isbn= 978-1-59059-530-5		\|isbn= 978-1-59059-530-5
			\|page= [https://archive.org/details/expertoracledata0000kyte/page/60 60]
	\|page= 60
	\|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called <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).		\|quote= The TNS connection string tells the Oracle software how to connect to the remote database. Generally, the client software [...] will read a file called <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).
	}}		}}

Rich Farmbrough: Date formats

2019-06-15T15:13:59Z

Date formats

← Previous revision		Revision as of 15:13, 15 June 2019
Line 45:		Line 45:
	==References==		==References==
	{{reflist}}		{{reflist}}

			==External links==
			* {{Cite web\|url=https://docs.microsoft.com/en-us/sql/odbc/microsoft/connection-string-format-and-attributes?view=sql-server-2017\|title=Connection strings in SQL Server 2017\|accessdate = 15 June 2019}}
			{{Use dmy dates\|date=June 2019}}

	{{DEFAULTSORT:Connection String}}		{{DEFAULTSORT:Connection String}}

MrOllie: /* External links */

2019-05-07T16:02:50Z

External links

← Previous revision		Revision as of 16:02, 7 May 2019
Line 42:		Line 42:
	</ref>		</ref>
	* in [[LDAP]]-capable [[directory service]]s		* in [[LDAP]]-capable [[directory service]]s

	==External links==
	* [http://www.connectionstrings.com ConnectionStrings.com]

	==References==		==References==