MySQL Bugs: #28498: Invalid Cursor State - Using SQL Server 2000 Replication

Bug #28498	Invalid Cursor State - Using SQL Server 2000 Replication
Submitted:	17 May 2007 15:06	Modified:	28 May 2013 8:23
Reporter:	Cristiano Rodrigues	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.15	OS:	Windows (Windows XP)
Assigned to:	Bogdan Degtyariov	CPU Architecture:	Any

Description:
When executing the replication data of the SQL Server 2000 for the MySQL (5.0.41) the same presents an error of “Invalid State Cursor”. This error does not appear in the version of ODBC 3.51.12.

How to repeat:
To create a heterogeneous replication in the SQL Server 2000 for the MySQL being used driver of ODBC 3.51.15. Replicate a table with two integers fields.

Hi Cristiano and thanks for your report.
While we are examining some options can you please try the data transformation service and export MS SQL table into MySQL through MyODBC? Inform me of result.

Hi Tonci Grgin!
Using the DTS the driver functions normally. But in the replication that not! I activated query log of the MySQL to verify the commands that were arriving for the server. I go to annex the archive with my commentaries today.

Cristiano good, waiting for files.

Hi Tonci! 
In annex the archive of querylog. As it goes to see successfully occurred an execution for the creation of the table, but I did not obtain to insert the data, occurring the error of “Invalid cursor location”.

Cristiano, please accept my apologies for late reply. As you noticed, nothing can be said from query log, it just succeeds. I have two things for you to do now:
 1) Upgrade MyODBC to the latest version and try
 2) Provide DM trace log (Control Panel/Administrative tools/Data Sources (ODBC) "Tracing" tab, "Start tracing now".

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I have a problem with driver mysql ODBC for windows 64 btis
I install this driver, version 3.51
mysql-connector-odbc-3.51.30-winx64
and the tables descriptions is incorrect. Show different characters.
the error description is: 
[MySQL][ODBC 3.51 Driver][mysqld-4.0.1-alpha-max]Invalid cursor state

Danilo
danilo.oliveira@astrazeneca.com
can you help me??

Marcelo,

The error message is coming from the MySQL server side.
In your case the server version is 4.0.1 alpha, which is not supported.
Can you try some newer version of MySQL Server such as 5.1 (5.1.65 is
the newest version of 5.1) or 5.5 (5.5.27)?

Also, please try enable the ODBC Tracing: run ODBC Data Source Administrator/Tracing/Start Tracing Now.

NOTE:

   1. Please make sure you are running the correct version of odbcad32.exe
      For 64 bit ODBC Drivers you have to run it from \WINDOWS\System32
      directory. For 32 bit Drivers you should run odbcad32.exe from
      \WINDOWS\SysWow64

   2. The ODBC Tracing should be enabled before starting MS SQL Server
      otherwise you might not get anything written into the log file.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Cannot continue without feedback from the reporter.
The bug is closed.