Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 05, 10:43 PM
Sandeep
 
Posts: n/a
Default Problem accessing Oracle Public Synonyms from Microsoft Excel 2002

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 fine . It shows
me a
list of public synonyms ( owner : ALL) along with tables,views,system tables.

but I can n't access public synonym from add table but strange thing that I
can access those public synonym from microsoft query , it returns data too.

Can somebody please help me

Regards
-- Sandeep


  #2   Report Post  
Old January 5th 05, 10:31 AM
onedaywhen
 
Posts: n/a
Default


Sandeep wrote:
but I can n't access public synonym from add table but strange thing

that I
can access those public synonym from microsoft query , it returns

data too.

MS Query sends SQL it doesn't understand to the database server for
execution. Obviously the synonyms are known on the server side so it's
not so strange that the query returns data.

Jamie.

--



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 05:06 PM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 09:11 AM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 03:49 PM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 04:39 PM
Excel 2002 -> Problem with calculated fields in Pivottable H. Riewert Excel Discussion (Misc queries) 0 December 7th 04 10:33 AM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017