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

Faculdade de Engenharia da Universidade do Porto, Portugal

i.e Your db user login is JOE, but you need access to a table, CUSTOMER,
owned by DINIS

"SELECT CUST-ID FROM CUSTOMER" doesn't work

"SELECT CUST-ID FROM DINIS.CUSTOMER" works fine

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.