Error: The conversion to version 7.82 R1 has failed (Update ID: 4040). Please report the following error: Error Number: -2147211486, General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE cannot be used as a source when inserting int

If you are using SQL Server 2000 and you apply patch 25 or higher for version 7.82.104, then you will receive the following:  Error: The conversion to version 7.82 R1 has failed (Update ID: 4040). Please report the following error: Error Number:  -2147211486, General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE cannot be used as a source when inserting into a table variable. Native error: 197 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'FOR' Native Error:156
As of March 31, 2010, SQL Server 2000 is no longer supported.  If you are still using SQL Server 2000 and apply patch 25 or higher for version 7.82.104, then you will not be able to log in and upgrade your database without receiving this error.  You must detach your database and attach it to either SQL Server 2005, Service Pack 3 or 4, SQL Server 2008, Service Pack 1 or 2 or SQL Server 2008 R2.

For instructions on how to move from SQL Server 2000 to SQL Server 2005 Express, SQL Server 2005, SQL Server 2008, SQL Server 2008R2 Express or SQL Server 2008 R2 and configure the new SQL Server instance to be used with your Blackbaud database, then see Knowledgebase Solution BB701241.

For differences between versions of SQL Server, then see Knowledgebase Solution BB95014.

Environment

 7.82.104.25

Was this article helpful?