BUG: Variable Uses Automation Type Not Supported Error

ID: Q233348

The information in this article applies to:

SYMPTOMS

When attempting to add a SQL 7.0 Stored Procedure to Source Control the following error appears:

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


CAUSE

This error occurs only on databases that has been upgraded to SQL 7.0 using the SQL 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 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 issue you need to create a new database in SQL Server 7.0, and 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.


STATUS

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

Additional query words: 


Keywords          : kbSSafe600 kbVisDBTools kbVisID600 kbVisID600bug kbVS600bug kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: August 2, 1999