> Here's a situation. ASP code creates Connection and Recordset objects, and
> uses .AddNew function to add a record to the table.

> No matter what Recordset
> parameters I specify, I cannot get @@identity field back.

"A_X_L_V" <aleksl_at_aol_dot_com_> wrote in message
news:Oz$9SK0lDHA.1728@TK2MSFTNGP09.phx.gbl...
> May not be the right group to post, but...
>
> Here's a situation. ASP code creates Connection and Recordset objects, and
> uses .AddNew function to add a record to the table. No matter what
Recordset
> parameters I specify, I cannot get @@identity field back.
>
> Micr$oft claims it works in this article
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate_topic5.asp
> and it may work for Client-Server, but I am struggling to make it work in
> ASP (IIS 5, Win2K Server).
>
> I have to user AddNew method, because I am inserting data into a Text(16)
> field. Can't really use stored proc to do that because inserted text is
> larger than 8000 chars. MSDN recommends to use "SET NOCOUNT ON;INSERT
> ...;SELECT @@IDENTITY as ID;SET NOCOUNT OFF;" query for insertion, but I
> can't use that again for the reason above - I am using
> adoRS.Fields("mytext").AppendChunk to insert data.
>
> Please help or direct me to the right newsgroup.
>
> Thanks
>
>