Microsoft KB Archive/194000

= BUG: 'Unspecified Error' When Using SQLOLEDB Provider =

Article ID: 194000

Article Last Modified on 3/16/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q194000



SYMPTOMS
When you use Query Designer to build a SQL query in Visual InterDev 6.0, the following error might occur when you drag a table from the Data View to the design surface. This occurs only when the data connection is to SQL Server 6.5 using the SQLOLEDB Provider:

Query Designer encountered an MS Design Tools error: unspecified error

However, the problem does not occur when you drag the table into the Query Designer a second time.



CAUSE
The SQLOLEDB data connection to SQL Server causes the previous error to occur if the SQL Server 6.5 database has not been upgraded with a newer version of instcat.sql. Run the following SQL query with the SQL Server query tool to find out whether or not the latest version of instcat.sql is present: SELECT attribute_value FROM master.dbo.spt_server_info WHERE attribute_name = 'SYS_SPROC_VERSION' If the query returns a string such as "6.50.xxx", where xxx is the version of the SQLOLEDB driver, SQL Server has to be updated with the latest version of instcat.sql.

If the query returns a string such as "7.00.xxx", where xxx is the version of the SQLOLEDB driver, SQL Server has already been updated with the latest version of instcat.sql.



RESOLUTION
Run instcat.sql on the SQL Server using the Query tool from the SQL Server Enterprise Manager. The SQL query file instcat.sql can be found in the \OS\SYSTEM subdirectory on Visual Studio Disc 1.



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



Steps to Reproduce Behavior

 * 1) Open a new Web project in Visual InterDev 6.0
 * 2) Add a data connection to a SQL Server database.
 * 3) Change the data connection properties to "Use Connection String" from "Use ODBC Data Source Name". Then click Build and choose "Microsoft OLEDB Provider for SQL Server" as the provider. Complete the rest of the connection parameters.
 * 4) Add an ASP page to the project and add a Recordset DTC to the page.
 * 5) Open the Query Builder from the Recordset DTC by choosing SQL Statement in the Recordset DTC's properties and clicking SQL Builder.
 * 6) Drag a table from the Data View to the design surface of the Query builder.

Keywords: kberrmsg kbbug KB194000

-

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

© Microsoft Corporation. All rights reserved.