Accessing output parameter in Stored Proc. using OBDC API...

hi pals,
I would like to ge the output parameter using ODBC API, say
SQLExecDirect("EXEC SP_New") . How could I get the output parameter value
from my application?
note: forgive me if this group is not a relevant one.
Thanks and Regards,
shahul.Hi
For bound parameters you can call SQLBindParameter
http://msdn.microsoft.com/library/d...r />
_729e.asp
Also check out:
http://msdn.microsoft.com/library/d...>
t10_7t2s.asp
and the sample ProcessReturnCodes.cpp.
More information is at
http://support.microsoft.com/defaul...kb;en-us;152174
For unbound parameters you can call SQLGetData e.g.
http://support.microsoft.com/defaul...kb;en-us;241147
John
"Shahul" wrote:

> hi pals,
> I would like to ge the output parameter using ODBC API, say
> SQLExecDirect("EXEC SP_New") . How could I get the output parameter value
> from my application?
> note: forgive me if this group is not a relevant one.
>
> Thanks and Regards,
> shahul.
>
>

Accessing output parameter in Stored Proc. using OBDC API...

hi pals,
I would like to ge the output parameter using ODBC API, say
SQLExecDirect("EXEC SP_New") . How could I get the output parameter value
from my application?
note: forgive me if this group is not a relevant one.
Thanks and Regards,
shahul.
Hi
For bound parameters you can call SQLBindParameter
http://msdn.microsoft.com/library/de...dbc_b_729e.asp
Also check out:
http://msdn.microsoft.com/library/de...cht10_7t2s.asp
and the sample ProcessReturnCodes.cpp.
More information is at
http://support.microsoft.com/default...b;en-us;152174
For unbound parameters you can call SQLGetData e.g.
http://support.microsoft.com/default...b;en-us;241147
John
"Shahul" wrote:

> hi pals,
> I would like to ge the output parameter using ODBC API, say
> SQLExecDirect("EXEC SP_New") . How could I get the output parameter value
> from my application?
> note: forgive me if this group is not a relevant one.
>
> Thanks and Regards,
> shahul.
>
>

Accessing output parameter in Stored Proc. using OBDC API...

hi pals,
I would like to ge the output parameter using ODBC API, say
SQLExecDirect("EXEC SP_New") . How could I get the output parameter value
from my application?
note: forgive me if this group is not a relevant one.
Thanks and Regards,
shahul.Hi
For bound parameters you can call SQLBindParameter
http://msdn.microsoft.com/library/d...r />
_729e.asp
Also check out:
http://msdn.microsoft.com/library/d...>
t10_7t2s.asp
and the sample ProcessReturnCodes.cpp.
More information is at
http://support.microsoft.com/defaul...kb;en-us;152174
For unbound parameters you can call SQLGetData e.g.
http://support.microsoft.com/defaul...kb;en-us;241147
John
"Shahul" wrote:

> hi pals,
> I would like to ge the output parameter using ODBC API, say
> SQLExecDirect("EXEC SP_New") . How could I get the output parameter value
> from my application?
> note: forgive me if this group is not a relevant one.
>
> Thanks and Regards,
> shahul.
>
>