Re: MSACCESS hangs

From: <>
Date: Wed, 23 Jul 2008 17:07:24 +0200
Message-ID: <>

On Wed, 23 Jul 2008 07:37:07 -0700 (PDT), "Pete's" <> wrote:

>Server -- AIX 5.3 TL06 SP03, Oracle EE
>Client -- Windows XP, MS Access 2003 using Oracle's ODBC driver
>Hey all, have a user having a problem now trying to get a listing of
>tables via 'link tables' operation MS Access, this is after the login
>dialog. I can see the session connect and stays active until I
>eventually have to kill the session. Looking at the sql it's running:
>SELECT count(*)
> FROM user$ u, xdb.xdb$schema s
> WHERE u.user# = :1
> AND = s.xmldata.schema_owner
> AND xdb.xdb$extname2intname(s.xmldata.schema_url,
>s.xmldata.schema_owner) = :2
>Anyone have any ideas, besides upgrading? I have updated dictionary
>stats, System stats are set and have not changed.

I would try to isolate whether it is the query or ODBC. So I would turn it into a passthru query, or run it in sqlplus, preferably on the server.

BTW: Please do NOT use the sys *tables* directly. Oracle doesn't guarantee their existence in future releases.

Sybrand Bakker
Senior Oracle Dba
Received on Wed Jul 23 2008 - 10:07:24 CDT

Original text of this message