Cannot access Oacle view which has changed

  • Thread starter Thread starter Kalyanam Sankar
  • Start date Start date
K

Kalyanam Sankar

Hi All
I have an oracle view which is linked to MS access thru
Oracle ODBC.Recently we changed the definiion of the view
(removed one of the columns in the view).Now whenever I
try to access this view Access gives me
"ODBC--Call Failed.Invalid column name".
The view is accessible thru SQLplus.Also If I create an
dsn with MS's oracle ODBC(instead of Oracles),I have no
problem.
Has anyone experienced this behaviour?Should I ask all
my users to use MS ODBC????
TIA
Kalyan
 
Whenever you change the underlying table/view you have to delete the link
and re-create it.
 
Back
Top