Ajit
Mon Oct 04 11:38:57 CDT 2004
Dim oCmd As SqlCommand
oCmd = New SqlCommand("sp_processWeeklytask", oConn)
oCmd.CommandType = CommandType.StoredProcedure
oCmd.CommandTimeout = 0
oCmd.ExecuteNonQuery()
I am using ADO.Net
"W.G. Ryan eMVP" <WilliamRyan@gmail.com> wrote in message
news:uQqp7BjqEHA.3700@TK2MSFTNGP15.phx.gbl...
> Are you using ADO.NET or ADO v 2.x? Can you post the code you're using?
>
> --
> W.G. Ryan, MVP
>
> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> "Ajit" <adeogade@thedebtmediator.com> wrote in message
> news:%23w4BK2iqEHA.3244@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > My stored procedure was working fine but when i made added 2 fields to
my
> > table and then made subsequent changes to my sp it give me the following
> > error:
> >
> > "Could not complete cursor operation because the table schema changed
> after
> > the cursor was declared"
> >
> > it works fine from back end (query analyser) but when i execute from my
> dot
> > net code it give the above error.
> >
> > does anyone help please ?
> >
> >
>
>