# res\_odbc problems

**URL:** <https://community.asterisk.org/t/res-odbc-problems/19236>\
**Category:** Asterisk Support\
**Created:** [February 16, 2008, 8:47am UTC](https://community.asterisk.org/t/res-odbc-problems/19236 "2008-02-16T08:47:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kennygood](https://avatars.discourse-cdn.com/v4/letter/k/ac8455/32.png) [@kennygood](https://community.asterisk.org/u/kennygood)\
**Post date:** [February 16, 2008, 8:47am UTC](https://community.asterisk.org/t/res-odbc-problems/19236/1 "2008-02-16T08:47:21Z")

</div>

I am develeping a SIP Phone system.  
Asterisk 1.4+ unixodb +MS SQL realtime  
users management;call rates;pre-paid;etc  
but I found sometimes,when I invite  
Asterisk will display '403’  
and below:  
Feb 16 14:51:50 WARNING[13534] res\_config\_odbc.c: SQL Prepare failed![proc\_INVITE\_Auth\_new ‘68681006’,‘9991000’,7,‘SIP’] and Error in PREPARE -1  
Feb 16 14:51:50 WARNING[13534] res\_config\_odbc.c: The driver reported the following diagnostics whilst running

So I type ‘odbc show’ in CLI,and astersik start to re-connect MSSQL by UNIXODBC

Any help?