Bug #19321 Problem while change to v5
Submitted: 25 Apr 2006 6:29 Modified: 13 Dec 2006 1:10
Reporter: Vincent Cheung Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5 OS:Microsoft Windows (Windows 2000/2003)
Assigned to: Bogdan Degtyariov CPU Architecture:Any

[25 Apr 2006 6:29] Vincent Cheung
Description:
My testing programme is using v3.51.12 before.
It connected okay.

After change code to v5 then failed. Is it a new release?

How to repeat:

Original code:
conn.open "DRIVER={MySQL ODBC 3.51 Driver};" & _
          "SERVER=<dbserver>;" & _
          "DATABASE=<dbname>;" & _
          "USER=<dbuserid>;" & _
          "PASSWORD=<dbpassword>;"

Change the top line:
conn.open "DRIVER={MySQL Connector/ODBC v5};" & _
          "SERVER=<dbserver>;" & _
          "DATABASE=<dbname>;" & _
          "USER=<dbuserid>;" & _
          "PASSWORD=<dbpassword>;"
[25 Apr 2006 13:59] Bogdan Degtyariov
Vincent,

could you provide the error message displayed when your program attempts to connect? 
Thanks
[26 Apr 2006 13:09] Vincent Cheung
Please click:
http://202.64.105.10/friendremix/tbupdate2.asp

Microsoft VBScript 執行階段錯誤 錯誤 '800a01fb' 
發生例外情況: 'open' 
/friendremix/tbupdate2.asp, 列47

The line 47 is:
rs.open sqlrs, conn, 1, 3

This link is using 3.51 driver, works fine:
http://202.64.105.10/friendremix/tbupdate.asp
[26 Apr 2006 13:11] Vincent Cheung
Bug#18731 is the original source.
[23 May 2006 1:28] Vincent Cheung
I will never use/test MySQL again.
I rather pay money to use MSSQL / Oracle. Bye Bye.
[24 May 2006 11:49] Bogdan Degtyariov
Vincent,

sorry to disappoint you, but now we have only alpha version of  MySQL Connector/ODBC v.5, therefore it has the problem you mentioned before.
MySQL developers are working on final release of version 5 and I believe this bug will be fixed before final release is ready.
[13 Dec 2006 1:10] Jess Balint
There is not sufficient information here to constitute a real bug.