Save As Fails When Specifying a Different SQL Server Database

 Last reviewed: December 18, 1995
Article ID: Q71076

SUMMARY

Attempting to save a table to a SQL Server database other than the current database will result in the following error message in Q+E version 3.00: 

   Invalid object name 'database.owner.table_name'
The table will be created but will be empty. This feature works correctly in Q+E version 2.50.

MORE INFORMATION

Steps to Reproduce Problem

  1. Start Q+E and log on to a SQL Server.

  2. Open the example file ADDR.DBF from your Q+E subdirectory.

  3. From the File menu, choose Open and Select SQLServer as the Source.

  4. Select the Master database and then choose Cancel.

  5. From the File menu, choose Save As and select SQLServer as the Destination. Verify that the line under the Destination list box reads "Owner is master.owner" where "owner" is the alias that you used when logging on.

  6. Enter "pubs.dbo.xyz" (without the quotation marks) in the File Name dialog box.

  7. You will get the message "Invalid object name: 'dbo.xyz.'"

  8. Choose Cancel and then choose Open from the File menu.

  9. Select the table "xyz" from the Pubs database.

  10. The table will not contain any records.

Work Around

  1. From the File menu, choose Save As.

  2. Select the database to which you want to save.

  3. Choose Cancel and choose Save As from the File menu.

  4. The database you chose will now be the default destination.

Microsoft is researching this problem and will post new information here as it becomes available.

KBCategory: kbother
KBSubcategory:

Additional reference words: noupd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 18, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.