Problem accessing Oracle synonyms from microsoft excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am using microsoft excel 2002 , Oracel ODBC Driver ( 8.01.07.00) & trying
to connect to Oracle database 9i. it is getting connected also it shows me a
list of public synonyms ( owner : ALL)

but I can n't access public synonym from add table but I can access public
synonym from microsoft query.

Can you please help me
 
This is just a WAG, but check your Oracle driver. The version number you
posted kind of looks like an Oracle 8 driver.

Also you have posted to a MS Access news group. You might get a better
response if you posted to one of the microsoft.public. excel groups.

Hope this points you in the right direction
Rosco
 
Thanks for your mail. I will post it to right group.

Yes I have checked ODBC Driver version yes it is Oracle 8 Driver.

It is wage that when I use SQl Query It just works fine..but when I try to
add tables , it says can't access table <PUBLIC.sysnonym name>

Thanks
-- Sandeep
 

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

Similar Threads

Problem accessing Oracle Public Synonyms from Microsoft Excel 2002 1
Linking Access and Oracle problem 4
Problem with link dialog list >= 35000 entries 2
Error 3298:More than one table exists with same name 2
Oracle Connection 3
Oracle ODBC Connection Problem 1
MS Oracle ODBC failure in Access 07 3
Access 2003 not linked to Oracle 11g 3

Back
Top