Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

ADO.NET Connection String

ADO.NET connection strings are passed into CtreeSqlConnection objects as semicolon-separated Name-Value pairs. The Name portion of the Name-Value pair is not case-sensitive.

The following table lists Name-Value pairs used in connection strings for the FairCom DB SQL ADO.NET Data Provider.

You can use any of the synonyms as a replacement for the Name portion of the pair to remain cross-compatible with usage of other database products. The most common synonyms are shown below.

The minimum required are User ID and Password. If other values are not specified, default values will be assigned as noted.

Name

Default Value

Description

User ID

Synonyms

  • user id
  • userid
  • uid
  • user
  • user name
  • username

None

The user name for login.

Password

Synonyms

  • password
  • pwd
  • user password
  • userpassword

None

The password for the user.

Initial Catalog

Synonyms

  • database
  • initial catalog

ctreeSQL

The name of the FairCom DB SQL database.

Data Source

Synonyms

  • data source
  • datasource
  • server
  • host

localhost

The TCP/IP address of the FairCom DB SQL installation.

Port Number

Synonyms

  • port
  • service
  • port number

6597

The TCP/IP port number used by FairCom DB SQL.

Pooling

true

User client side connection pooling.

Max Pool Size

Synonyms

  • max pool size
  • maxpoolsize

100

Maximum number of pooled connections.

Connection Lifetime

Synonyms

  • connection lifetime
  • connectionlifetime

0

 

Connection Timeout

Synonyms

  • timeout
  • connection timeout
  • connectiontimeout

15

Number of seconds a particular connection object waits for an answer from the FairCom DB SQL server. The connection will disconnect after this value has elapsed with no response.

Connection Idle Timeout

Synonyms

  • connectionidletimout
  • connection idle timeout

0

Number of seconds a connection sits idle in the pool before being disposed. If a value is not specified, then all connection objects will stay in the connection pool regardless of use and never be disposed.

Isolation Level

Synonyms

  • isolation level
  • isolationlevel

ReadCommitted

The transaction isolation level for the connection.

ssl

 

(optional) Values of basic (no peer certificate authentication) or peerAuthentication (server certificate authentication)

sslcert

 

Required when peerAuthentication is requested to provide certificate defined server name

Example

A typical connection string for the FairCom DB ADO.NET Data Provider would be composed of:

"User ID=ADMIN;Password=ADMIN;database=ctreeSQL;server=localhost;port=6597”

A minimal connection string can be:

"User=ADMIN;Password=ADMIN"

TLS/SSL Examples

"UID=ADMIN;PWD=ADMIN;Database=ctreeSQL;Server=localhost;Service=6597;ssl=basic";

"UID=ADMIN;PWD=ADMIN;Database=ctreeSQL;Server=localhost;Service=6597;ssl=peerAuthentication;sslcert=support.faircom.com";

TOCIndex