Re: ODBC, VBA and error 3151
From: Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com>
Date: Sun, 18 May 2003 16:01:41 GMT
Message-ID: <F7Oxa.3445$FC2.2177042_at_news1.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
>>
'error 3151 odbc connection to <db> failed' - the usual 3151 error, in fact the only one I can recall at the moment. Received on Sun May 18 2003 - 18:01:41 CEST
Date: Sun, 18 May 2003 16:01:41 GMT
Message-ID: <F7Oxa.3445$FC2.2177042_at_news1.telusplanet.net>
Sybrand Bakker wrote:
> "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 > >
'error 3151 odbc connection to <db> failed' - the usual 3151 error, in fact the only one I can recall at the moment. Received on Sun May 18 2003 - 18:01:41 CEST