External data connection needs separate login for each query

I have an Excel 2007 workbook with multiple external queries to Oracle. When
I created the workbook a year ago, I was prompted for Oracle credentials when
the first query against Oracle ran. The remaining queries apparently used
cached credentials to authenticate.

Recently, the behavior has changed. Now I am prompted for Oracle
credentials for each new query that runs. If I have five different queries
to the same database, I am prompted for the same login info five times. Once
I've logged in for each query, I am not prompted to login for subsequent
refreshes of that query while the workbook remains open. However having to
login for each query is painful.

Has there been some change that occurred with a patch to Excel?

Is there something I can do to revert to the old behavior where one login to
the database is sufficient for multiple queries to that database?
.

Relevant Pages

  • Re: SQL Injection
    ... > I am currently pen-testing a web app and I am stuck in trying to execute ... two queries sequentially in Oracle. ... You won't have luck with this in Oracle. ... the end query build by a cgi-script being ...
    (Pen-Test)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)