800.682.0200 | FAX: 360.568.2923 |  About Us  |  Downloads  |  Manuals  |  Home  |  Index

  

Connection Parameters

These parameters are used for ODBC, JDBC and OLEDB connections to MPE, UNIX, and Windows servers.

Parameter7 Description
Driver String Value to identify the driver in use. Used for ODBC connections.
Driver="HP3000 Data Access Driver"
driver=3kodbc
2DriverTable Translation table for 8bit codes from the host (HP3000) to client(Windows, etc.).
2DriverTable=/opt/minisoft/rom8ansi.tbl
2HostTable Translation table for 8bit codes from the client (Windows, etc.) to host (HP3000).
2HostTable=/opt/minisoft/ansirom8.tbl
Account Logon account
(Only used with Server Type=0)
Account Password
AccountPassword		 Account password
(Only used with Server Type=0)
Database<n> This form is deprecated (obsolete). Use ImageDatabase<n>
<database name to access on the HP3000>,<database password>,<load auto master flag 0/1>6,<database open mode (zero based)>3
ImageDatabase<n> <database name to access on the HP3000>,<database password>,<load auto master flag 0/1>6,<database open mode (actual)>3
DecimalPoint For use with foreign character sets.
Description Description string
Group Logon group
(Only used with Server Type=0)
Group Password
GroupPassword		 Group password
(Only used with Server Type=0)
Jobname Session or Job name (Server Type=0)
Language For use with foreign character sets
Schema<n> <name of the schema file>,<lockword>
Server Server IP Address or Hostname
Server Port
ServerPort		 Server Port - usually 30006
Server Type
ServerType		 Type of host for the ODBCSRVR (0=MPE, 1=Unix, 2=Windows)
User User logon name
User Password
UserPassword		 User password
AutoCommitDefault Use transaction manager for writes. (ON,OFF)
Catalog User
CatalogUser		 ODBCCAT user name
Security Password
SecurityPassword		 Security/30000 password (Server Type=0)
WarningsAreErrors Effect of selecting less than the total number of columns. (YES,NO)
SDFile<n> filename, lockword, type (Image SD, Quiz Subfile, Robelle SD), fopt, aopt
Domain Windows Domain (Server Type=2)
ItemLocking ENABLED or DISABLED
LockRetries An integer value referencing the number of times to retry a lock.

NOTES:

  1. All names are case sensitive.
  2. As of 2.2.6.2, spaces in some parameter names are optional.
  3. The 0 mode value for the Database open is offset from zero. A value of 0 means mode 1, a value of 4 means mode 5.
  4. When specifying Databases, SDFiles or Schemas the value of <n> should be replaced with a digit starting from zero for each of these parameters.
  5. Comas must be included whether or not a value is entered.
  6. Where 1 is load automatic masters and 0 is do not load automatic masters.
  7. Where two names appear for a parameter, they are synonyms. You may use either form.