Error 3298:More than one table exists with same name


D

dram

I am connecting to Oracle database 9i using 'Microsoft ODBC for Oracle'.
I open MS-Access 2003->new file->blank database->create a new db->link
tables->
select 'ODBC databases' from filetype->select data source->ok.
I enter the username/pwd.
I get thru connection to the target(oracle) database and i can see all the
tables in the database.
I select one table and click 'ok'.

I get the error 'There are several tables with that name.Please specify
owner in the format 'owner.table'--Error:3298(when i click 'Help').

I use the same DSN for pulling data into my 'Excel Sheet'.It works fine.
I couldn't get more information online.

Can anyone please help me with this situation.
 
Ad

Advertisements

Ad

Advertisements

D

dram

I found that the table listing after the link had same table name twice like
'owner.tablename' and 'tablename'.when i selected 'owner.tablename' it worked.
Also when i tried to configure the DSN i typed my 'username'..'server'
selected options and unchecked 'Include synonyms in SQL columns' it worked
for both 'owner.tablename' and 'tablename'.
Can i uncheck 'Include synonyms in SQL columns' , any suggestions on this...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top