Op not allowed when obj is closed? - RESOLVED

[mdsoren]

I get the following error when attempting to assign a recordset as the Data source for a DataReport in VB6...

"Operation not allowed when object is closed."

I have not explicitly closed the newly created rst.
I am using:
cursorlocation of adUseClient
cursortype of adLockReadOnly
cursorlocktype of adLockOptimistic

What else can i check? The very next step after creating the rst I check the recordcount and that is when I am getting the error.

HELP!

[Mc Brain]

Originally posted by mdsoren
I get the following error when attempting to assign a recordset as the Data source for a DataReport in VB6...

"Operation not allowed when object is closed."

I have not explicitly closed the newly created rst.
I am using:
cursorlocation of adUseClient
cursortype of adLockReadOnly
cursorlocktype of adLockOptimistic

What else can i check? The very next step after creating the rst I check the recordcount and that is when I am getting the error.

HELP!

There must be a problem with the query. So, you don't get any recordset.... this means the rst is closed.

[techgnome]

Wow. Not much info to go off of. Here's what I got:
1) Make sure that there wasn't an error when getting the recordset. The Connection obj has an Errors collection you can check.
2) Make sure the connection wasn't closed (either on purpose or accidently).
3) Try posting the actual code. Sometimes the answer isn't obvious until some one else has looked at it too.

See if #1 or 2 help, if not, try #3.

PS: Go Clones!

[mdsoren]

If I run the query in the data enviromnment designer and give the same input as I do in the app, I get the expected rst.... hmmmm?

I will continue to muddle away and get back to this if still unresolved later today.

Thanx ALL!
MDS

[kleinma]

DEBUG!!!!!!!!!!!!!!!!!!!!!!!!!!!!

put a break point on the sub routine that gets the error... then step through each line to find out where it is erroring...

people don't use the debugger as much as they should... it saves a ton of headaches and time

[mdsoren]

There was an error in the command text in my inner join - DUH!

Not sure why it worked in the dataenvironment and not in code, but then at this point it doesn't matter and i don't care!

[Mc Brain]

Cheers!!