<html><head><style type='text/css'>p { margin: 0; }</style><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body>Thanks Tilghman for the suggestion,<br><br>While reading your mail I immediately understood what went wrong. <br>In my situation the database is MS SQL Server 2000, and I generated the script of the table from an existing table where ODBC CDR is properly working, somehow the script did not generate for a constraint that we added to our Primary Key column, which is a UniqueID to generate new unique id on each insert. After your mail I guessed that this could be the only thing that would be missing. and It was.<br><br>Thanks a lot once again.<br><br>Regards,<br>Sanjay Rajdev<br><br>----- Original Message -----<br>From: "Tilghman Lesher" <tilghman@mail.jeffandtilghman.com><br>To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br>Sent: Saturday, May 31, 2008 12:34:41 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi<br>Subject: Re: [asterisk-users] cdr_odbc not working for some reason<br><br>On Friday 30 May 2008 13:47:48 Sanjay Rajdev wrote:<br>> Here is the output::<br>><br>> localhost*CLI> module unload cdr_odbc.so<br>> == Unregistered 'ODBC' CDR backend<br>><br>> localhost*CLI> module load cdr_odbc.so<br>> == Parsing '/etc/asterisk/cdr_odbc.conf : Found<br>> -- cdr_odbc : dsn is asterisk<br>> -- cdr_odbc : username is asterisk<br>> -- cdr_odbc : password is [secret]<br>> -- cdr_odbc : table is cdr<br>> Loaded cdr_odbc.so => (ODBC CDR Backed)<br>><br>> localhost*CLI><br><br>Okay, then it appears to be connecting, so the most likely<br>cause of no CDRs in the database is that your table layout does<br>not match what cdr_odbc expects. You have two options at this<br>point: either you can make the backend cdr table match what<br>cdr_odbc wants (in terms of fields) or you can use the backport<br>of cdr_adaptive_odbc, which will allow you to adapt the records to<br>your layout, instead of the other way around.<br><br>http://svncommunity.digium.com/view/tilghman/branches/1.4/<br><br>-- <br>Tilghman<br><br>_______________________________________________<br>-- Bandwidth and Colocation Provided by http://www.api-digital.com --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> http://lists.digium.com/mailman/listinfo/asterisk-users<br></body></html>