Re: Access Violation or Syntax Err from RDO to Oracle

I had a similar problem using VB/ADO/ODBC against an Oracle SP. Turned out the problem was the Microsoft 2.73 ODBC driver for Oracle is fussy about what version of SQLNet it works with. There is a MSFT Kbase article on Configuring MTS (Microsoft Transaction Server) to work with Oracle that lays out pretty explicitly what versions have been tested and work.

I hope this helps

On Wed, 26 May 1999 14:24:42 -0400, Ricky Martin <rmartin_at_lovenet.com> wrote:

>Calling Oracle stored proc from VB/RDO/ODBC, sometimes we get
>Access Violation or Syntax Error.
>
>We know some of the reasons for this error -
>(1) Procedure not compiled - has become invalid due to some object
>change
>(2) Caller doesn't have execute permission
>
>These reasons are ok and understandable and can be easily avoided.
>Another reason when this happens cannot be easily explained. I don't
>know what the reason is but after getting this error, if I FLUSH SHARED
>POOL then error goes away.
>
>Can somebody throw some light on it ?
>
Received on Sat May 29 1999 - 00:56:19 CDT