| Bug #13199 | Linked mysql tables in access with file DSN | ||
|---|---|---|---|
| Submitted: | 14 Sep 2005 19:45 | Modified: | 21 Sep 2005 23:08 |
| Reporter: | Ulrich Kretschmer | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
| Version: | 3.51.11 + 3.51.12-beta | OS: | Client: WinXP w/SP2 |
| Assigned to: | Jorge del Conde | CPU Architecture: | Any |
[14 Sep 2005 20:15]
Jorge del Conde
I was unable to reproduce this bug. By the looks of this error message, the problem might lie on your system configuration. Can you reinstall myodbc and try again ? Thanks!
[15 Sep 2005 16:04]
Ulrich Kretschmer
sample ODBC logfile
Attachment: sql.log (text/x-log), 3.79 KiB.
[15 Sep 2005 16:22]
Ulrich Kretschmer
> By the looks of this error message, the problem might lie on your system > configuration. The question (*) is: what's happening behind my back inside the computer, causing the error? > Can you reinstall myodbc and try again ? I did several testings (but all on the same computer). The result was the same in all cases. I believe that the myODBC driver installation is okay, because user-DSN's and system-DSN's are working properly. Some more information - I hope it helps to answer the question (*): 1) I've added a sample ODBC log -> see "files" section. 2) sampe dsn file (worked fine with ODBC 3.51.06 + mySQL server 4.0.13; because of a server change, I've only modified the server name): ------------------------ [ODBC] DRIVER=MySQL ODBC 3.51 Driver UID= STMT= OPTION=3 PORT= PASSWORD= SERVER=ddemuca01123 DATABASE=kti DESC=MySQL-KTI ----------------------------------- 3) server query log: 050825 10:27:49 94 Quit 050825 10:27:54 93 Quit 050826 15:53:02 95 Connect Benutzer 'ODBC'@'ddemuca04349.muc.de.itgr.net' hat keine Zugriffsberechtigung (verwendetes Passwort: Nein) C:\Programme\apachefriends\xampp\mysql\bin\mysqld-nt, Version: 4.1.12-nt-log. started with: TCP Port: 3306, Named Pipe: mysql Time Id Command Argument 050915 8:56:08 1 Connect Benutzer 'ODBC'@'ddemuca04349.muc.de.itgr.net' hat keine Zugriffsberechtigung (verwendetes Passwort: Nein) 050915 9:00:55 2 Connect Benutzer 'ODBC'@'ddemuca04349.muc.de.itgr.net' hat keine Zugriffsberechtigung (verwendetes Passwort: Nein) 050915 9:02:13 3 Connect Benutzer 'ODBC'@'ddemuca04349.muc.de.itgr.net' hat keine Zugriffsberechtigung (verwendetes Passwort: Nein) [translation: user 'ODBC'... has no privileges (used password: no] Note: There is no user 'OBDC' in the database. I have no idea why the ODBC driver tries to connect with a fictious user-id. While trying to create the table link, the connect dialogue (asking for user-id + password) doesn't appear. I get immediately the described error message.
[20 Sep 2005 22:44]
Aaron Edwards
I have the same problem on multiple computers. I have also done a Google search and found tons of reports by people getting the same error message (not eveyone is using Access). Just do a google search for the error, and put the whole thing in quotes. Creating a Machine DSN works fine. Creating a File DSN doesn't work at all, you get this error message. This is with 3.51.11-2 and 3.51.12 Aaron
[6 Oct 2005 20:42]
Kimberly Cheatwood
has anyone found a solution for the File DSN issue when linking to Access database files.
Description: I tried to link a mysql table (Server: 4.1.12) from Access 2002 (with SP3), using a file DSN. The link creation doesn't work. Error message: "ODCB call failed. [MySQL][ODBC 3.51 Driver]Could not find driver {MySQL ODBC 3.51 Driver} in system information. (#0)" Same problem with myODBC 3.51.12-beta. Linking tables with user-DSN or system-DSN works fine! It's only a file-DSN linking problem. Previous configuration which worked fine with file-DSNs: ODBC 3.51.06 + mySQL server 4.0.13 How to repeat: 1) Create a new Access .MDB file. 2) Create a valid file DSN. 3) Try to link a mysql table using the file DSN.