This is sql that is generated:<div><div>select sip_registrations.sip_user, sip_registrations.sub_host, sip_registrations.status, sip_registrations.rpid, '', sip_dialogs.uuid, sip_dialogs.state, sip_dialogs.direction, sip_dialogs.sip_to_user, sip_dialogs.sip_to_host,sip_presence.status,sip_presence.rpid,sip_dialogs.presence_id, sip_pre</div>
<div>sence.open_closed,'','','' from sip_registrations left join sip_dialogs on sip_dialogs.hostname = sip_registrations.host</div><div>name and sip_dialogs.profile_name = sip_registrations.profile_name and (sip_dialogs.presence_id = sip_registrations.sip_</div>
<div>user || '@' || sip_registrations.sub_host or (sip_dialogs.sip_from_user = sip_registrations.sip_user and sip_dialogs.sip</div><div>_from_host = sip_registrations.sip_host)) left join sip_presence on sip_presence.hostname=sip_registrations.hostname and</div>
<div> (sip_registrations.sip_user=sip_presence.sip_user and sip_registrations.orig_server_host=sip_presence.sip_host and sip_</div><div>registrations.profile_name=sip_presence.profile_name) where sip_registrations.hostname='WIN-SERVER2008' and sip_registra</div>
<div>tions.profile_name='internal' and sip_dialogs.call_info_state != 'seized' and sip_dialogs.presence_id='<a href="mailto:1002@192.168.1.">1002@192.168.1.</a></div><div>150' or (sip_registrations.sip_user='1002' and (sip_registrations.orig_server_host='192.168.1.150' or sip_registration</div>
<div>s.sub_host='192.168.1.150' ))]</div><div>[STATE: 42000 CODE 102 ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '|'.</div><div id="WISESTAMP_SIG_5036"><div style="font-size:13.3px;font-family:Verdana,Arial,Helvetica,sans-serif">
<img src="https://wisestamp.appspot.com/pixel.png?p=chrome&v=3.11.16.0&t=1330820224187&u=2cae5e430c4ca423" width="1" height="1"><br></div></div><div><br></div>But in source code it is: </div><div>"sip_dialogs.presence_id = sip_registrations.sip_user %q '@' %q sip_registrations.sub_host "</div>
<div><br></div><div>It looks like parameters are not inserted at runtime...</div><div><br></div><div>What do you think?</div><div><br><br><div class="gmail_quote">2012/3/4 Brian Foster <span dir="ltr"><<a href="mailto:bdfoster@endigotech.com">bdfoster@endigotech.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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"><div><div class="h5">On Mar 3, 2012 6:19 PM, "Gregor Nanger" <<a href="mailto:gregor@infomedia.si" target="_blank">gregor@infomedia.si</a>> wrote:<br type="attribution"></div></div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
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></div></div>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">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" target="_blank">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>
<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><br></div>