Re: ADOX Keys.Append not working on Vista

I will follow this up with Microsoft. Just cant believe nobody is using ADOX
on Vista, or if they are they are having no problems. This was reported last
year in the MSDN forums
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1002254&SiteID=1. No
replies to date.

Here is the post:
We're calling ADOX::Table::Keys::Append to make a primary key for a table
using the SQLOLEDB provider. We're passing an ADOX::Key with Name set to a
custom name, Type set to ADOX::adKeyPrimary, and a single column added. For
the Append call, the 2nd parameter is ADOX::adKeyPrimary, the third is a
vtMissing (VT_ERROR with DISP_E_PARAMNOTFOUND), the last two are empty BSTR's.
On XP, this works well (msadox.dll file version 2.81.1117.0). On Vista,
this fails with an invalid parameter error (msadox.dll version
6.0.6000.16386).

Has the interface changed in some way, is this functionality not supported,
or is it broken?




.