Hi All,
I just upgraded from Oracle 7.3 to 8. I have a big query that runs in Access that works fine on a 7.3 server, but fails on the new 8.1 server. Here are the particulars:
3 linked tables
Acc 860,817 rows
AccCans 294,652 rows
AccSumm 860,817 rows
one local table
SpecFeat 391,495 rows
The query selects about 20 columns from the various tables. The tables are inner joined on a single varchar(12) field.
What happens is, when I run the query, I never see a progress bar in Access. It just flogs around for a while, then goes to 100% processor utilization and stays there until I abort the task. This same query works fine when I point it at the 7.3 Oracle server (with identical data).
The query also runs if I remove the AccCans table from the query, OR if I leave AccCans in, and remove AccSumm and SpecFeat. Which I obviously cannot do, because I need all of the data in my query.
The query also runs if I use the Oracle ODBC driver 8.01.06.00, but it takes eternity, so I wanted to use the MS driver, instead.
Software release levels are:
Oracle Server 8.1.6.3
Oracle Client 8.1.6
MDAC 2.70.9001.0
ODBC (MS ODBC for Oracle) 2.573.9001.00
Win NT 4.0 SP 6
Access 97 SR-2
If anyone has any ideas, I would sure like to hear them.
Thanks,
Paul
I just upgraded from Oracle 7.3 to 8. I have a big query that runs in Access that works fine on a 7.3 server, but fails on the new 8.1 server. Here are the particulars:
3 linked tables
Acc 860,817 rows
AccCans 294,652 rows
AccSumm 860,817 rows
one local table
SpecFeat 391,495 rows
The query selects about 20 columns from the various tables. The tables are inner joined on a single varchar(12) field.
What happens is, when I run the query, I never see a progress bar in Access. It just flogs around for a while, then goes to 100% processor utilization and stays there until I abort the task. This same query works fine when I point it at the 7.3 Oracle server (with identical data).
The query also runs if I remove the AccCans table from the query, OR if I leave AccCans in, and remove AccSumm and SpecFeat. Which I obviously cannot do, because I need all of the data in my query.
The query also runs if I use the Oracle ODBC driver 8.01.06.00, but it takes eternity, so I wanted to use the MS driver, instead.
Software release levels are:
Oracle Server 8.1.6.3
Oracle Client 8.1.6
MDAC 2.70.9001.0
ODBC (MS ODBC for Oracle) 2.573.9001.00
Win NT 4.0 SP 6
Access 97 SR-2
If anyone has any ideas, I would sure like to hear them.
Thanks,
Paul