<div>I'm currently using Asterisk running version 1.2.5 and trying to use cdr_odbc to connect to a Microsoft SQL database. I have everything running, but the insert statement being sent to database doesn't appear to have the "start, answer, end" information in it.
</div>
<div> </div>
<div>Below is the insert statement that MS Profiler shows being sent. As you can see those fields are missing. </div>
<div> </div>
<div>INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14)</div>
<div> </div>
<div>Here is the record that shows up in cdr-csv</div>
<div> </div>
<div>"","4718","2599576","default","""Asterisk2"" <4718>","SIP/4718-af52","IAX2/visioniax-1","Dial","<a href="mailto:IAX2/visioniax/2599576@default","2006-03-29">
IAX2/visioniax/2599576@default","2006-03-29</a> 10:29:23","2006-03-29 10:29:25","2006-03-29 10:29:34",11,9,"ANSWERED","DOCUMENTATION"</div>
<div> </div>
<div>that record looks fine. </div>
<div> </div>
<div>Please let me know if I'm missing anything here.</div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div>-Brian</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>