Re: ODBC Call Failed error

[davem]

Bryan wrote on 04/17/2009 12:29 ET :
> I have an SQL Pass through query to an Oracle datrabase.
>
> I can see live data with the query but when I use it in a subform, it
> displays the data for a couple of seconds then gives an error:
>
> ODBC -- Call Failed.
> [Microsoft][ODBC Driver Manger] Function Sequence error (#0)
>
> The fields then display #NAME? in the subform.
>
> The sub form is not related to the main form - there is no Master/Child Link.
>
> My SQL is fairly simple - I'm just getting one row of data from one table:
>
> SELECT DBIS_PROD.STUDENT.* FROM DBIS_PROD.STUDENT WHERE
> DBIS_PROD.STUDENT.StuID='999999999' and
>
> The ID is changed before the form is opened by rewritting the sql -
> CurrentDb.QueryDefs("Students").sql= newSQL.
>
> Any ideas as to why this error is occuring and how to make it work correctly?
> I don't see why it would display the data for a few seconds then give the
> error.
>
>
> I could completely change everything to make the main form based on the
> Oracle data, but that would require a lot of other changes.
>
> Grabbing the data and putting it on an unbound form is another option but
> the users want to see live data.
>
> Any help is figuring this out is appreciated.
>
> Bryan..
>
I had the same problem that you describe, Oracle passing through Access 2003
(I
wonder if it is fixed in Access 2010?). My query had two "memo"
fields in the return. Removing them eliminated the error, but left me still
looking for a way to get the content of the memo fields.