Author Topic: Connecting to Asterisk using ODBC (recommended)  (Read 19590 times)

Administrator

  • Administrator
  • Super User
  • *****
  • Offline Offline
  • Posts: 171
    • View Profile
Connecting to Asterisk using ODBC (recommended)
« on: August 02, 2006, 03:10:51 PM »
We now recommend connectivity to Asterisk using our ODBC connectivity method.

The process is fully explained in the new CAM Startup and Installation guide found in our download page:

http://www.callaccounting.ws/download.htm


munozj

  • Newbie
  • *
  • Offline Offline
  • Posts: 4
    • View Profile
Re: Connecting to Asterisk using ODBC (recommended)
« Reply #1 on: September 13, 2013, 11:04:50 AM »
trying to use the ODBC but getting an error when i save the settings
near "?":syntax error

the SQL statement it's trying to use is
select date_add(calldate, interval duration second) as callend, cdr.* from cdr where date_add(calldate, interval duration second)>'?' order by callend asc

i had to load the old 3.51 odbc driver from mysql.com

can't tell what i'm doing wrong in the syntax