Does AcuXDBC 9.1 64-bit support connection pooling

[Migrated content. Thread originally posted on 22 December 2011]

I received the following error: Description: "OLE DB provider "MSDASQL" for linked server "PAMS006" returned message "[TOD][ODBC][GENESIS]VISION: Read timeout".

By default, the AcuXDBC setup program does not set Connection Pooling. I do not know if this means that the "extend9 AcuXDBC (64-bit)" driver does or does NOT support "Connection Pooling"? If it does, then perhaps setting this and a "Pooling Timeout" would reduce the likelihood of the error above?

I believe the answer is no, Acu XDBC does NOT support Connection Pooling. When I look at the advanced features, I do not see a setting for allowing Connection Pooling. If you contact Customer Care you can raise this as an enhancement request.

[Migrated content. Thread originally posted on 22 December 2011]

I received the following error: Description: "OLE DB provider "MSDASQL" for linked server "PAMS006" returned message "[TOD][ODBC][GENESIS]VISION: Read timeout".

By default, the AcuXDBC setup program does not set Connection Pooling. I do not know if this means that the "extend9 AcuXDBC (64-bit)" driver does or does NOT support "Connection Pooling"? If it does, then perhaps setting this and a "Pooling Timeout" would reduce the likelihood of the error above?

Aside from using connection pooling to avoid timeouts, why would I get a "Read Timeout" error considering the following (notice the read_timeout setting and notes about default behavior):

# net.ini file, used by AcuXDBC Server for client-side
# configuration settings. Note that the information
# in the DSN takes precedence over the settings here.

# This number must match the one given with
# the -k option when AcuXDBC Server is started.
# It is used to encrypt the user ID and password
# information over the network.
#key_connect 1234

# Comma-delimited list of environment variable(s) to set on the host.
#hostenv0

# Size (in bytes) of the buffer used to aggregate send operations.
#packetsize 8192

# Time to wait for read completion. The default of 0 (zero) means no timeout.
#read_timeout 0

# Time to wait for a write completion. The default of 0 (zero) means no timeout.
#write_timeout 0

# Return the OS error code for a communication error.
#return_errno no

[Migrated content. Thread originally posted on 22 December 2011]

I received the following error: Description: "OLE DB provider "MSDASQL" for linked server "PAMS006" returned message "[TOD][ODBC][GENESIS]VISION: Read timeout".

By default, the AcuXDBC setup program does not set Connection Pooling. I do not know if this means that the "extend9 AcuXDBC (64-bit)" driver does or does NOT support "Connection Pooling"? If it does, then perhaps setting this and a "Pooling Timeout" would reduce the likelihood of the error above?

Aside from using connection pooling to avoid timeouts, why would I get a "Read Timeout" error considering the following (notice the read_timeout setting and notes about default behavior):

# net.ini file, used by AcuXDBC Server for client-side
# configuration settings. Note that the information
# in the DSN takes precedence over the settings here.

# This number must match the one given with
# the -k option when AcuXDBC Server is started.
# It is used to encrypt the user ID and password
# information over the network.
#key_connect 1234

# Comma-delimited list of environment variable(s) to set on the host.
#hostenv0

# Size (in bytes) of the buffer used to aggregate send operations.
#packetsize 8192

# Time to wait for read completion. The default of 0 (zero) means no timeout.
#read_timeout 0

# Time to wait for a write completion. The default of 0 (zero) means no timeout.
#write_timeout 0

# Return the OS error code for a communication error.
#return_errno no

[Migrated content. Thread originally posted on 22 December 2011]

I received the following error: Description: "OLE DB provider "MSDASQL" for linked server "PAMS006" returned message "[TOD][ODBC][GENESIS]VISION: Read timeout".

By default, the AcuXDBC setup program does not set Connection Pooling. I do not know if this means that the "extend9 AcuXDBC (64-bit)" driver does or does NOT support "Connection Pooling"? If it does, then perhaps setting this and a "Pooling Timeout" would reduce the likelihood of the error above?

I don't know what would cause a VISION: Read timeout it might be best to contact Customer Care and see if they have run across this issue before.

[Migrated content. Thread originally posted on 22 December 2011]

I received the following error: Description: "OLE DB provider "MSDASQL" for linked server "PAMS006" returned message "[TOD][ODBC][GENESIS]VISION: Read timeout".

By default, the AcuXDBC setup program does not set Connection Pooling. I do not know if this means that the "extend9 AcuXDBC (64-bit)" driver does or does NOT support "Connection Pooling"? If it does, then perhaps setting this and a "Pooling Timeout" would reduce the likelihood of the error above?

AcuXDBC Server configuration default is no timeout for read and write. If you have set the READ_TIMEOUT config then try to increase it.

[Migrated content. Thread originally posted on 22 December 2011]

I received the following error: Description: "OLE DB provider "MSDASQL" for linked server "PAMS006" returned message "[TOD][ODBC][GENESIS]VISION: Read timeout".

By default, the AcuXDBC setup program does not set Connection Pooling. I do not know if this means that the "extend9 AcuXDBC (64-bit)" driver does or does NOT support "Connection Pooling"? If it does, then perhaps setting this and a "Pooling Timeout" would reduce the likelihood of the error above?

You might also try setting up a log file, that may provide some additional information.