[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: "no cursor name available" error
From:       Venu <venu () mysql ! com>
Date:       2001-09-25 23:21:20
[Download RAW message or body]

Hi Eric !!!

> -----Original Message-----
> From: Eric Cozzi [mailto:ecozzi@telverse.com]
> Sent: Tuesday, September 25, 2001 2:57 PM
> To: myodbc@lists.mysql.com
> Subject: FW: "no cursor name available" error
>
>
> Hi All,
>
> I am developing an application using MyODBC under Win2k to a linux based
> MySQL server. On my development machine, everything works fine. But, on
> two different release machines, I am getting a "no cursor name
> available" error when I call delete on my recordset object. I have
> checked DLL versions, ODBC versions, upgraded to .39 of MyODBC, changed
> my code around, verified user and table permissions on MySql and nothing
> works. As one final test, I switched out the MyODBC -> MySQL backend for
> an ODBC -> Access MDB Backend. In this configuration, everything works
> fine. I am starting to believe that the problem is either in the MyODBC
> layer or MySQL itself.
>
> I have uploaded both my test application (and source code) and a MyODBC
> trace to http://eric.cozzi.net/myodbc/. The delete operation on line 109
> of TestDlg.cpp throws a DBException, which is caught in the CATCH block
> just below the delete call. Can anyone help me figure out what's going
> on?
>

We had a discussion on the same issue couple of weeks back, you can tale
llok at them from odbc list (http://lists.mysql.com).

Also, download the driver patch for 2.50.39 version, which does support the
dynamic cursor names, from the following link.
ftp://support.mysql.com/pub/mysql/hidden/myodbc/myodbc-39-win32.zip

And let us know whether it solves your problem or not.

Regards, venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /  Mr. Venu <mailto:venu@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/ California, USA
       <___/ www.mysql.com



---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread3909@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]