请输入您要查询的百科知识:

 

词条 Connection string
释义

  1. Examples

  2. External links

  3. References

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=ashiknoor

Users 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)[1]
  • in local configuration files (such as the default $ORACLE_HOME/network/admin.tnsnames.ora)[2]
  • in LDAP-capable directory services

External links

  • ConnectionStrings.com
  • Sql Server ConnectionString

References

1. ^{{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|date=June 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.|display-authors=etal}}
2. ^{{cite book|last= Kyte|first= Thomas|title= Expert Oracle database architecture: 9i and 10g programming techniques and solutions|url= https://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|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 tnsnames.ora. This is a plaint-text configuration file commonly found in the [ORACLE_HOME]\etwork\\admin directory ([ORACLE_HOME] represents the full path to your Oracle installation directory).}}
{{DEFAULTSORT:Connection String}}{{comp-sci-stub}}

3 : Databases|SQL data access|String (computer science)

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/9/23 22:33:12