Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Intersolv ODBC Driver and Synonyms
In article <5stdhg$4n8_at_news1.zippo.com>, BradMurray_SeeSignature_at_NoSpam.com (Brad Murray) wrote:
>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?
In case anybody was curious about this, the solution was that we were still using RDO 1.0 which when going through the Intersolv ODBC driver was not clicking with synonyms. We switched to RDO 2.0 and everything was working.
Brad
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 Mon Aug 18 1997 - 00:00:00 CDT