ODBC Passthru from EXCEL 5.0 to ORACLE 7.2

From: Rick Pittard <ripittard_at_amoco.com>
Date: 1997/08/04
Message-ID: <33E62956.59A9@amoco.com>#1/1

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