Microsoft KB Archive/233348

= BUG: Variable Uses Automation Type Not Supported Error =

Article ID: 233348

Article Last Modified on 12/5/2003

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft Visual SourceSafe 6.0 Standard Edition

-



This article was previously published under Q233348



SYMPTOMS
When you try to add a Microsoft SQL Server 7.0 Stored Procedure to Source Control, you receive the following error message:

[MS ODBC SQL server] driver SQL version control eror : Variable uses and automation type not supported in VB.

Note In this error message, the word "eror" is a misspelling for the word "error."



CAUSE
This error occurs only on databases that have been upgraded to SQL Server 7.0 by using the SQL Server 7.0 Upgrade Wizard.

SQL Server 7.0 declares the variable that stores the text of the stored procedure text in a system table as UNICODE. This declaration has doubled the size of the stored procedure and a NULL value is then passed into the dt_addtosourcecontrol stored procedure.



RESOLUTION
To resolve this bug, follow one of these procedures:  Create a new database in SQL Server 7.0, and then generate a script of your stored procedures from the problematic database. Run this script against the new database to add the stored procedures to the newly created database. Change the compatibility level to SQL Server 7.0 for that database. To do this, open the SQL Query Analyzer, make sure that it points to the database in question, and then run the following command:

EXEC sp_dbcmptlevel 'databasename', 70





STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

Keywords: kberrmsg kbbug kbpending KB233348

-

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

© Microsoft Corporation. All rights reserved.