Tables in SQL Data Sources Not Present in Add Tables Dialog Box

• Microsoft Query for Windows, version 1.0

SYMPTOMS

In Microsoft Query, you can select tables to view from the Add Tables dialog box after you select a data source. However, tables in an SQL data source, such as an SQL Server or a Sybase database, may not appear in the list of tables under certain conditions.

CAUSE

SQL tables may not be visible if you use a login id that has been added as an alias to the database and the name of the database contains one or more underscores.

RESOLUTION

To avoid this problem, do not add the user's login as an alias to a database (you may need the database System Administrator to make this change). Also, avoid using underscores in the database name.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft SQL Server ODBC driver, versions 1.0 and 2.0 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

NOTE: To access data in SQL Server with the Microsoft SQL Server driver, you must have versions of Microsoft SQL Server up to 4.2x or Sybase SQL Server versions 4.2.

Another possible reason for this behavior is that the option to display tables from a data source has not been selected. To verify that tables should be displayed, choose the Options button in the Add Tables dialog box. The Table Options dialog box will be displayed. Make sure the Tables check box is selected, and choose OK. If the tables still do not appear, you may be experiencing the problem stated above.

For more information about the Microsoft SQL Server ODBC driver, search for "hardware requirements" or "software requirements" in the DRVSSRVR.HLP file located in the WINDOWS\SYSTEM directory.

Additional query words: 4.x 4.2 4.21 NT sqlserver MSQuery

Keywords : xlquery
Version : WINDOWS:1.0
Platform : WINDOWS
Issue type :