Site Moving To New Domain

After nine years is moving off to a new domain. Due to lack of use of the many features of this site, I have decided to move the content to a blog platform, wherein people can still get the information they need, and I don't need to maintain the many and varied features of the site, other than content. You can still ask questions, or interact with other users; it's just in a different format.

There might come a day when the site will come back in a new form, but for now, it's done.

If you'd like any information out of the personal information out of any of the user tools, please let me know by sending email to me at the new site.

There have been over five million people (I don't count bots) that have visited this site over the years, and I hope that each and every one of them have had their questions answered, whatever they were looking for. If not, I hope they find it at the new site.

It has been a long, interesting run. I've learned lots of new things along the way with, and met lots of interesting people. I hope to continue this trend on the new site, where I will continue to post and interact with people all over the world.

If you have any questions or concerns, or just want to drop a note, you can hit me with an email at the new site.

ADODC Recordset problem

Q&A Home Search for a question Show Unresolved Show Resolved

You must login to ask or answer a question. If you don't have an account, you can register for one.

mccindy asked this question on 12/6/2011. It has been viewed 446 times, and is currently resolved.

I am having problems with ADODC Recordsets. I moved a VB 6 (SP6) project from XP to a Win 7 64 bit system.

My movecomplete functions get a compile error "procedure declaration does not match the description of the event or procedure having the same name". I've searched some, but can't find a solution that works. The project reference includes Microsoft ActiveX Data Objects Recordset 2.8 library on both the XP and Win 7 systems.

The other references all look the same on both systems. Can you provide any input?

Here is the code declaration that is failing...

Private Sub AdodcImportData_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)


Answer from FortyPoundHead on 12/6/2011:

Best Answer!

Does the project include references to other, earlier versions ADO versions as well? If so, uncheck those earlier versions. I'm thinking particularly of v2.0.

This error can also occur if procedure has the same name as an event, but does not have the same signature (that is, the number and types of the parameters).

This can occur if you do something such as add a new parameter to an event procedure. For example, if you modify the definition of a form's Form_Load event procedure, the error will be generated.

If you don't have the ADO reference mentioned earlier, you can try this to fix it:

Lift the code within the sub, and drop it in Notepad. Save it, for safetys sake.

Delete the sub. Not just the code within it, but from the "Private Sub" line all the way down to the "End Sub" line.

Save the project, compile it, exit the IDE.

Re-open the project in the IDE. Recreate the sub, take your lifted code over in Notepad, and drop it back into the sub.

Save the project, and see if it compiles.

Yes? No? New Error?


Answer from dwirch on 12/6/2011:

You might want to check out this link, as well: