Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 15th, 2007, 12:12 PM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default MS Access connecting to Oracle Problem

I have two computers at my desk. Both have MS Access and connect to Oracle.

Both say that they connected successfully when I do a “Test Connection)” but the problem I’m having is that one of the computers can take over an hour to run one query when it only take the anther computer 5 minutes. This happens with all my queries, and I’m not running them at the same time

Is there some setting I need to change?

Thanks
Corey


  #2 (permalink)  
Old February 15th, 2007, 12:18 PM
Friend of Wrox
 
Join Date: Sep 2005
Location: , , USA.
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Corey
Default

and the Tables open very slow also

  #3 (permalink)  
Old March 21st, 2007, 02:52 AM
Registered User
 
Join Date: Mar 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Plz Check if there archieved log is on or not, if it is in on stat then turn off the archieved log.

Regards
Vikas



Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access - Connecting to dartcoach VB.NET 2002/2003 Basics 2 February 27th, 2007 12:05 PM
Connecting MS Access using Struts roopesh_dubey Struts 0 February 18th, 2007 02:43 AM
connecting PHP to MS Access pb7 Beginning PHP 5 September 24th, 2004 05:04 PM
Problem: JSP connecting to MS Access amcp2002 JSP Basics 3 August 12th, 2003 12:07 PM
Connecting Access 2002 to Oracle lmcharl Access 0 July 10th, 2003 01:39 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.