Common settings for ODBC, JDBC, and OLEDB
This page lists all the parameters and options used to start
both the client and server portions of these products. The list
is current for version 2.2.8.
Parameters (Not case sensitive)
These values are used on the startup line for the servers. This
can be in the command file or inetd configuration that launches
the listener process.
Precede these values with a slash (/) for HPUX, Windows, and
Linux. When using more than one parameter, use the space character
to separate them (including MPE). The parameters are not order dependant.
- S - Require valid host logon information. (highly recommended)
- W - Allow update access.
- N - Use Eloquence Native libraries in place of Image emulation.
- V - Print version information to the terminal and exit.
- R - Return record numbers as ROWID column.
- H - Allow host command processing.
- C - Use Catalog Editor file for additional access control.
- F - Force Full Read mode.
- P - Port to use.
- T - Trace mode. (Do not use this option in production.)
- E - Environment File.
Parameters Samples
HPUX
The following line from inetd.conf on an HPUX system shows the
parameters that permit write access, require a valid logon, and
returns the record number as ROWID.
odbcsrvr stream tcp nowait root /opt/minisoft/odbcsrvr.exe
odbcsrvr.exe /W /S /R
MPE
The following line from the MSJOB file on an MPE system shows
the same settings.
!SETVAR MSSERVER000004 "30006 0 ODBCSRVR.MM.MINISOFT;PRI=DS;INFO='
S W R'"
Environment Variables
Integer
- MSTRACELOGON (not MPE)
Set to 1.
Logs startup (valid or error message).
Logs Usage (record count and CPU) on exit.
- AIFCHANGELOGON (MPE only)
- MSTEMPFM (MPE only)
- MSFILEEQ (MPE only)
- TraceSysLevel
- TraceLogLevel
- TraceLogFlush
- ROBELLE_SD_TYPE
- NATIVE_ELOQ
- MSQUERYRECLIMIT
- MSQUERYCPULIMIT
- MSQUERYCHECKINTERVAL
- MSTRACESTATEMENT
- TRACEDBSTATS
String
- TraceFileName
- MSDECADEDIGITS
- TMPDIR (HPUX)
(More
details on pre 2.2.8 Connection Settings)
-
2DriverTable=[FILENAME]
FILENAME = Translation table file stored on the client for 8bit codes from the host to
client.
2DriverTable=/opt/minisoft/rom8ansi.tbl
-
2HostTable=[FILENAME]
FILENAME = Translation table file stored on the client for 8bit codes from the client to host.
2HostTable=/opt/minisoft/ansirom8.tbl
-
Account=[ACCT]
ACCT = MPE Logon account
(Only used with Server Type=0)
Account=MINISOFT
-
Account Password=[PASSWORD]
AccountPassword
PASSWORD = MPE Account password
(Only used with Server Type=0)
AccountPassword=SAMPLE
-
AutoCommitDefault
define
sample
-
BigIntAsChar
define
sample
-
Catalog User
CatalogUser
-
Catalog Password
CatalogPassword
-
CenturySplit
-
Database<n>
Deprecated (obsolete). Use ImageDatabase<n>.
-
DecimalPoint
-
Description
-
DisableTxns
-
Domain
-
Driver
-
DSN
-
Group
-
Group Password
GroupPassword
-
IgnoreUIDPWD
When set (numeric value of 1), values passed in the connection
string for user or password do not supersede the value provided
in the DSN or connection string. Use only if your applications
passes default values that are not related to your host system.
i.e. passing the windows user name to an MPE system.
(Default value is 0)
IgnoreUIDPWD=1
-
ImageDatabase<n>=<DBNAME>,<DBPASS>,<AMFLAG>,<MODE>,<TPIFLAG>
- n = Sequential
number starting with zero. Each database to be opened in
the same DSN must have a unique value. All the databases
in the same DSN will be opened with the same security credentials.
- DBNAME =
database name to access on the host.
- DBPASS =
database password
- AMFLAG =
load auto master flag 0/1
- MODE = database
open mode (actual)
- TPIFLAG =
append TPI suffix 0=No 1=Yes
ImageDatabase0=MSCARD.MM.MINISOFT,DO-ALL,0,5,0
ImageDatabase1=OTHERM.MM.MINISOFT,READ1,0,5,0
-
ItemLocking
-
Jobname
-
Language
-
LockRetries
If a first lock attempt does not succeed, the server application
uses a progressive lock delay algorithm. The delay algorithm
is: (0.05 + 0.01 * attempt + 0.001 * attempt * attempt)
The first retry will be after a delay of 0.05 seconds the tenth
0.221 seconds and the twentieth 0.601 seconds. The total time
asleep after 20 tries will be at least 1.155 seconds.
-
MaxCacheSize
Largest size of a buffer that can be transmitted from the
host to the client. Primarily used to resolve issues caused
by packet filtering network switches that attempt to resolve
entire TCP packets through fragment consolidation. If the switch
does not have sufficient memory to accommodate the traffic,
fragment re-assembly make take several seconds. Changing this
value can seriously impact performance. Please contact Minisoft
support if this value is to be used.
-
MaxWriteSize
Largest size of a buffer that can be transmitted from the
client to the host. Primarily used to resolve issues caused
by packet filtering network switches that attempt to resolve
entire TCP packets through fragment consolidation. If the switch
does not have sufficient memory to accommodate the traffic,
fragment re-assembly make take several seconds. Changing this
value can seriously impact performance. Please contact Minisoft
support if this value is to be used.
-
password
-
PWD
-
Schema<n>
-
SDFile<n>
-
Security Password
SecurityPassword
-
Server
-
Server Port
ServerPort
-
Server Type
ServerType
-
StandardJoins
-
TraceSysLevel
-
TraceFileName
-
TraceLogLevel
-
TraceLogFlush
-
UID
-
User
-
User Password
UserPassword
-
WarningsAreErrors
|