Microsoft KB Archive/192518

= PRB: SQL OLE DB Provider Fails When Selected in OLE DB Wizard =

Article ID: 192518

Article Last Modified on 7/21/2001

-

APPLIES TO


 * Microsoft Visual C++ 6.0 Enterprise Edition

-



This article was previously published under Q192518



SYMPTOMS
A dialog box with the message "Could not find any table or procedure information" appears when the SQL OLE DB Provider is used in the OLE DB Consumer Wizard.



CAUSE
As mentioned in the Visual C++ readme file, the SQL OLE DB Provider requires that the new Instcat.sql file be executed in ISQL/W. This SQL script updates catalog-stored procedures on the SQL Server. This is a problem only on SQL Server 6.5 and earlier versions.



RESOLUTION
Start SQL Server's ISQL/W program and open the Instcat.sql file. The file is located in the Windows system directory (for example, :\winnt\system32). Execute the file.



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) In the Visual C++ environment, create a new MFC Dialog application.
 * 2) On the Insert menu, click New ATL Object.
 * 3) Select Data Access.
 * 4) Select Consumer, and click Next.
 * 5) Click Select DataSource.
 * 6) Select "Microsoft OLE DB Provider for SQL Server."
 * 7) Type in the server name, user ID, Password, and database.
 * 8) Click OK.

RESULTS: You will see the dialog box with the error message.

Additional query words: kbDSupport

Keywords: kberrmsg kbprb kbmdacnosweep KB192518

-

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

© Microsoft Corporation. All rights reserved.