Hi Warren,

The problem solved.

I include SET NOCOUNT ON in begin of my SP

One more dobut Warren..

When I went through the OLEDB connection string, I seen a parameter called Persist...

Hi Warren,

Thanks for your quick replay

here is my connection string

Dim Cn as NEW ADODB.Connection

With CN

.Connectionstring = "Provider=SQLOLEDB.1;Data Source=FAMILYSERVER;Initial Catalog=famDB;User ID=manoj;Password=man123"

.ConnectionTimeout = 100

.CursorLocation = adUserClient

.Open

End With

I also...