Throwing System.MissingMethodException while trying to append fields to an ADODB recordset in a VSTO Excel Add-in being upgrade from XLA.

I am upgrading/updating an old Excel 2003 XLA Add-in into a Excel 2013 VSTO Add-in.  I manually copied and then pasted the code into the new project and cleared a massive number of errors that mainly had to do with changes in enumeration.

The add-in utilized ADO disconnected recordsets for sorting and filtering.

I added a reference to Microsoft ActiveX Data Objects 2.8 Library into the project and imported ADODB into the module throwing the error.  The intellisense for the objects works as expected.  However, the System.MissingMethodException appears at runtime.  

I know the  method exists and I am unclear on how this is broken.

 Sub CreateRecordSet()

        rs = New ADODB.Recordset
        With rs
            ' prime for use in disconnected mode
            .ActiveConnection = Nothing
            .CursorLocation = CursorLocationEnum.adUseClient
            .LockType = LockTypeEnum.adLockBatchOptimistic

            ' Create columns in your record
            With .Fields
                 .Append("Name", DataTypeEnum.adVarChar, 75)    '  <<---Exception thrown here!!
                .Append("Company", DataTypeEnum.adVarChar, 75)
                .Append("Position", DataTypeEnum.adVarChar, 75)
                .Append("Bed", DataTypeEnum.adVarChar, 15)
                .Append("LifeBoat", DataTypeEnum.adVarChar, 15)
                .Append("RowNumber", DataTypeEnum.adInteger)
                .Append("EmerResp", DataTypeEnum.adBoolean)
            End With
        End With

        rs.Open() ' first open the recordset
Tesla428Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CodeCruiserCommented:
If you are upgrading it, why not use the opportunity to get rid of obsolete technology (ADODB) at the same time?
0
Tesla428Author Commented:
CodeCruiser,

Not above replacing ADODB even though I am sure that it should work.  It was used for the simplicity of being able to use SQL base filtering and sorting.

You are recommending a better solution?
0
CodeCruiserCommented:
ADO.NET
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Tesla428Author Commented:
Fixed.  Downgraded from Microsoft ActiveX Data Objects 2.8 Library to version 2.5.  Must be something different in the syntax.  No issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tesla428Author Commented:
Issue was completely related to differences between ADO 2.8 and 2.5.
0
Tesla428Author Commented:
Issue was completely related to differences between ADO 2.8 and 2.5.  Found on my own.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.