ODBC ussing Dbh suddenly gives Invalid cursor state error after executing querys
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.
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.
can you try latest again? On Thu, Feb 16, 2012 at 10:33 AM, Chad Phillips <chad@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@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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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@gmail.com>:
can you try latest again?
On Thu, Feb 16, 2012 at 10:33 AM, Chad Phillips <chad@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@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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
_________________________________________________________________________ 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
Did you update like anthm suggested? He made a small correction after seeing your email yesterday. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-ussing-Dbh-suddenly-gives... Sent from the freeswitch-users mailing list archive at Nabble.com.
Hi Jeff, No I did not, I actually thought this request was to Chad because he said he didn't have the lastest build. But I will update later and let you know if it is fixed. /Mike. 2012/2/17 Jeff Lenk <jeff@jefflenk.com>:
Did you update like anthm suggested? He made a small correction after seeing your email yesterday.
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-ussing-Dbh-suddenly-gives... Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________ 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
Hi Jeff/Anthony, Just to confirm, I tried latest version and the error is no longer there. Thanks, Mike. 2012/2/17 Michael Lutz <mytemike72@gmail.com>:
Hi Jeff,
No I did not, I actually thought this request was to Chad because he said he didn't have the lastest build. But I will update later and let you know if it is fixed.
/Mike.
2012/2/17 Jeff Lenk <jeff@jefflenk.com>:
Did you update like anthm suggested? He made a small correction after seeing your email yesterday.
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/ODBC-ussing-Dbh-suddenly-gives... Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________ 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
participants (4)
-
Anthony Minessale
-
Chad Phillips
-
Jeff Lenk
-
Michael Lutz