Re: ODBC Passthru from EXCEL 5.0 to ORACLE 7.2

On Mon, 04 Aug 1997 14:11:18 -0500, Rick Pittard <ripittard_at_amoco.com> wrote:

Check the SqlNet trace to see the SqlStmt going across to Oracle. Compare that to the SqlStmt you've passed to SQLExecDirect(). That may provide you with some clues as to what is happenning.

Hope this helps.
sm

>I am trying to understand how to implement a "passthru" request to an
>Oracle database. I need to bypass the limited SQL support that Excel
>has because of the need to run a "non-standard ODBC" request. The
>request works fins under VB's DAO when I use the passthru option.
>However, for direct use of ODBC.DLL I am not sure how to do this. The
>system keeps telling me that my syntax is incorrect so I need to set
>some option. Any ideas?
>
>Right know the sequence of commands is:
>SQLAllocEnv
>SQLAllocConnect
>SQLConnect
>SQLAllocStmt
>
>SQLExecDirect
>
>...
>
>When ever I use the non-standard SQL with SQLExecDirect I get a return
>code of -1. The response from SQLError gives an ERRORCODE of 900 with
>message of "[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00900: invalid
>SQL statement."
>
>Any help would be appreciated.
Received on Mon Aug 04 1997 - 00:00:00 CDT