Kbase P116662: Explanation of the ODBC Data Source parameters
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
Explanation of the ODBC Data Source parameters
GOAL:
What is the meaning of the various ODBC Data Source parameters ?
GOAL:
What are the definitions of the ODBC.INI tags ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The definition of the ODBC.INI tags are as follows:
Driver: The data source specific library used by the Driver Manager.
DatabaseName: The name of the database used by this DSN.
PortNumber: The Network Service number the database server is listening for connections on.
HostName: The name of the host machine the database server is running on.
LogonID: The default user id for logon to the database server.
Password: The password for the default user id.
APILevel: A number indicating the ODBC interface conformance level supported by the driver:
0 = None
1 = Level 1 supported
2 = Level 2 supported
ConnectFunctions: A three-character string indicating whether the driver supports SQLConnect, SQLDriverConnect, and SQLBrowseConnect. If the driver supports SQLConnect, the first character is "Y"; otherwise, it is "N". If the driver supports SQLDriverConnect, the second character is "Y"; otherwise, it is "N". If the driver supports SQLBrowseConnect, the third character is "Y"; otherwise, it is "N". For example, if a driver supports SQLConnect and SQLDriverConnect but not SQLBrowseConnect, the three-character string is "YYN".
CPTimeout: Time interval setting for Connection Pooling Timeout. Not support on UNIX.
DriverODBCVer: A character string with the version of ODBC that the driver supports. The version is of the form nn.nn, where the first two digits are the major version and the next two digits are the minor version.
FileUsage: A number indicating how a file-based driver directly treats files in a data source.
0 = The driver is not a file-based driver. For example, a PROGRESS driver is a DBMS-based driver.
1 = A file-based driver treats files in a data source as tables. For example, an Xbase driver treats each Xbase file as a table.
2 = A file-based driver treats files in a data source as a catalog. For example, a Microsoft® Access driver treats each Microsoft Access file as a complete database.
SQLLevel: A number indicating the SQL-92 grammar supported by the driver:
0 = SQL-92 Entry
1 = FIPS127-2 Transitional
2 = SQL-92 Intermediate
3 = SQL-92 Full
UsageCount: Indicates driver libraries are in use. This value should not be modified.
ArraySize: A hint that can be provided to the ODBC driver with regards to how many records can be retrieved from the server at a time.
DefaultIsolationLevel: The default isolation level under which data will be accessed. Value could be any of :
READ COMMITED
READ UNCOMMITED
REPEATABLE READ
SERIALIZABLE
StaticCursorLongColBuffLen: The default size for retrieving sections of LVARBINARY data.
FIX:
References to Written Documentation:
Progress Solutions:
P21252, How to set up and test the ODBC driver on Unix?