[Freeswitch-users] ODBC ussing Dbh suddenly gives Invalid cursor state error after executing querys

Michael Lutz mytemike72 at gmail.com
Fri Feb 17 15:49:49 MSK 2012


Hi Guys,

I did some more tests, I found the issue, it is only when I execute
querys (actually in my case stored procedures) who dont result
anything. (I use SP's to update my data)
When I have my SP return just a dummy record with 'OK' there is no
error. Still in my previous build this was not needed, it is a new
'feature' ... ;-)

Regards,
Mike.

2012/2/16 Anthony Minessale <anthony.minessale at gmail.com>:
> can you try latest again?
>
>
>
> On Thu, Feb 16, 2012 at 10:33 AM, Chad Phillips <chad at apartmentlines.com> wrote:
>> i'm only one commit behind current head, and this works perfectly for me:
>>
>> local dbh = freeswitch.Dbh("test")
>> dbh:query("SELECT id, name FROM test LIMIT 2", function(row)
>>   freeswitch.consoleLog("INFO", string.format("%5s : %s\n", row.id,
>> row.name))
>> end)
>>
>> unixODBC/MySQL
>>
>> chad
>>
>> On Thursday, February 16, 2012 at 7:48 AM, Michael Lutz wrote:
>>
>> Hi,
>>
>> I just compiled the latest version on x64 and running it. Now suddenly
>> al my queries log an error, even though they are executed correctly.
>> Has something changed? I use the Dbh to connect via my system dsn to
>> MSSql server.
>>
>> The exect error is:
>> [STATE: 24000 CODE 0 ERROR: [Microsoft][ODBC SQL Server Driver]Invalid
>> cursor state
>> ]
>>
>> The log doesn't show anything else.
>>
>> Thanks,
>> Mike.
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.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
>>
>
>
>
> --
> Anthony Minessale II
>
> FreeSWITCH http://www.freeswitch.org/
> ClueCon http://www.cluecon.com/
> Twitter: http://twitter.com/FreeSWITCH_wire
>
> AIM: anthm
> MSN:anthony_minessale at hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> googletalk:conf+888 at conference.freeswitch.org
> pstn:+19193869900
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.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



Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list