Re: Oracle+ODBC+VB4: Cannot access objects from other users

Try creating another another ODBC connection string.

My tnsnames entry is ORACLEHP
but in my ODBC Admin, I have an entry for

1. RAWDATA which uses the tnsname oraclehp
2. WEBUSER which uses the same oraclehp
3. RETUSER which uses the same oraclehp etc.

I read somewhere (microsoft kb) that Microsoft name resolution for ODBC connections "assumes" that all connections with the same ODBC connection NAME are using the same userid, password, etc. and that this was known in version 1.1 of MS-Access and has persisted ever since and that they (microsoft) had no intention of fixing it.

Where this does work for me (most of the time), I do have some instances, particularly with synonyms, where it doesn't.

good luck.

Dinis Paes <dmp_at_elefante.fe.up.pt> wrote in article <33724213.59E2_at_elefante.fe.up.pt>...
> Hello,
>
> I'm using Visual Basic 4 with ODBC to access a Personal Oracle 7
> database,
> and when I try to access a table or view from a user other than the one
> I used to connect to the DB, I get the following error:
>
> Runtime error '3078':
> Couldn't find table or query <table/view name>.
>
> It's not a problem with grants or synonyms in the DB because when
> I execute the same queries in sqlplus everything works fine.
> Executing those queries in the ODBC test application that came
> with the ODBC driver, works OK too, so I dont think it's a
> problem with the ODBC driver either.
>
> Any ideas?
>
> Thanks,
>
> Dinis Paes
>
> dmp_at_elefante.fe.up.pt
> Faculdade de Engenharia da Universidade do Porto, Portugal
>
Received on Fri May 09 1997 - 00:00:00 CEST