FP2000: No Record Sources or Tables Found When Using an OLEDB Provider for SQL

ID: Q229285

The information in this article applies to:

SYMPTOMS

When you use an OLEDB provider for SQL Server to connect to a SQL Server 6.5 database, the database connection verifies correctly, yet FrontPage does not find any record sources in the Database Results Wizard or in form properties when using Send to Database.

After confirming that the database has tables and data, the Database Results Wizard and Save to Database Form properties still do not recognize the tables and record sources.


CAUSE

If users specify a data connection that uses an OLEDB provider to talk to a SQL Server (version 6.5 or earlier), calls to retrieve schema information do not work until the Instcat.sql script is run on the SQL Server.


RESOLUTION

To work around this problem, a SQL Server administrator needs to run this script before FrontPage can read the information in the SQL database.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

For additional information about ODBC and the Instcat.sql file, please see the following article in the Microsoft Knowledge Base:

Q137636 INF: Relationship of the ODBC Driver to INSTCAT.SQL

Additional query words: front page 


Keywords          : kbdta 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: July 23, 1999