[Freeswitch-users] mod_lcr with mssql backend

[Guillermo Ruiz Camauer]

Yes, I have ODBC working on my FS box, and I have updated the lcr.conf.xml
file with the DSN.
The problem is that when I load the module I get errors like:

2016-10-06 15:35:35.560192 [ERR] switch_odbc.c:522 ERR: [SELECT codec FROM
carrier_gateway LIMIT 1]
[STATE: 42000 CODE 102 ERROR: [Microsoft][ODBC Driver 13 for SQL
Server][SQL Server]Incorrect syntax near '1'.
]
2016-10-06 15:35:35.560212 [ERR] switch_core_sqldb.c:587 ODBC SQL ERR
[STATE: 42000 CODE 102 ERROR: [Microsoft][ODBC Driver 13 for SQL
Server][SQL Server]Incorrect syntax near '1'.
]
SELECT codec FROM carrier_gateway LIMIT 1

MSSQL doesn't accept "LIMIT 1".  The equivalent syntax would be "SELECT top
1 codec FROM carrier_gateway".

I was wondering if I will have to make a custum version of mod_lcr (which I
must then maintain), or if there is some setting that I am not seeing to
make it compatible with MS SQL.
If anybody has gone down this road,  would like some feedback.

Thanks!

On Fri, Oct 7, 2016 at 8:12 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> You can probably just use odbc, have you tried that?
> ᐧ
>
> On Sat, Oct 8, 2016 at 1:10 AM, Guillermo Ruiz Camauer <
> grcamauer at gmail.com> wrote:
>
>> Does anyone have mod_lcr running against a MSSQL database through ODBC?
>> What modifications did you have to make?
>>
>> --
>> Guillermo Ruiz Camauer
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>



-- 
Guillermo Ruiz Camauer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20161007/bffdf4f7/attachment-0001.html