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.

-BDF

On Mar 3, 2012 6:19 PM, "Gregor Nanger" <gregor@infomedia.si> wrote:
Hi!

I am using Freeswitch with Windows. I hope I am not the only one. 

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:

[STATE: 42000 CODE 102 ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '|'.
]

Is this know issue? Any suggestions?

On MySQL it is working ok..



_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org