To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108629 Issue #|108629 Summary|Open Office Base 3.1.1 and MySQL ODBC 5.01.06.00 Drive |r (64-bit) Component|Database access Version|OOo 3.1.1 Platform|Opteron/x86_64 URL|http://user.services.openoffice.org/en/forum/viewtopic |.php?f=13&t=26803&p=121935#p121935 OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|leeand00
------- Additional comments from leean...@openoffice.org Sun Jan 24 22:14:57 +0000 2010 ------- I have a MySQL ODBC connection that I setup as a User DSN and have gotten it to connect successfully according to the ODBC Data Source Administrator. When I click the "Test" button on the User DSN configuration it says that the connection was successful. However! When I go try to make the connection in Open Office Base 3.1.1 (Edit->Database->Database Properties, Advanced Properties, Browse button), although the User DSN that I have setup shows up in the list, and I can test it, the connection test fails and I get the following error message: Connection Test The Connection Could not be established. I'm using a 64-bit system running Windows Vista. Is there any reason why this doesn't work? I'm sure I have the right password, as I got the connection to be successful in the "ODBC Data Source Administrator", and it said the connection was successful there but not in OOo. I asked the question here: http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=26803&p=121935#p121935 I also asked the question here: http://superuser.com/questions/99784/getting-open-office-base-3-1-1-and-mysql-odbc-5-01-06-00-driver-64-bit-working The conclusion that the board moderator came to on the first link was that OOo Base doesn't support the 64-bit version of the MySQL ODBC driver. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org