<div>Hi Dmitry,</div>
<div> </div>
<div>just to answer your questions, and telling you what I've done so far,</div>
<div> </div>
<div>1) yes, using FreeTDS</div>
<div>2) yes, configured unixODBC with FreeTDS to talk to MSSQL. I have all of this working where I can load and update tables in MSSQL using the "realtime load/update" statements from the Asterisk CLI. </div>
<div>3) I have downloaded and patched the files apps/voicemail.c, res/res_config_odbc.c and include/asterisk/res_odbc.h (FYI: during patching the last file, it did say that the patch terminated unexpectedly in the middle of the line even and then followed by saying Hunk #24 succceeded)
</div>
<div> </div>
<div>4) rebuilt and reinstalled Asterisk <a href="http://1.2.9.1">1.2.9.1</a><br>5) added pooled and poolsize lines to res_odbc.conf and also added "Pooling = Yes" and "CPTimeout = 120" in the odbcinst.ini
as per instructions on the FreeTDS site.</div>
<div> </div>
<div>Is this all I need to do to fix the problems you've seen in Asterisk talking to MSSQL? Is there anything else I should know?</div>
<div> </div>
<div>Also, do you have any idea why I can't seem to load any content from my MSSQL database when I use a "view" instead of a "table"? when I use a table for vmusers for e.g. then it works but it doens't when I sue a view.
</div>
<div> </div>
<div>Thanks</div>
<div>\R<br> </div>
<div><span class="gmail_quote">On 7/3/06, <b class="gmail_sendername">Dmitry Furmanov</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:D.Furmanov@ua.fm" target="_blank">D.Furmanov@ua.fm</a>> wrote:
</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br>Ok, you use the MS SQL. It's problem of FreeTDS implementation details.<br><br>1. Did you install FreeTDS or other ODBC driver to MS SQL(Sybase)
<br>connecting?<br><br>2. Did you configure unixODBC to use freeTDS driver (etc\odbc.ini,<br>etc\odbcinst.ini)?<br><br>3. APPLY the patch that I tell you before<br>( <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://bugs.digium.com/view.php?id=7451" target="_blank">
http://bugs.digium.com/view.php?id=7451 </a>)<br><br>4. Rebuild and reinstall the Asterisk<br><br>Then asterisk will be be able to react on the ODBC configuration<br>parameters "pooled" and "poolsize".
<br><br>Regards,<br>Dmitry V.Furmanov</blockquote></div>