I'm really hoping that someone can help me out here because I have been searching for days on why this is happening. Here is the situation...
We have a vbscript that uses SQLDMO to issue updates to a database. The script is written in such a way that if an error occurs, a log file is created with the Err.ID, Err.Description, etc. This helps us to debug why the script failed. The
problem comes in when we try and run this script on a 64 bit client machine. We end up getting no Err.Description at all and a completely different Err.ID. We have the SQL Server 2005 backwards compatibility package installed and 2005 is updated
to the latest service pack.
Here is a copy of the error we receive on the 32-bit box
Error  Description [SQL-DMO][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'FAKECOLUMN'.
10/4/2010 2:14:39 PM HelpFile SQLDMO80.hlp HelpContext 
10/4/2010 2:14:39 PM Source Microsoft SQL-DMO
Here is a copy of the error we receive on the 64-bit box
Error [-2147199229] Description
View Complete Post