| 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: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 5 | OS: | Windows (Windows 2000/2003) |
| Assigned to: | Bogdan Degtyariov | CPU Architecture: | Any |
[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.
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>;"