0 Replies Latest reply: Sep 27, 2012 8:39 AM by 964789 RSS

    oracle 11 + unixODBC - cannot find valid attributes for odbc.ini

      i am trying to write asterisk's cdr into Oracle Database 11g Release - 64bit Production.
      sqlplus and isql works fine, but when * writes cdr, it gives an error.
      i've enabled odbc tracing and have received that:
      Statement = 0x46fb0d0
      SQL = [INSERT INTO intercdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,a...][length = 224 (SQL_NTS)]
      DIAG [HYC00] [Oracle][ODBC][Ora]Optional feature not implemented.

      here http://www.easysoft.com/developer/interfaces/odbc/sqlstate_status_return_codes.html
      i've found, what does it mean:

      SQLExecDirect, SQLExecute

      The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the driver or data source.

      The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE, and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the driver does not support bookmarks.

      i understand, that i must set some attributes in odbc.ini, but i don't know, which attributes are necessary to change.

      now my odbc.ini looks so:

      Driver = ora10odbc
      DSN = ora5
      ServerName = //newora/ORA5
      UserID = asterisk
      Password = asterisk

      I have many works with pg, but no expirience with oracle.
      Please, can you help me or give me a point of search?
      hope very much for your help!
      thanks in advance.