| Bug #22509 | executing a query, one time is correct, next time return null recordset. | ||
|---|---|---|---|
| Submitted: | 20 Sep 2006 8:27 | Modified: | 30 May 2013 7:08 |
| Reporter: | [ name withheld ] | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 3.51.14 | OS: | Any (w2003) |
| Assigned to: | CPU Architecture: | Any | |
[20 Sep 2006 11:35]
Tonci Grgin
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL. Explanation: o Download latest version of connector/ODBC (3.51.14) and test You should attach to this report at least o SQL statements creating used table together with data needed for testing o Complete script/c code you used to reproduce the problem o Expected/retrieved results o The MDAC version (if on Windows) * Download verbose MDAC utility .EXE here http://www.microsoft.com/downloads/info.aspx?na=46&p=9&SrcDisplayLang=en&SrcCategoryId=&Sr... Are you able to repeat the same behavior from mysql command line client?
[20 Sep 2006 14:30]
[ name withheld ]
Myodbc 3.51.14 is estable version?
[20 Sep 2006 20:04]
Tonci Grgin
No and it will not be GA for at least a month or so. What about other data I asked for?
[20 Oct 2006 23:00]
Bugs System
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".
[30 May 2013 7:08]
Bogdan Degtyariov
I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.
Description: i'm use asp and Mysql 5.0 and connector ODBC 3.51.12 executing a elemental query and one time is correct, next time return null recorset. asp code: <% Dim rsconsulta Dim rsconsulta_numRows Set rsconsulta = Server.CreateObject("ADODB.Recordset") rsconsulta.ActiveConnection = application("MM_MyEmpresas_STRING") rsconsulta.Source = "SELECT * FROM publicidad WHERE Id = " + Replace(rsconsulta__MMColParam, "'", "''") + "" rsconsulta.CursorType = 0 rsconsulta.CursorLocation = 2 rsconsulta.LockType = 1 rsconsulta.Open() rsconsulta_numRows = 0 %> How to repeat: ? Suggested fix: problem is database, asp or connector ODBC?