Re: freetds - invalid cursor state

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAHt6W4e52G1MpRbRs2V=MBM=4kMi+RWevAtMbkzg=zO0yTEfEA@mail.gmail.com>
On 26 Feb 2016 19:00, "James K. Lowden" <[email protected]> wrote:
>
> On Thu, 25 Feb 2016 21:17:15 +0100
> <[email protected]> wrote:
>
> > Both are attached. I would really apreciate if you can take a look at
> > these logs and try to identify the root cause.
>
> Perhaps I'm missing something, but to me it looks like a contradiction.
> In the FreeTDS log, we see,
>
> [ODBC][21590][1456398626.473093][SQLError.c][389]
>                 Exit:[SQL_SUCCESS]
>                         SQLState = 24000
>                         Native = 0x7fff2ad0ec58 -> 0
>                         Message Text = [[FreeTDS][SQL Server]Invalid
> cursor state]
>
>
> SQL_SUCCESS is not an error, so "Invalid cursor state" cannot describe
> the state.  Either the operation succeeded, or it failed because of an
> invalid cursor state.
>

Well... time for a beer I think.
However. Sql error returns the error string for previous function calls. So
it succeeded (returned the error) and error was "Invalid cursor state"

Frediano
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.