Re: MSACCESS hangs

On Jul 23, 7:37 am, "Pete's" <empete2..._at_yahoo.com> wrote:
> Server -- AIX 5.3 TL06 SP03, Oracle 10.2.0.1 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 u.name = 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.
>
> TIA,
> Pete's

While looking for something completely different, I stumbled over this: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb26imp.htm#sthref2432 I have no clue about xdb, but I'm wondering if there is something special about it that is influencing your problem.

jg

--
@home.com is bogus.
Revenge is a dish best served hidden away in secret dark places no one
will ever find.  http://www.signonsandiego.com/uniontrib/20080725/news_1n25revenge.html