To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95712 Issue #|95712 Summary|Save View to SQL Server 2005 via JDBC returns error Component|Database access Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ecklesj
------- Additional comments from [EMAIL PROTECTED] Fri Oct 31 16:26:21 +0000 2008 ------- OOo Base 3.0.0 OOO300m9 (Build:9358) Connecting to Microsoft SQL Server 2005 9.0.3073 via Microsoft SQL Server JDBC Driver 1.2 with integrated security. If I create a create a View in design mode and then try to save the view, I select the database name for the Catalog value, the schema name for the Schema value, and enter a name for the new view for the Table Name value. When I click OK, Base presents the following error: "'CREATE/ALTER VIEW' does not allow specifying the database name as a prefix to the object name." If I turn off design mode to go to sql mode and click the "Run SQL Command Directly" button, modify the SQL to read Create view "DatabaseName"."SchemaName"."ViewName" as Select afield from mytable and try to run that statement, the same error message is returned. If the database name is removed from the statement, the command runs fine in direct SQL mode. For example, this would work: Create view "SchemaName"."ViewName" as Select afield from mytable I think the ideal solution is to allow there to be no value for Catalog in the Create View statement that Base sends when saving a view in design mode. --------------------------------------------------------------------- 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]
