[AccessD] Re: ODBC against Oracle partitioned db

What is TOAD?

I was wondering whether the newest Oracle ODBC driver would solve it. We
still have the 9.x one.

Thanks
Patti
******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at dfa.state.ny.us
*(w) mailto:aa1160 at dfa.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Robert L. Stewart
> Sent: Tuesday, November 16, 2004 02:56 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Re: ODBC against Oracle partitioned db
> 
> As you can see, Access and the ODBC driver has trouble with a 
> partioned table.
> 
> Use Toad or something like it for the type of things you 
> would do in running queries and viewing data.  Since it is 
> written for Oracle, it plays with it better.
> 
> Robert
> 
> At 12:01 PM 11/16/2004 -0600, you wrote:
> >Date: Tue, 16 Nov 2004 10:28:49 -0500
> >From: "O'Connor, Patricia \(OTDA\)"
> >         <Patricia.O'Connor at dfa.state.ny.us>
> >Subject: [AccessD] ODBC against Oracle partitioned db
> >To: "Access Developers discussion and problem solving"
> >         <accessd at databaseadvisors.com>
> >Message-ID:
> >         
> <B94C79B465542042AB0748EAF37F9AC0A427B1 at EXCNYSM0A1AB.nysemail.nyenet>
> >Content-Type: text/plain;       charset="us-ascii"
> >
> >Hi all
> >
> >When I use the Oracle ODBC driver against an ORACLE un-partitioned 
> >table from Access (either passthru or gui), I have not problem. Data 
> >comes back can scroll through 1-30+K records no problem.
> >
> >When I use same driver against an Oracle partitioned table 
> from access, 
> >I get temporary freeze ups when scrolling through records even 
> >scrolling from column 1 to say col 10 on screen. It doesn't 
> matter how 
> >many records in set - scroll down 3-6 records - stop. Sometimes the 
> >stall can be 2-5 minutes.
> >
> >Doesn't matter if it is the only thing running on computer. I do not 
> >have this problem with an unpartioned set.  I waste a good amount of 
> >time waiting for access to let me back in.
> >
> >Has anyone run into this and is there a workaround or 
> setting I need to 
> >change in the driver configuration.  My machine is Win2k, Access2k, 
> >Oracle10
> >
> >Thanks in advance
> >Patti
> 
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>