We were planning to use Oracle 8 for our data warehouse project but have discovered that SAS/Access doesn't function properly. Ie. the access descriptors and view descriptors fail to be built. SQL passthrough does still work however. The fix SAS institute (US) have told us is to upgrade to SAS V7, but the view from SAS Europe is that it's too risky and not recommended. Therefore we are forced to use Oracle 7 until SAS V8 is released and the problems/bugs have been ironed out. I am wondering if there are any other people out there in SAS-L land that have been similarly affected. Is SAS V7 to be feared as too risky an upgrade ? We are using BASE/SAS,FSP,MDDB Server, and Access to Oracle on the Unix system and will be also be using EIS, AF and Graph on the client NT 4 machines. Please could some comment be made on the problems or successes that have been found using these modules on SAS V7. We have been told that working with databases is completely different in SAS V7 and the access/view descriptors are history. Thanks Richard

"WorldSecure Server <prudential.co.uk>" made the following annotations on 04/30/99 14:50:25 ------------------------------------------------------------------------------

[INFO] -- Access Manager: This email is confidential and should not be used by anyone who is not the original intended recipient. Prudential cannot accept liability for statements made which are clearly the sender's own and not made on behalf of the Prudential. In addition no statement should be construed as giving investment advice within or outside the United Kingdom.

=============================================================================