Bug #15784 Reserved error for Access connection trough MyODBC 5
Submitted: 15 Dec 2005 18:23 Modified: 29 Nov 2006 20:13
Reporter: Yuriy Pavlyutkin Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5.0.0 Alpha OS:Windows (Windows 2000 SP4)
Assigned to: CPU Architecture:Any
Tags: ODBC5-RC

[15 Dec 2005 18:23] Yuriy Pavlyutkin 
Description:
MS Access 2000, 2003: Make link to ODBC table using ODBC 5 Connector Data Source:
 
a) There are right authentication data, database is selected by typing or not selected.
 Error message: Reserved error (-7701). Description of this error is absent.

b) Try to connect when there are incorrect authentication data: “ODBC Error. Fail SQLSetConnectAttr of the driver (#0) [(#0) [(#0)“.

How to repeat:
Create DSN for MyODBC 5.
Try to link from Access to MySQL table using this DSN:
a) using right authentication data;
b) using incorrect authentication data.
[2 Mar 2006 20:20] Klaus Talkenberger 
Same Error with WindowsXP and Access 2003, connecting over VB6 -> VB6 where colsed with dump :-(
[29 Nov 2006 20:13] Jess Balint 
Both issues with Access are fixed. Most operations with linking tables work now.