Skip to content

Latest commit

 

History

History
28 lines (25 loc) · 1.54 KB

connection-strings.md

File metadata and controls

28 lines (25 loc) · 1.54 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Connection Strings
Connection Strings
David-Engel
davidengel
01/19/2017
sql
connectivity
conceptual
data sources [ODBC], connection functions
connecting to driver [ODBC], connection strings
functions [ODBC], data source or driver connections
connection strings [ODBC], about connection strings
connecting to data source [ODBC], connection strings
connecting to data source [ODBC], functions
connecting to driver [ODBC], functions
connection functions [ODBC]
ODBC drivers [ODBC], connection functions

Connection Strings

A connection string contains information used for establishing a connection. A complete connection string contains all the information needed to establish a connection. The connection string is a series of keyword/value pairs separated by semicolons. (For the complete syntax of a connection string, see the SQLDriverConnect function description.) The connection string is used by:

  • SQLDriverConnect, which completes the connection string by interaction with the user.

  • SQLBrowseConnect, which completes the connection string iteratively with the data source.

SQLConnect does not use a connection string; using SQLConnect is analogous to connecting using a connection string with exactly three keyword/value pairs (for data source name and, optionally, user ID and password).