Intersolv ODBC Driver and Synonyms

From: Brad Murray <BradMurray_SeeSignature_at_NoSpam.com>
Date: 1997/08/13
Message-ID: <5stdhg$4n8_at_news1.zippo.com>#1/1


We are developing a VB5 app using the Intersolv ODBC driver and Oracle 7.3. We recently had to go to a new complex security system using a series of private synonyms to views for each user. Now that I have reworked all of the code to handle the new layout we are getting insufficient privilege errors on all accesses while there are no problems selecting from the synonyms in SQL worksheet. My best guess is that the Intersolv driver does not support synonyms. Can anybody confirm or refute that?

If you have a good solution I will gladly pay you for your time.

PS - Please respond by mail as well as to the group.

Brad



 Bradley S. Murray Princeton Computer Consulting (609) 730-9100  BradMurray(-at-)usa.net Pennington, NJ 08534-3612 Fax: 275-5651

To respond, use the address in the signature and while you're at it, dummy up your reply address to avoid getting junk e-mail from these scum bags who scan newsgroups to build address lists

Support the anti-Spam amendment - Join at http://www.cauce.org/ Received on Wed Aug 13 1997 - 00:00:00 CEST

Original text of this message