429 Again

[Surrendermonkey]

The bane of my life, Error 429, ActiveX cannot create object, has returned.
I am using SQLOLE library, and am sure it is this which elicits the error, on the initial oServer.Disconnect. I've tried all the obvious business, but to no avail. Is there something I'm missing?

Thanks

S. monkey

[Chris Eastwood]

Error 429 is usually down to programmer error - in most cases you're calling a method on an object that hasn't been instantiated.

What kind of error handling do you have in your routine ? If you know the procedure / routine name where the error is occurring then I'd recommend putting line numbers in front of every statement,

eg:


'
1: SomeObject.DoSomething
2: AnotherObject.DoSomethingelse
'




In your error handler, you can then use the VB Erl command to get the line number that raised the error.


Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb

Another common cause of the 429 is the wrong library installed on the dev or target system. i.e. jet 3.6 on the development system and 3.5 on the target will get this error.

Been there. Done that!