Hi Gang,

I am having a strange problem with an ASP page.

I am getting the following error when I try to set the
recordset.activeconnection = true:

ADODB.Recordset error '800a0e7b' 
Cannot change the ActiveConnection property of a
Recordset object which has a Command object as its
source. 

It bombs on the first attempt to evaluate the
recordset with BOF and EOF.  

I think it might relate to the stored procudure I am
using.  It doesn't happen with any other pages and
when I changed a working page to call this SP, I get
the same error.   

Here is the SQL:

select DCU.DRCR_ID
into #DRCRUsed
from FCI_DRCRMemo D, FCI_DRCRUsage DCU
where
	Customer_ID = @Customer_ID
 	and D.IsDebit = 1
	and DCU.DRCR_ID = D.DRCR_ID
	and D.MarkedAsPaid = 0


select D.DRCR_ID, D.Amount, D.DateEntered, D.Memo
from FCI_DRCRMemo D
where
	Customer_ID = @Customer_ID
 	and D.IsDebit = 1
	and D.DRCR_ID not in (select DRCR_ID from #DRCRUsed)

drop table #DRCRUsed

Is there anything that sticks out?  Can anyone see a
problem that would cause the above error?

TIA,
Mark

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

> Hi Gang,

I am having a strange problem with an ASP page.

I am getting the following error when I try to set the
recordset.activeconnection = true:

ADODB.Recordset error '800a0e7b' 
Cannot change the ActiveConnection property of a
Recordset object which has a Command object as its
source. 

It bombs on the first attempt to evaluate the
recordset with BOF and EOF.  

I think it might relate to the stored procudure I am
using.  It doesn't happen with any other pages and
when I changed a working page to call this SP, I get
the same error.   

Here is the SQL:

select DCU.DRCR_ID
into #DRCRUsed
from FCI_DRCRMemo D, FCI_DRCRUsage DCU
where
	Customer_ID = @Customer_ID
 	and D.IsDebit = 1
	and DCU.DRCR_ID = D.DRCR_ID
	and D.MarkedAsPaid = 0


select D.DRCR_ID, D.Amount, D.DateEntered, D.Memo
from FCI_DRCRMemo D
where
	Customer_ID = @Customer_ID
 	and D.IsDebit = 1
	and D.DRCR_ID not in (select DRCR_ID from #DRCRUsed)

drop table #DRCRUsed

Is there anything that sticks out?  Can anyone see a
problem that would cause the above error?

TIA,
Mark

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

Hi mark
you should put your valid Connection object instead of where u put true...

rs.activeconnection = conn

avi

HI Avi,

Thanks for the tip.  I'll check it out.

As far as the error, it seemed to go away when I
rewrote the SQL without using the temp table.  I am
not sure why, but it works.

Thanks,
Mark
--- avi cohen <avic@r...> wrote:
> Hi mark
> you should put your valid Connection object instead
> of where u put true...
> 
> rs.activeconnection = conn
> 
> avi


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com