Re: VB RDO / Oracle - stored procedures, problem

Thanks, DW.
A combination of both appears to have been the problem. I downloaded Oracle drivers and manually installed them. My VB was then freezing on me (oddly enough), until I got rid of the curly brackets.

Cheers and good karma,
R/mi.

In article <88u6ov$vm7$1_at_nnrp1.deja.com>,   DriftWood <drift_wood_at_my-deja.com> wrote:
> In article <88s65i$j5u$1_at_nnrp1.deja.com>,
> remidesp_at_my-deja.com wrote:
> <snip>
> > 2)I've also tried using "{begin call dbo.sp_insert_funct (?,?);
end;}"
> > as query string, as suggested by someone in a few older posts
refering
> > to a similar problem, with the same results.
>
> This is wrong syntax. Simply use:
>
> "begin call dbo.sp_insert_funct (?,?); end;"
>
> Eliminate the ODBC Escape syntax (the {}) since you are not calling an
> escape but simply passing in SQL.
>
> Make certain that you have the latest patch version of the driver for
> your client version -- there was a bug on the Oracle ODBC driver at
> some point that caused an error like this and it was long since fixed.
>
> --
> -cheers
> DW
> --------------------------------------------------------------------
> "It is a kind of good deed to say well; and yet words are not deeds.
> -William Shakespeare"
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 17:15:21 CET