VB - How to Close a Class Object

[wrbodine]

Hi,

I using a .dll on the server to preform SQL statements. I have a list view that I need to refresh (and call a function in this .dll again to run the select statement). I'm having no problems the first time thru (before refreshing). When I'm going through the code again, once I get to the line where I set my Object:

Set DBDll = CreateObject("DllName.ClassName&quot

I get the following error:
Operation is not allowed when object is open.

Yet if I don't use that line of code the second time through I get error 91 : Object variable or with block variable not set.

Is there some way that I need to close this object from my .dll? Or something else that might remedy this situation?

Thanks,
Ray

 

[chiph]

When you're done with your object variable, are you setting it to Nothing? Also, are you making any recursive calls?

Chip H.

 

[wrbodine]

I'm using the subs Class_Initialize() and Class_Terminate(), and opening the connection in the former and setting it to nothing in the latter (in the .dll). In the client, in both methods I'm using CreateObject to open and then setting it to nothing at the end of the method.

I guess I don't fully understand Class_Initialize() and Class_Terminate, they might be being automatically run more that I realize...

 

[chiph]

Are you running under MTS/COM+?

If so, the Class_Initialize, Class_Terminate aren't where you should be putting initialization/termination code -- it ought to be in your ObjectControl_Activate and ObjectControl_Deactivate.

Chip H.

 

[wrbodine]

No COM+ and so far I haven't tried incorporating MTS either... Thanks for your input....

 

[wrbodine]

Actually, I just found the problem; There was one of the methods in the client where I needed to set my .dll object to nothing before I called the refresh method. Thanks for your ideas, Chip

 

[chiph]

Glad you were able to solve your problem.

Chip H.