[Asterisk-Dev] problem with cdr_odbc

[Pablo Endres]

I know someone toldme yesturday that the subject was out of line
for this list, but I've checked and the problem is down to dev (src
code).

Oka.. heres what I got until now:
I'm using unixODBC and freetds to go against a M$ SQL Server, the conn y
good I can even see the open conn from asterisk in the 
process list on the server.

The problem comes when the statement is executed.  I pumped up the
verbosity on freetds and found the following log (each time cdr_odbc
tries to write a log)

pid: 30035:Received packet @ 11:02:14.897325
0000 aa 82 00 e9 03 00 00 01-0f 37 00 4c 00 69 00 6e |........ .7.L.i.n|
0010 00 65 00 20 00 31 00 3a-00 20 00 4c 00 65 00 6e |.e. .1.: . .L.e.n|
0020 00 67 00 74 00 68 00 20-00 6f 00 72 00 20 00 70 |.g.t.h.  .o.r. .p|
0030 00 72 00 65 00 63 00 69-00 73 00 69 00 6f 00 6e |.r.e.c.i .s.i.o.n|
0040 00 20 00 73 00 70 00 65-00 63 00 69 00 66 00 69 |. .s.p.e .c.i.f.i|
0050 00 63 00 61 00 74 00 69-00 6f 00 6e 00 20 00 30 |.c.a.t.i .o.n. .0|
0060 00 20 00 69 00 73 00 20-00 69 00 6e 00 76 00 61 |. .i.s.  .i.n.v.a|
0070 00 6c 00 69 00 64 00 2e-00 04 53 00 51 00 4c 00 |.l.i.d.. ..S.Q.L.|
0080 31 00 00 01 00 aa 54 00-89 00 00 00 02 0f 20 00 |1.....T. ...... .|
0090 4d 00 75 00 73 00 74 00-20 00 64 00 65 00 63 00 |M.u.s.t.  .d.e.c.|
00a0 6c 00 61 00 72 00 65 00-20 00 74 00 68 00 65 00 |l.a.r.e.  .t.h.e.|
00b0 20 00 76 00 61 00 72 00-69 00 61 00 62 00 6c 00 | .v.a.r. i.a.b.l.|
00c0 65 00 20 00 27 00 40 00-50 00 31 00 27 00 2e 00 |e. .'. at . P.1.'...|
00d0 04 53 00 51 00 4c 00 31-00 00 01 00 aa 6e 00 f4 |.S.Q.L.1 .....n..|
00e0 1f 00 00 01 10 23 00 53-00 74 00 61 00 74 00 65 |.....#.S .t.a.t.e|
00f0 00 6d 00 65 00 6e 00 74-00 28 00 73 00 29 00 20 |.m.e.n.t .(.s.). |
0100 00 63 00 6f 00 75 00 6c-00 64 00 20 00 6e 00 6f |.c.o.u.l .d. .n.o|
0110 00 74 00 20 00 62 00 65-00 20 00 70 00 72 00 65 |.t. .b.e . .p.r.e|
0120 00 70 00 61 00 72 00 65-00 64 00 2e 00 04 53 00 |.p.a.r.e .d....S.|
0130 51 00 4c 00 31 00 0a 73-00 70 00 5f 00 70 00 72 |Q.L.1..s .p._.p.r|
0140 00 65 00 70 00 61 00 72-00 65 00 01 00 79 f4 1f |.e.p.a.r .e...y..|
0150 00 00 ac 09 00 00 01 38-00 00 00 26 04 00 fe 02 |.......8 ...&....|
0160 00 e0 00 00 00 00 00   -                        |.......|

I checked the code on cdr_odbc, but it seems to be setting the value in
the prepared statement.  

Any ideas on what could be wrong?



-- 
Pablo Endres <epablo at comvoz.com>
ComVoz Comunications