Microsoft KB Archive/229285

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

Article ID: 229285

Article Last Modified on 10/1/2001

-

APPLIES TO


 * Microsoft FrontPage 2000 Standard Edition

-



This article was previously published under Q229285



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 that this is a problem in the Microsoft products that are 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:

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

Additional query words: front page

Keywords: kbbug kbpending KB229285

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.