scope_identity through ODBC

I have a problem retrieving the scope_identity through an ODBC connection (Excel for Example). It returns null.
Any idea?
Thanks
Being that it would need to be an insert statement, are you
sure the statement is successfully executing? You could
monitor this with Profiler.
-Sue
On Thu, 8 Apr 2004 04:46:05 -0700, George Keradinides
<anonymous@.discussions.microsoft.com> wrote:

>I have a problem retrieving the scope_identity through an ODBC connection (Excel for Example). It returns null.
>Any idea?
>Thanks
>