0x80020008 error

Hi,

I have an ActiveSync provider dll that writes data to a MSDE 2000a database. 
The DLL is written in C++ using VS.NET 2003.

I write a record to a table using a stored procedure and it has a "out" 
parameter that gets populated with the row identity value from SELECT 
IDENT_CURRENT('Entries').

Here is the output parameter definition:
_ParameterPtr Parm = 
pCommand->CreateParameter(L"@pEntryID",adBigInt,adParamOutput,9);
pCommand->Parameters->Append(Parm);

Then, I stored the value in a __int64 variable using the following code:
__int64 iRecID = 0;
try {
  _variant_t Val = Parm->Value;
  iRecID = (__int64)Val;
} catch(_com_error &e) {
  _bstr_t sMsg = e.Description();
  return -1;
}

For some reason, the variable Val has type VT_DECIMAL. If I run this code in 
English Windows and English version of ActiveSync, the conversion to __int64 
works. However, if the code is run in German Windows and German ActiveSync, 
I always get an error 0x80020008 (Wrong type of variable). Note that both 
systems use English version of MSDE2000a.

Is there any reason why I get a DECIMAL value while the paramter is 
specified as a Bigint? Should it not be a type VT_I8 variant? How do I make 
it work in any language version of Windows?
-- 
Herbert
Fann Software
 http://www.**--****.com/ 

Hi Herbert,

Looking at the nature of this issue, currently, I don't have German version 
of Windows and ActiveSync for testing, it would require intensive 
troubleshooting which would be done quickly and effectively with direct 
assistance from a Microsoft Support Professional through Microsoft Product 
Support Services. You can contact Microsoft Product Support directly to 
discuss additional support options you may have available.

 http://www.**--****.com/ ;en-us;offer
prophone

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no 
rights."

I see the same problem: for bigint columns, Value returns a variant with a 
type of VT_DECIMAL and the __int64 cast operator fails with 0x80020008.

I tracked it down to ::VariantChangeType (oleaut32.dll).

In my case, this error only occurs on Windows 2000 (version 2.40.4522 of 
oleaut32.dll). The cast works correctly on Windows Server 2003 and XP 
(version 3.50.5016 of oleaut32.dll).