Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

ODBC connection

Discussion in 'Information Technology' started by BECAM, Jul 28, 2006.

  1. BECAM

    BECAM
    Expand Collapse
    Guest

    I have set up a linked table (an ODBC to an oracle database) and when first
    accessing the table am prompted for the username and password to access it.
    This is fine and i can use the database and access the oracle tables with no
    problem. That is unless i leave the database open for any period of time.
    then when i try to access a linked table, i have to re-put in the password
    about 3 times before the query or report that is accessing the oracle
    database opens, and it generally takes about 1 minute longer than if i was to
    close the database, re-open it, type in the username and password again once.
    is there anyway i can keep the link with initial username and password open
    for the entire time the database is open without having to re-enter it?
     
  2. Loading...

    Similar Threads Forum Date
    connection! Blogs Oct 17, 2015
    Still No Connection Blogs Oct 17, 2015
    connection Blogs Oct 16, 2015
    India The many British connections to massacres of Sikhs Breaking News Mar 29, 2014
    Forgotten Sikhs in Modern India. Their Connection to the Sikh Gurus Sikh Sikhi Sikhism Dec 8, 2013

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Only if the server allows you to ping the data sources. Your server
    apparently has a connection time-out that is enforced. Discuss the problem
    with your IT department and see if they can't remove or change the time-out
    period.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "BECAM" <BECAM@discussions.microsoft.com> wrote in message
    news:BCCA74CE-1206-4D63-A68B-D9466EDEABC5@microsoft.com...
    >I have set up a linked table (an ODBC to an oracle database) and when first
    > accessing the table am prompted for the username and password to access
    > it.
    > This is fine and i can use the database and access the oracle tables with
    > no
    > problem. That is unless i leave the database open for any period of time.
    > then when i try to access a linked table, i have to re-put in the password
    > about 3 times before the query or report that is accessing the oracle
    > database opens, and it generally takes about 1 minute longer than if i was
    > to
    > close the database, re-open it, type in the username and password again
    > once.
    > is there anyway i can keep the link with initial username and password
    > open
    > for the entire time the database is open without having to re-enter it?
     

Share This Page