Problem with error ADODB.Recordset (0x800A0CC1) and oracle databse

[ttrinh]

Hi
I am getting this error when I try to run my asp page
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
The line of code in question is
ActMaj_Name = rsTemp.Fields("ActMaj_Name&quot

The page worked fine with an Access database but when I migrated the database to oracle and tried reconnection I get this error
Can anyone tell me what is going on here? I am a newbie in asp

TIA
Thanh

 

[ehsant]

Hi there ...
can you say how you migrated your DB in Oracle ?
did you create a new table or just import your Ex. DB from Access to Oracle ?
and can you send the SQL command for me to take a look on it ?

TNX.
E.T.

 

[ttrinh]

Hi ehsant,

Sorry I didn't respond earlier, got side tracked with other things ..
ok I migrated bthe database using Oracle Migration Workbench . I didn't appear to get any error messages so I assume the migration went ok.
The sql that is causing problems is
Sql = "SELECT DISTINCT ActMaj_Name, ActMaj_ID, ActMin_Name, ActMin_ID" _
& " FROM DocumentRegister DR, DocumentActivity DA, Activity_Major Maj, Activity_Minor Min" _
& " WHERE DR.Flag = 'Active'" _
& " AND DA.DocRegId=DR.DocRegId"_
& " AND DA.ActivityMinorID=Min.ActMin_ID" _
& " AND Maj.ActMaj_ID=Min.ActMin_Parent" _
& " ORDER BY 1,3"

I have tested this in SQLPlus and it works fine
I have tried changing drivers but that didn't work

Thanks