This discussion is archived
0 Replies Latest reply: Sep 27, 2012 6:39 AM by 964789 RSS

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

964789 Newbie
Currently Being Moderated
hello.
i am trying to write asterisk's cdr into Oracle Database 11g Release 11.2.0.3.0 - 64bit Production.
sqlplus and isql works fine, but when * writes cdr, it gives an error.
i've enabled odbc tracing and have received that:
/var/log/odbc.log
[ODBC][17917][SQLExecDirect.c][236]
Entry:
Statement = 0x46fb0d0
SQL = [INSERT INTO intercdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,a...][length = 224 (SQL_NTS)]
[ODBC][17917][SQLExecDirect.c][499]
Exit:[SQL_ERROR]
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:

[o5]
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points