To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77914 Issue #|77914 Summary|Wizard SQL / Firebird incompatability Component|Database access Version|OOo 2.2 Platform|Other URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rufusg
------- Additional comments from [EMAIL PROTECTED] Wed May 30 06:59:30 +0000 2007 ------- XPSp1 - OOO 2.2 (new d/l & install) - Firebird 1.54 - IB ODBC driver (2 versions) start new database using ODBC query to FB database select tables/fields with wizard When I finish, sql error pops up, INVALID TOKEN "AS" sql window shows statements with SELECT <whatever fields> AS sql being generated apparently has a problem, since Ive done the same thing with the same drivers/database thru ms access with no connection issues. Also, probably related so I'll put it in here, the 3 databases created could not be deleted after closing OOO (files were still open). Reopen/close OOO, no change. Did not reboot, that would have fixed it, as did uninstalling OOO (for now). --------------------------------------------------------------------- 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]