Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Views are not being updated

840751Feb 17 2011 — edited Feb 23 2011

Hello All,
I am a newbie to oracle dB.
I have an old VB6 application code that used to "talk" with Oracle dB (version 10g). The 2 machines used to be connected using the Microsoft ODBC for Oracle driver ("Provider=MSDASQL.1"). It used to run fine and all the dB's Views were updated automatically. We recently updated our Oracle to 11g running on Windows2008 r2 64bit machine. We are no longer using the Microsoft ODBC driver but the Oracle client (OraClient11g home1). The VB6 application seems to work OK, see all the records and all BUT, I noticed that all our Views are not being updated automatically anymore. I was wondering if any of you have any idea as to why this is happening and what should I do? I can always go back to the code and force the update on the all the Views but, I was hoping for a quick connection settings tweak if existed.

Thanks

g

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2011

Added on Feb 17 2011

#11g, #general-database-discussions

5 comments

697 views