ODBC Search v12.5

[jms]

I am trying to configure the ODBC Search function in v12.5.

The ODBC Test tool works fine after including the user name and password in the Connection String and writing an SQL Query that removes spaces and parentheses and hyphens from the phone number string.

When I configure the ODBC Search page in the Management Console, I get a dialog box with the title "3CX Interface" and the message "Rate value is invalid".

Where do I configure the Rate value, and what are valid values?

 

[jms]

This fixed now.

3CX v 12 is happy with a rate of 0.04 for my calls to NZ in Settings>Advanced>Billing Information.

After upgrade to v12.5, it gives the above described error on several of the pages in Settings>Advanced, including the ODBC page.

My calls to NZ cost $0.04/minute. Seemed like the logical value to put in there.

If I change that rate to 1.0, the error goes away.

Go figure.