Platform | Driver Manager |
---|---|
Darwin | OpenLink's Darwin client installer provides the iODBC driver manager. Users may also encounter unixODBC, mac:ODBC, and other driver managers. |
Mac Classic a/k/a Mac OS 9 | OpenLink's Mac Classic client installer provides its own driver manager for this platform. Users may also encounter another driver manager created by Visigenic and maintained by Intersolv, Merant, and Data Direct respectively. |
Mac OS X | OpenLink's default Mac OS X client installer provides an iODBC frameworks-based driver manager. Apple's Jaguar installer provides an iODBC dylibs-based driver manager. Users may also encounter unixODBC, mac:ODBC, and other driver managers. |
Environment Variable | Description |
---|---|
CLASSPATH | Passes the full path to OpenLink's Java archive (.jar) files. These files comprise the OpenLink JDBC client. This variable is not required for ODBC connectivity. |
LD_LIBRARY_PATH | Passes the full path to various library directories on Darwin computers. This variable must include the OpenLink /lib sub-directory. |
ODBCINI | Passes the full path to the odbc.ini file, which resides in the OpenLink /bin sub-directory. |
ODBCINSTINI | Passes the full path to the odbcinst.ini file, which resides in the OpenLink /bin sub-directory. |
OPENLINKINI | Passes the full path to the openlink.ini file, which resides in the OpenLink /bin sub-directory. |
PATH | Passes the full path to directories, which contain executables. This variable must include the OpenLink /bin sub-directory. |
/lib
sub-directory of the OpenLink client installation. Click here to see a complete list of OpenLink libraries by platform.Filename | Description |
---|---|
libiodbc.la | Static, iODBC driver manager library |
libiodbc.so | Shared, iODBC driver manager library. Older, iODBC driver manager libraries are linked to the latest revision |
libiodbc.so.2 | Revised, iODBC driver manager library. Older, iODBC driver manager libraries are linked to the latest revision |
libiodbc.so.2.1.2 | Revised, iODBC driver manager library. Older, iODBC driver manager libraries are linked to the latest revision |
mys3 st_lt.la | Static, single-threaded MySQL Single-Tier driver |
mys3_st_lt.so | Shared, single-threaded MySQL Single-Tier driver |
oplodbc.la | Static, Multi-Tier ODBC driver |
oplodbc.so | Shared, Multi-Tier ODBC driver. Older, Multi-Tier ODBC driver library files are linked to the latest revision |
oplodbc.so.1 | Revised, Multi-Tier ODBC driver library. Older, Multi-Tier ODBC driver library files are linked to the latest revision |
oplodbc.so.1.0.0 | Revised, Multi-Tier ODBC driver library. Older, Multi-Tier ODBC driver library files are linked to the latest revision |
ora81_st_lt.la | Static, single-threaded Oracle 8.1.x Single-Tier driver |
ora81_st_lt.so | Shared, single-threaded Oracle 8.1.x Single-Tier driver |
pgr7_mt_lt.la | Static, multi-threaded PostgreSQL Single-Tier driver |
pgr7_mt_lt.so | Shared, multi-threaded PostgreSQL Single-Tier driver |
pgr7_st_lt.la | Static, single-threaded PostgreSQL Single-Tier driver |
pgr7_st_lt.so | Shared, single-threaded PostgreSQL Single-Tier driver |
sql_st_lt.la | Static, single-threaded MS SQLServer Single-Tier driver |
sql_st_lt.so | Shared, single-threaded MS SQLServer Single-Tier driver |
syb12_st_lt.la | Static, single-threaded Sybase Single-Tier driver |
syb12_st_lt.so | Shared, single-threaded Sybase Single-Tier driver |
sql.h
, sqlext.h
, and sqltypes.h
header files. Developers may use these files to build ODBC-compliant applications.openlink.ini
file to obtain database-specific environment variable settings. The openlink.ini
file resides in the /bin
sub-directory of Single-Tier client installations.oplrqb.ini
file to resolve ODBC connection requests and to enforce OpenLink's sophisticated, rule-based security. The oplrqb.ini
file resides in the /bin
sub-directory of OpenLink's server components installations.odbc.ini
file using vi or a similar text editor. Novice users may use the HTTP-Based iODBC Data Sources Administrator, or they may use the Multi-Tier Administrative Assistant.Section | Description |
---|---|
ODBC Data Sources | This section names each of the ODBC data sources that appear in the odbc.ini file. It also pairs the appropriate ODBC driver name with the data source name. |
Data Source Specifications | This section lists the actual data source names. Each data source name is composed of a formal name and a parameter list. |
Parameter | Description |
---|---|
[Data Source Name] | Passes a descriptive data source title. This title must match the title passed under the [ODBC Data Sources] heading. |
Driver | Passes the full path to the ODBC client driver. |
ServerType | Passes a valid OpenLink domain alias. This domain alias must match a valid domain alias in the Single-Tier openlink.ini file or Multi-Tier oplrqb.ini file. The drivers use these domain aliases as starting points from which to assess rules, environment variables, and agent binaries to instantiate for connections. |
Username | Passes a valid database username. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system username. |
Password | Passes a valid database password. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system password. |
Database | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Options | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
FetchBufferSize | Passes an integer, which represents the number of rows that the driver will return during an individual fetch. |
ReadOnly | Passes a Yes or No value to enable or disable READONLY access to the data store. |
DeferLongFetch | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
JetFix | Passes a Yes or No value to enable or disable JetFix. JetFix facilitates translation of data types by Microsoft's Jet Engine. This feature is intended primarily for use with Microsoft client applications on Windows. |
Description | Passes a description of the use or nature of the data source name. |
Parameter | Description |
---|---|
Protocol | Passes a valid OpenLink network protocol. The default is TCP/IP. |
Hostname | Passes the hostname or IP address of the machine, which contains the OpenLink request broker. |
Port | Passes the TCP port on which the request broker listens. This TCP port is associated with the ListenPort parameter, and it appears in the [Protocol TCP] section of the Multi-Tier Rules Book (oplrqb.ini ). |
/bin/w3config
sub-directory of the client's OpenLink installation.www_sv.ini
file.[Startup]
section.HttpPort
. For example: /bin
sub-directory of the client's OpenLink installation.http://localhost:HttpPort_from_www_sv.ini
Parameter | Description |
---|---|
Name | Passes a descriptive data source title. |
Comment | Passes a description of the use or nature of the data source name. |
Database Name | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Server | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
Username | Passes a valid database username. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system username. |
Read-only connection | Passes a Yes or No value to enable or disable READONLY access to the data store. |
No Login Dialog Box | Enables or disables the login popup box. |
Defer Fetching of long data | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Row buffer size | Passes an integer, which represents the number of rows that the driver will return during an individual fetch operation. |
Jet Fix | Passes a Yes or No value to enable or disable JetFix. JetFix facilitates translation of data types by Microsoft's Jet Engine. This feature is intended for use with MS Access client applications. |
Environment | Passes a valid OpenLink domain alias. This domain alias must match a valid domain alias in the Single-Tier openlink.ini file. The drivers use these domain aliases as starting points from which to assess rules, environment variables, and agent binaries to instantiate for connections. |
Parameter | Description |
---|---|
Name | Passes a descriptive data source title. |
Comment | Passes a description of the use or nature of the data source name. |
Domain | Passes a valid OpenLink domain alias. This domain alias must match a valid domain alias in the Multi-Tier oplrqb.ini file. The drivers use these domain aliases as starting points from which to assess rules, environment variables, and agent binaries to instantiate for connections. |
Hostname | Passes the hostname or IP address of the machine, which contains the OpenLink request broker. |
Port | Passes the TCP port, on which the request broker listens. This TCP port is associated with the ListenPort parameter, and it appears in the [Protocol TCP] section of the Multi-Tier Rules Book (oplrqb.ini). |
Protocol | Passes a valid OpenLink network protocol. The default is TCP/IP. |
Database Name | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Server | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
Username | Passes a valid database username. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system username. |
Read-only Connection | Passes a Yes or No value to enable or disable READONLY access to the data store. |
No Login Dialog Box | Enables or disables login popup box. |
Defer Fetching of long data | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Row buffer size | Passes an integer, which represents the number of rows that the driver will return during an individual fetch. |
Parameter | Description |
---|---|
Name | Passes a descriptive data source title. |
Comment | Passes a description of the use or nature of the data source name. |
Domain | Passes a valid OpenLink domain alias. This domain alias must match a valid domain alias in the Multi-Tier oplrqb.ini file. The drivers use these domain aliases as starting points from which to assess rules, environment variables, and agent binaries to instantiate for connections. |
Hostname | Passes the hostname or IP address of the machine, which contains the OpenLink request broker. |
Port | Passes the TCP port, on which the request broker listens. This TCP port is associated with the ListenPort parameter, and it appears in the [Protocol TCP] section of the Multi-Tier Rules Book (oplrqb.ini). |
Protocol | Passes a valid OpenLink network protocol. The default is TCP/IP. |
Database Name | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Server | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
Username | Passes a valid database username. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system username. |
Read-only Connection | Passes a Yes or No value to enable or disable READONLY access to the data store. |
No Login Dialog Box | Enables or disables login popup box. |
Defer Fetching of long data | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Row buffer size | Passes an integer, which represents the number of rows that the driver will return during an individual fetch. |
Parameter | Description |
---|---|
Name | Passes a descriptive data source title. |
Comment | Passes a description of the use or nature of the data source name. |
Domain | Passes a valid OpenLink domain alias. This domain alias must match a valid domain alias in the Multi-Tier oplrqb.ini file. The drivers use these domain aliases as starting points from which to assess rules, environment variables, and agent binaries to instantiate for connections. |
Hostname | Passes the hostname or IP address of the machine, which contains the OpenLink request broker. |
Port | Passes the TCP port, on which the request broker listens. This TCP port is associated with the ListenPort parameter, and it appears in the [Protocol TCP] section of the Multi-Tier Rules Book (oplrqb.ini). |
Protocol | Passes a valid OpenLink network protocol. The default is TCP/IP. |
Database Name | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Server | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
Username | Passes a valid database username. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system username. |
Read-only Connection | Passes a Yes or No value to enable or disable READONLY access to the data store. |
No Login Dialog Box | Enables or disables login popup box. |
Defer Fetching of long data | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Row buffer size | Passes an integer, which represents the number of rows that the driver will return during an individual fetch. |
Section | Description |
---|---|
ODBC Data Sources | This section names each of the ODBC data sources that appear in the ODBC.preference file. It also pairs the appropriate ODBC driver name with the data source name. |
Data Source Specifications | This section lists the actual data source names. Each data source name is composed of a formal name and a parameter list. |
Parameter | Description |
---|---|
Name | Passes a descriptive data source title. |
Comment | Passes a description of the use or nature of the data source name. |
Domain | Passes a valid OpenLink domain alias. This domain alias must match a valid domain alias in the Multi-Tier oplrqb.ini file. The drivers use these domain aliases as starting points from which to assess rules, environment variables, and agent binaries to instantiate for connections. |
Hostname | Passes the hostname or IP address of the machine, which contains the OpenLink request broker. |
Port | Passes the TCP port, on which the request broker listens. This TCP port is associated with the ListenPort parameter, and it appears in the [Protocol TCP] section of the Multi-Tier Rules Book (oplrqb.ini). |
Protocol | Passes a valid OpenLink network protocol. The default is TCP/IP. |
Database Name | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Server | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
Username | Passes a valid database username. If the Multi-Tier OPSYSLOGIN parameter is enabled, this parameter passes a valid operating system username. |
Read-only Connection | Passes a Yes or No value to enable or disable READONLY access to the data store. |
No Login Dialog Box | Enables or disables login popup box. |
Defer Fetching of long data | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Row buffer size | Passes an integer, which represents the number of rows that the driver will return during an individual fetch. |
Parameter | Description |
---|---|
Data Source Name | Passes a descriptive data source title. This title must match the title passed under the [ODBC Data Sources] heading. |
Driver | Passes the full path to the ODBC client driver. |
Description | Passes a description of the use or nature of the data source name. |
Cursor_Sensitivity | Passes a Yes or No value to enable or disable the row version cache, which is used with dynamic cursors. |
FetchBufferSize | Passes an integer, which represents the number of rows that the driver will return during individual fetch operations. |
InitialSQL | Passes a path to a file containing SQL statements. These statements are issued against the database upon initial connection. InitialSQL scripts usually contain statements, which set ISOLATION levels. |
Username | Passes a valid database username. |
Password | Passes a valid database password |
MaxRows | Passes an integer, which limits the maximum number of rows that may be returned. |
NoAutoCommit | Passes a Yes or No value, which enables or disables the driver's autocommit behaviour. |
NoLoginBox | Passes a Yes or No value to disable or enable the login pop-up box. |
NoRowsetSizeLimit | Passes a Yes or No value to enable or disable rowset size limits. Default rowset size limits are enforced by the cursor library. These limits prevent the driver from consuming all available memory in the event that rowsets are inordinately large. |
ReadOnly | Passes a Yes or No value to enable or disable READONLY access to the data store. |
Options | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
DeferLongFetch | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Parameter | Description |
---|---|
TDSHost | Passes the hostname or IP address of the machine that hosts SQLServer. |
TDSPort | Passes the TCP port on which SQLServer listens. |
TDSVersion | Passes the TDS Version specification number. Do not alter this value. |
SQLServerCatalog | Passes Yes to use Microsoft SQLServer implementation of catalog calls. Passes No to use Sybase implementation. |
Parameter | Description |
---|---|
Disable ODBC transactions | Disables transaction management. Enforces autocommit for all statements. |
Parameter | Description |
---|---|
OraCatalogs | Promotes efficient processing of Oracle catalog calls such as SQLForeignKey() and SQLPrimaryKeys(). The appropriate odbccat#.sql script must be run before OraCatalogs is enabled. There is one odbccat#.sql script for each Oracle database version. |
ShowRemarks | Retrieves contents of SQLColumns REMARKS field. |
UserTblsFirst | Causes user tables to appear at beginning of SQLTables() table name listing. |
CountProcParms | Insures that number of parameters passed by stored procedures matches the number of parameters expected by SQLProcedures. |
OCIPrefetchRows | Passes an integer value, which represents the number of rows to prefetch. |
OCIPrefetchMemory | Passes an integer value, which represents the amount of memory to use for prefetch operations. |
OracleDirectory | Passes the full path to the Oracle home directory. |
Parameter | Description |
---|---|
Disable ODBC transactions | Disables transaction management. Enforces autocommit for all statements. |
Parameter | Description |
---|---|
Data Source Name | Passes a descriptive data source title. This title must match the title passed under the [ODBC Data Sources] heading. |
Driver | Passes the full path to the ODBC client driver. |
Description | Passes a description of the use or nature of the data source name. |
Passes a Yes or No value to enable or disable the row version cache, which is used with dynamic cursors. | |
FetchBufferSize | Passes an integer, which represents the number of rows that the driver will return during individual fetch operations. |
InitialSQL | Passes a path to a file containing SQL statements. These statements are issued against the database upon initial connection. InitialSQL scripts usually contain statements, which set ISOLATION levels. |
Username | Passes a valid database username. |
Password | Passes a valid database password |
MaxRows | Passes an integer, which limits the maximum number of rows that may be returned. |
NoAutoCommit | Passes a Yes or No value, which enables or disables the driver's autocommit behaviour. |
NoLoginBox | Passes a Yes or No value to disable or enable the login pop-up box. |
NoRowsetSizeLimit | Passes a Yes or No value to enable or disable rowset size limits. Default rowset size limits are enforced by the cursor library. These limits prevent the driver from consuming all available memory in the event that rowsets are inordinately large. |
ReadOnly | Passes a Yes or No value to enable or disable READONLY access to the data store. |
Options | Passes Progress SHN sockets parameters. Users may also use the field to pass database native communications parameters to establish three-tier connections. For instance, users may pass Sybase instance names, Oracle aliases, or Ingres vnodes to connect database agents--through local database native clients--to remote databases. |
DeferLongFetch | Passes a Yes or No value to enable or disable deferred fetching. Deferred fetching causes large, binary objects to be fetched after other, smaller data. This enhances performance. |
Parameter | Description |
---|---|
DSN | Passes a descriptive data source title. |
Description | Passes a description of the use or nature of the data source name. |
Hostname | Passes the hostname or IP address of the machine, which contains the database server. |
Port | Passes the TCP port, on which the database server or PostgreSQL postmaster listens. |
Username | Passes a valid database username. |
Password | Passes a valid database password. |
Row buffer size | Passes an integer, which represents the number of rows that the driver will return during an individual fetch. |
Hide login dialog | Enables or disables the login popup box. |
Read only connection | Enables or disables READONLY access to the data store. |
Database | Passes the name of a database or Oracle SID. Progress users should pass the full path to their databases. |
Initialization SQL | Passes a path to a file containing SQL statements. These statements are issued against the database upon initial connection. InitialSQL scripts usually contain statements, which set ISOLATION levels. |
Max rows override | Passes an integer, which represents the number of rows that the driver will return during individual fetch operations. |
Disable autocommit | Enables or disables the driver's autocommit behavior. |
Disable rowset size limit | Enables or disables rowset size limits. Default rowset size limits are enforced by the cursor library. These limits prevent the driver from consuming all available memory in the event that rowsets are inordinately large. |
High cursor sensitivity | Enables or disables the row version cache, which is used with dynamic cursors. |
Defer Fetching of long data | Enables or disables deferred fetching. Deferred fetching causes large, binary objects to be fetched after other data. This enhances performance. |
Parameter | Description | |
---|---|---|
Character Set | MS SQLServer/Sybase | Passes the name of a valid character set. |
Enable Microsoft Jet Engine options | MS SQLServer/Sybase | Passes a Yes or No value to enable or disable JetFix. JetFix facilitates translation of data types by Microsoft's Jet Engine. This feature is intended for use with MS Access client applications. |
Language | MS SQLServer/Sybase | Passes the name of a supported, national language. |
Server Type | MS SQLServer/Sybase | Passes a Database Management System (DBMS) name and version. Choose the closest possible match to your DBMS. |
Disable ODBC transactions | MySQL/PostgreSQL | Disables transaction management. Enforces autocommit for all statements. |
Count stored procedures parameters | Oracle | Insures that number of parameters passed by stored procedures matches the number of parameters expected by SQLProcedures. |
Custom catalog views | Oracle | Promotes efficient processing of Oracle catalog calls such as SQLForeignKey() and SQLPrimaryKeys(). The appropriate odbccat#.sql script must be run before OraCatalogs is enabled. There is one odbccat#.sql script for each Oracle database version. |
Net Service | Oracle | Passes the name of a valid Oracle Net Service. |
Net Service name | Oracle | Passes the name of a valid Oracle Net Service. |
OCIPrefetch Memory | Oracle | Passes an integer value, which represents the amount of memory to use for prefetch operations. |
OCIPrefetch Rows | Oracle | Passes an integer value, which represents the number of rows to prefetch. |
Oracle directory | Oracle | Passes the full path to the Oracle home directory. |
Service name/SID | Oracle | Passes the name of a valid Oracle SID. |
Show remarks | Oracle | Retrieves content of SQLColumns REMARKS field. |
Use Oracle 8i release 8.0 Compatible Identification | Oracle | |
User's own tables first in SQLTables | Oracle | Causes user tables to appear at beginning of SQLTables() table name listing. |