[AccessD] Re: ODBC against Oracle partitioned db

Hi Patti:

Toad is probably the best Oracle manager/designer/developer tool ever built.
It has now expanded it's extensive set of features to MS SQL and even MySQL.
Check it out: http://www.toadsoft.com/

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of O'Connor,
Patricia (OTDA)
Sent: Thursday, November 18, 2004 9:05 AM
To: Access Developers discussion and problem solving
Subject: RE: [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
>
>
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com