Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Basic Connection String Attributes and Defaults

The FairCom Database provides a variety of interfaces. This document provides the connection strings required for establishing a connection through some of the most popular interfaces:

The following are basic FairCom DB parameters and definitions used in all drivers and interfaces described below.

Technology

Example

isql

isql -u ADMIN -p ADMIN 6597@localhost:ctreeSQL

 

isql -u ADMIN -p ADMIN ssl:6597@localhost:ctreesql

JDBC

getConnection("jdbc:ctree://localhost:6597/ctreeSQL", "ADMIN", "ADMIN")

Python

pyctree.connect(user='ADMIN',password='ADMIN',database='ctreeSQL',host='localhost',port='6597')

PHP

ctsql_connect(":6597@localhost:ctreeSQL", "ADMIN", "ADMIN")

ADO.NET

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

Connection Info

Description

Typical Value

Username

Username required to access a FairCom DB SQL database

ADMIN

Password

Password associated with a specific user required to access a FairCom DB SQL Database

ADMIN

Protocol

 

ssl

Host

(host or machine-name) - Host address for machine running the FairCom DB SQL database process. Default: localhost

127.0.0.1 (or localhost)

Port

The TCP/IP port assigned to the FairCom DB SQL database process. Default: 6597

6597

Database

A specific database containing all SQL tables and resources. Default: ctreeSQL

ctreeSQL

Database Engine

 

ctree

 

 

 

ISAM & NAV

 

FAIRCOMS@localhost

TOCIndex