BUG: 'Unspecified Error' When Using SQLOLEDB Provider

ID: Q194000

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

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.

MORE INFORMATION

Steps to Reproduce Behavior

Open a new Web project in Visual InterDev 6.0

Add a data connection to a SQL Server database.

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.

Add an ASP page to the project and add a Recordset DTC to the page.

Open the Query Builder from the Recordset DTC by choosing SQL Statement in the Recordset DTC's properties and clicking SQL Builder.

Drag a table from the Data View to the design surface of the Query builder.

Additional query words:

Keywords : kberrmsg kbVisID600bug kbGrpASP kbSQLServ650
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbbug