BUG: Variable Uses Automation Type Not Supported Error (233348)
The information in this article applies to:
- Microsoft Visual InterDev 6.0
- Microsoft Visual SourceSafe for Windows 6.0
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
STATUSMicrosoft has confirmed that this is a bug in the Microsoft
products that are listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 12/5/2003 |
|---|
| Keywords: | kbBug kberrmsg kbpending KB233348 kbAudDeveloper |
|---|
|