<p>I think that has to do with ymthe specific ODBC driver you are using. I'd check your configs and see of there's anything amiss. I could be wrong though, as I haven't dealt with MSSQL. I have experience with MYSQL and postgres with ODBC though.</p>
<p>-BDF</p>
<div class="gmail_quote">On Mar 3, 2012 6:19 PM, "Gregor Nanger" <<a href="mailto:gregor@infomedia.si">gregor@infomedia.si</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi!<div><br></div><div>I am using Freeswitch with Windows. I hope I am not the only one. </div><div><br></div><div>I also want to make mod_sofia to talk via ODBC with MSSQL. I can connect, but on call I get error, when sofia wants to write to mssql:</div>
<div><br></div><div><div>[STATE: 42000 CODE 102 ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '|'.</div><div>]</div></div><div><br></div><div>Is this know issue? Any suggestions?</div>
<div><br></div><div>On MySQL it is working ok..</div><div><br></div><div><br></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div>