Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: ADO
Expertise: Beginner
Jul 23, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Passing an ADO Connection Object

I've made a VB ActiveX DLL and defined a class and some methods to perform some database operations. I pass an ADO connection by reference to this class from the calling application.

When I try to set the ADOCommand.activeConnection to the passed in ADO connection inside one of the methods of the class, I get a runtime error 3001.

The error message says, "The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another".

I checked the ADO Connection that I passed in, and it seems fine. All the properties of connection are correct, and the connection is opened.

Instead of accepting an ADO Connection object as your parameter type, accept a Variant instead. You can immediately set the parameter to your internal ADO Connection variable, but this will let the parameter through. I've seen this problem a few times when using the DLL with an ASP file. Switching to a Variant took care of the problem each time, and you can always add a little error checking to make sure the right type of object is being passed in.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date