The following tables describe all parameters that can be used in a connection string. The sample programs use “localhost”. Removes idle connections from all connection pools. Clears the connection pool associated with connection conn. The connection object can be opened and closed as necessary. Recycles connections in the pool associated with connection object conn. CachePoolManager class can be used to monitor and control connection pooling programmatically.

Uploader: Yozshukree
Date Added: 28 May 2018
File Size: 6.96 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 21910
Price: Free* [*Free Regsitration Required]

ODBC Error with Cache DB

Thanks, but it is this document I am quoting above. Very little configuration is required to use a. For example, the following connect string sets the initial size of the connection pool to 2 and the maximum number of connections to 5, and activates connection reset with a maximum connection idle time of 3 seconds:.

Connection pooling is on by default.

In the User Name box, type the user name of the desktop user account. Message 1 of 13 2, Views. Sets the TCP nodelay option. Message 6 of 13 2, Views. The cadhe example could be rewritten as follows:.

Sets the TCP send buffer size. If you select “dSkillsetstat” in excel using the 6. Basically; Cache introduced stricter enforcement of ODBC standard requiring reserved word to be quoted.


Check the following points if you have any problems:. Integrations with Files and Services: I am able to see the tables however when I select one of the tables to actually view the data, I am getting the following error. Problem Clarification Custom reports will not retrieve data for the “time” field. Maximum size of connection pool for this specific connection string.

ACCS Database Integration Report ERROR – ODBC – Avaya Support Forums

Details Custom reports will not retrieve data for the “time” field. I appreciate any assistance you can provide.

Turns on logging and sets the log file location. No relevant change to AACC was made We did not change the database to make this fail, but oebc testing, we can see that the DB vendor Intersystems are using stricter ODBC compliance when reserved words are used in the new agaya version. And that was added to the view definition, however that is not the change that introduced the issue. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.


Count includes both idle and in-use connections. Auckland, New Zealand Posts: ODBC has always required reserved word Time to be enclosed in double quotes. This document is a little vague or inaccurate in this regard and I would appreciate any help in interpretting what is actually required. Use pursuant to the terms of your signed agreement or Avaya policy. Excel fails to quote reserved words, and that is a requirement of the ODBC standard.

Default is 0 use system default value alternate name: Message 8 of 13 2, Views.

AACC\ACCS 7.X Custom reports will not retrieve data for the “time” field in MS excel

Find all posts by stphnwd. Sorry for being a newbie.

Total number of idle connections in all the pools. In the Name box, enter the required name of the DSN. The following connection string parameters can be used to control various aspects of connection pooling:. Thanks for your help.

Back to Top