If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error 3298:More than one table exists with same name
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. |
#2
|
|||
|
|||
Error 3298:More than one table exists with same name
hmmm....intresting
"dram" wrote in message ... 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. |
#3
|
|||
|
|||
Error 3298:More than one table exists with same name
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... "dram" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|