Re: ODBC and Oracle

Hi Mike,

set the owner of the table in front of the table name, which means "Select * from <owner>.<tablename>".

I think that will solve your problem.

regards
Thorsten

Mike Layng schrieb in Nachricht <38c606bf_at_pink.one.net.au>...
>Hi,
>
>I am reasonably new to Oracle.
>
>We have a program that connects to Oracle 8i (8.1.5) using ODBC. My
problem
>arises when I try to reference a table that has the same name as another
>table in the database.
>
>e.g.
> I connect through ODBC using the username JSMITH and want to access the
>jsmith.location table. There is another table in the database called
>demo.location.
>
>If I try to create a recordset with "Select * from location" then I get an
>error telling me that the table name is ambiguous.
>
>I realise that the "proper" solution would be to use "Select * from
>jsmith.location" but this is not feasible at this stage due to other
>restrictions in the program.
>
>So, I guess my question is how can I set up my connection so that ODBC only
>looks at the tables owned by the current user?
>
>
>Thanks
>Mike.
>
>
>
>
Received on Wed Mar 08 2000 - 04:10:11 CST