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

16 Feb 2012

      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.

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

Chad Phillips