ODBC question

From: Sam Brown <brown_at_technovations.com>
Date: 1997/05/21
Message-ID: <3383B659.66DD@technovations.com>#1/1

This may be a trivial question for you gurus out there. I did not find a newsgroup which deals specifically with ODBC issues, so here goes...

There seems to be a different calling syntax in SQLExecDirect() for stored procedures through ODBC.

For example,

the query for SQlServer can be in native form (surprise, surprise..)

<stored_procedure_name>

But using the Oracle ODBC driver, the syntax has to be

Begin
<stored_procedure_name>;

End;

Does anyone know what this would be using other ODBC drivers which interface to Sybase, Informix, Db2, progress, etc ? Is this documented somewhere for the "over 50 drivers" that ODBC supports ?

Thanks in advance.

Sam Received on Wed May 21 1997 - 00:00:00 CDT