Previous PageNext Page

4.5.1 Database Parameters

The following databases are discussed below:
 

4.5.1.1 Interbase

Parameter
 
Meaning
 
UseCursorLib
 
When set to 1, this forces the use of ODBC manager's cursor support overriding the driver support. This enables "RecordSet.Update".
 
DbName
 
Within each database installation, there might one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 
User
 
The user name required to access the database.
 
Password
 
Since there can be more than one installation of PostgreSQL, they are distinguished by being assigned different ports (socket numbers).
 

4.5.1.2 PostgreSQL

Parameter
 
Meaning
 
Name
 
The data source name.
 
Servername
 
The IP address of the server containing the database. If blank, the database is assumed to be on the local machine.
 
Port
 
Since there can be more than one installation of PostgreSQL, they are distinguished by being assigned different ports (socket numbers).
 
Database
 
Within each PostgreSQL installation, there are one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 
Username
 
The username required to access the database. If this does not appear, every connection string to this DSN needs to contain a username.
 
Password
 
The password required to access the database. If this does not appear, every connection string to this DSN needs to contain a password.
 
Driver
 
PostgreSQL
 
ReadOnly
 
Treat the database as read-only. The default is 0 (off).
 

4.5.1.3 MySQL

Parameter
 
Meaning
 
Name
 
The data source name.
 
UseCursorLib
 
When set to 1, this forces the use of ODBC manager's cursor support overriding the driver support. This enables "RecordSet.Update", which is not supported in the default MyODBC driver.
 
Driver
 
MyODBC
 

4.5.1.4 dBase

Parameter
 
Meaning
 
Database
 
Within each database installation, there might one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 

4.5.1.5 Oracle

Parameter
 
Meaning
 
LogonID
 
The username required to access the database. If this does not appear, every connection string to this DSN needs to contain a username.
 
Password
 
The password required to access the database. If this does not appear, every connection string to this DSN needs to contain a password.
 
ServerName
 
The IP address of the server containing the database. If blank, the database is assumed to be on the local machine.
 

4.5.1.6 MS SQL Server

Parameter
 
Meaning
 
Database
 
Within each database installation, there might one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 
PWD
 
The password required to access the database. If this does not appear, every connection string to this DSN needs to contain a password.
 
ServerIPAddress
 
The IP address of the database server
 
ServerPortNumber
 
The port which the database server is listening to.
 
UID
 
The username required to access the database. If this does not appear, every connection string to this DSN needs to contain a username.
 

4.5.1.7 Sybase

Parameter
 
Meaning
 
DB
 
Within each database installation, there might one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 
LogonID
 
The username required to access the database. If this does not appear, every connection string to this DSN needs to contain a username.
 
Password
 
The password required to access the database. If this does not appear, every connection string to this DSN needs to contain a password.
 
ServerName
 
The name of the database server containing the database. If blank, the database is assumed to be on the local machine.
 
   

4.5.1.8 Informix

Parameter
 
Meaning
 
DB
 
Within each database installation, there might one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 
LogonID
 
The username required to access the database. If this does not appear, every connection string to this DSN needs to contain a username.
 
Password
 
The password required to access the database. If this does not appear, every connection string to this DSN needs to contain a password.
 
ServerName
 
The name of the database server containing the database. If blank, the database is assumed to be on the local machine.
 

4.5.1.9 SequeLink

Parameter
 
Meaning
 
Name
 
The data source name.
 
Driver
 
SequeLink
 
Description
 
Optional text information describing the DSN.
 
SqlnkDSN
 
This is the DSN set by running the ./setsqllnk utility. See the section on Configuring SequeLink below.
 
LogonID
 
The username required to access the database. If this does not appear, every connection string to this DSN needs to contain a username.
 
Database
 
Within each database installation, there might one or more databases, each with its own name. This parameter indicates which one to use for this DSN.
 
Password
 
The password required to access the database. If this does not appear, every connection string to this DSN needs to contain a password.
 
UidPwdMapping
 
Some databases (such as Microsoft SQL Server) require two sets of username/password - one for access to the host server, and one for the database itself. Only one pair can be passed via the connection string (or the LoginID/password configured here). The other must be configured into the SqlnkDSN described in the section Configuring SequeLink below.
 
On NT:
 
The UidPwdMapping determines whether the LoginID represents the host (UidPwdMapping = 1), or the database (UidPwdMapping = 0).
 
On Solaris:
 
The UidPwdMapping determines whether the LoginID represents the host (UidPwdMapping = 0), or the database (UidPwdMapping = 1).
 
EnableScrollableCursors
 
This allows cursor types other than "ForwardOnly" to be used.
 


Chili!Docs v.3.0.5  --  Copyright © 2000 Chili!Soft

Previous PageTop Of
PageNext Page