To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74531 Issue #|74531 Summary|Actual Technologies ODBC driver throws error when acce |ssing tables Component|Database access Version|OOo 2.1 Platform|Macintosh URL| OS/Version|Mac OS X Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|wurzel
------- Additional comments from [EMAIL PROTECTED] Wed Feb 14 10:50:29 +0000 2007 ------- Platform : MacIntel Tiger, latest security fixes Driver : ODBC driver from Actual Technologies for MacOSX (www.actualtechnologies.com) Remote DB : mysql I downloaded, installed and configured the ODBC drivers on a MacIntel Tiger to access a remote MySQL database. The connection test from within the installer worked fine. I then tried to set up an ODBC datasource document from within OpenOffice.org. This worked and I can see the list of tables when I click on the Tables icon button on the left hand side of the ODB document pane, However, if you double-click on any given table to open it and display its contents (equivalent to the SQL instruction : SELECT * from Table1), or if you attempt to execute a query directly on the table, via the Query button (native SQL or SQL View), even if you limit the responses to 3 (since this is an automatic limitation of the demonstration period driver, this shouldn't be necessary, but I did the test anyway), the following error message is displayed : Driver does not support this function XRow::getLong When you click on the error message window, the table window will then display, but no data is available. I have contacted Actual Technologies and they have confirmed that this problem exists with their driver in OOo 2.1, but not in the OOo 2.0.x branch, which means that something somewhere got broken in the OOo development, or that the driver was making a call that was tolerated in the 2.0.x branch and which now throws an error. It would be nice if this could be sorted, since at present there appears to be no means of connecting a MacIntel to a remote mysql db. Alex --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]