Things an Admin Must Know and Do
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 |
