Intersolv DDTK, Stored Procedures, and Oracle 7 ODBC

From: AndyWa <andywa_at_aol.com>
Date: 1996/05/31
Message-ID: <4ood39$lor_at_newsbf02.news.aol.com>#1/1


I am working on a Windows/Oracle app in VC++ using Intersolv's DDTK. So far I have been able to call stored procedures with INPUT-OUTPUT and OUTPUT parameters ONLY with one of Intersolv's ODBC drivers. Unfortunately, I can't distribute the app without paying their royalty for the ODBC driver. I really want to use Oracle's ODBC driver 1.11.0.2 but can't get OUTPUT values returned to the calling program. In fact, I can't even use the standard '{ call proc(?,?,?) }' syntax with Intersolv's DDTK library and the Oracle ODBC driver without getting Invalid SQL syntax messages in the SQL.LOG file created by ODBC. Obviously, neither company is particularly helpful when it comes to interfacing with the other company's software (big surprise!).

The question: Does anyone know of a way to call stored procedures using Intersolv's toolkit and the Oracle 7 ODBC driver? Or, do I just forget Intersolv in this case and use direct ODBC calls?

Please Email. Thanks
Andy Washburn
Ocean Breeze Computing, Inc
Orlando, FL
andywa_at_aol.com\ Received on Fri May 31 1996 - 00:00:00 CEST

Original text of this message