The default behavior of the ODBTP Win32 service can be changed according to
configuration parameter settings specified in the odbtpsrv.ini
file.
The available parameters are listed and described below in the table.
Configuration changes will not take effect until the service is restarted with
the commang odbtpctl restart
or the Service Control Manager.
Parameter | Description |
LogFile | Location and name of access/error log file. Default: odbtpsrv.log |
EnableLog | Enable or disable logging. Value can either be 1 (enabled) or 0 (disabled). Default: 1 |
LogReadAndSent | Log read and sent ODBTP codes. Value can either be 1 (enabled) or 0 (disabled). Default: 0 |
LogODBC | Log ODBC info and error messages. Value can either be 1 (enabled) or 0 (disabled). Default: 0 |
Port | Server TCP port. Default: 2799 |
ListenBacklog | Size of listener socket backlog. Default: 32 |
MaxClientThreads | Maximum simultaneous client threads. Default: 256 |
MaxActiveClientThreads | Maximum simultaneous active client threads. Default: 32 |
ClientThreadWaitTimeout | Maximum time in seconds a client thread will wait to become active. Default: 60 |
ReadTimeout | Client socket read timeout in seconds. Default: 180 |
TransBufferSize | Packet transfer buffer size in bytes. Default: 4096 |
MaxRequestSize | Maximum client data request size in bytes. Default: 2000000 |
ConnPoolSize | Normal connection pool size. Default: 32 |
ConnPoolTimeout | Normal connection pool timeout in seconds. Default: 300 |
ReservConnPoolSize | Reserved connection pool size. Default: 24 |
ReservConnPoolTimeout | Reserved connection pool timeout in seconds. Default: 3600 |
BadConnCheck | Enable or disable bad connection check. Value is either 1 (enabled) or 0 (disabled). Default: 0 |
MaxQrysPerConn | Maximum number of query handles per connection. Default: 4 |
ConnectTimeout | Database connection timeout in seconds. Default: 0 |
QueryTimeout | Database query timeout in seconds. Default: 0 |
FetchRowCount | Number of rows to send per non-cursor FETCHROW requests. Default: 64 |
EnableProcCache | Enable or disable prepared procedure parameter cache. Value is either 1 (enabled) or 0 (disabled). Default: 0 |