SUPPORT THE WORK

GetWiki

Connection string

ARTICLE SUBJECTS
aesthetics  →
being  →
complexity  →
database  →
enterprise  →
ethics  →
fiction  →
history  →
internet  →
knowledge  →
language  →
licensing  →
linux  →
logic  →
method  →
news  →
perception  →
philosophy  →
policy  →
purpose  →
religion  →
science  →
sociology  →
software  →
truth  →
unix  →
wiki  →
ARTICLE TYPES
essay  →
feed  →
help  →
system  →
wiki  →
ARTICLE ORIGINS
critical  →
discussion  →
forked  →
imported  →
original  →
Connection string
[ temporary import ]
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
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 Postgres 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=ashiknoorUsers of Oracle databases can specify connection strings:
  • on the command-line (as in: sqlplus scott/tiger@connection_string )
  • via environment variables ($TWO_TASK in Unix-like environments; %LOCAL% in Microsoft Windows environments)
WEB,weblink Configuring SQL*Plus, Simon, Watt, June 2005, SQL*Plus User's Guide and Reference: Release 10.2, Oracle Corporation, Redwood City, 2010-08-26, LOCAL [:] Windows environment variable to specify a connection string. Performs the same function as TWO_TASK on UNIX., etal,
  • in local configuration files (such as the default $ORACLE_HOME/network/admin.tnsnames.ora)
BOOK, Kyte, Thomas, Expert Oracle database architecture: 9i and 10g programming techniques and solutions,weblink 2010-08-26, Apress series, 2005, Apress, 978-1-59059-530-5, 60, 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]networkadmin directory ([ORACLE_HOME] represents the full path to your Oracle installation directory).,

References

{{reflist}}

External links

  • WEB,weblink Connection strings in SQL Server 2017, 15 June 2019,
{{Use dmy dates|date=June 2019}}{{comp-sci-stub}}

- content above as imported from Wikipedia
- "Connection string" does not exist on GetWiki (yet)
- time: 3:48am EDT - Sun, Aug 25 2019
[ this remote article is provided by Wikipedia ]
LATEST EDITS [ see all ]
GETWIKI 09 JUL 2019
Eastern Philosophy
History of Philosophy
GETWIKI 09 MAY 2016
GETWIKI 18 OCT 2015
M.R.M. Parrott
Biographies
GETWIKI 20 AUG 2014
GETWIKI 19 AUG 2014
CONNECT