Slow ODBC Connection

From: Tyan (Tyan_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Thu, 2 Dec 2004 03:31:06 -0800

Hi,
I’m using front-end in MsAccess 97 and an Oracle 9i database.
My ODBC connection is very, very slow.
It’s almost impossible to work with my link tables.

My colleagues have similar PC as I, don’t have any trouble.
Does any one have some idea why I’m having this problem?
Exists any parameter on windows or Oracle that may the decreasing the
performance?

Thanks,
Tyan

Relevant Pages

  • ODBC setup
    ... I'm trying to setup linked tables through ODBC connection to an Oracle ... I checked my tnsnames entry and used the correct server name, ... tnsnames entry for that particular database, but it is in the format: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Microsoft Query
    ... alone and that Oracle is aware of the issue. ... > deleting data in the database. ... >> I can't speak directly to your problem with MS Query, ... >>> from a Unix based database, via an ODBC connection. ...
    (microsoft.public.excel.programming)
  • Access 2000 Ctirix odbc problem
    ... Recently the application was moved to a citrix environment. ... citrix environment is one copy of the mde and the oracle odbc driver to ... connect to the database. ... sharing the ODBC connection or what else might be causing it? ...
    (comp.databases.ms-access)
  • Re: Export MS Access tables to Oracle via a macro?
    ... exported the table from MSAccess 2000 to oracle....Now i am facing a new ... problem.....when i type DESC EXPORTEDTABLENAME there in oracle,i am ... You can set up a ODBC DSN pointing to your Oracle ... > database if you have the Oracle ODBC driver on your PC. ...
    (microsoft.public.access.externaldata)
  • Re: Suggestion for DB Connection
    ... Joe wrote: ... > I am using Visual Basic 6.0 and Oracle 8 as database for my project. ... > connect to the database using Visual basic 6.0 is it ODBC connection ...
    (microsoft.public.vb.general.discussion)