Re: ODBC, VBA and error 3151

"Glen A Stromquist" <glen_stromquist_at_nospam.yahoo.com> wrote in message news:dnzxa.4116$s14.1607950_at_news0.telusplanet.net...
> Well, I thought someone in the VB and MSaccess NG's would be able to
> help with this, but so far nothing, so perhaps somewone here might...
>
> I have an access front end for a simple little oracle database, the
> MsAccess part of it is simply a data editing/entering form, a simple
> query and a report generated from the Access query. All of the business
> logic is on the oracle end with a stored procedure being run from a
> button on the access form.
>
> I managed to get my access pass thru query to run an oracle stored
> procedure with the help of a developer that had some vb knowledge, the
> problem was that the microsoft data access components was not checked
> off under references from the vb module.
>
> Now here is my problem, I brough the app home to work on it, recreated
> the oracle schema on my home pc, created a dns/odbc link, opened the
> access app and relinked the tables. So far so good, I can see the tables
> in oracle, edit and update them from the form, but when I go to run the
> pass thru query I am getting the dreaded 3151 odbc error. I tried both
> oracle and ms odbc drivers.
>
> It is cratering on the pass through query, which is a simple "begin
> <stored_proc>(integer); end;
>
> I turned on tracing in the ODBC, but there is nothing I can make any
> sense of in it, but the pass thru query does not even show up
>
> Eventually I'd like to write this in pure VB without ODBC, but I'm not a
> programmer and using msaccess is the fastest/easiest at this time.
>
> suggestions on what else to try??
>
> TIA
>

Posting the text of the ora-3151 error (which you should have done in the first place) instead of forcing someone else to look it up. The group exists to help people out, NOT to do THEIR work FREE OF CHARGE

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address