Re: After applying hotfix build version 8.00.0859 got Invalid curs

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 23:15:36 +0100

Hi

Yes, it is fixed in that hotfix. That hotfix is the highest publicly
available hotfix without having to call Microsoft PSS.

regards 

-- 
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"UncleSam89" <UncleSam89@discussions.microsoft.com> wrote in message
news:5469B696-1D94-41E2-A8D4-3DE39C90567D@microsoft.com...
> Thank you very much for replying, but I have a question:
> KB article 838166 which you reffered me to mentioned BizTalk Server
> 2004,which I don't need.Did this hot fix contained actually hot fix to my
hot
> fix problem?
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > Install hotfix 878.
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
> >
> > Regards
> > --------------------------------
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "UncleSam89" <UncleSam89@discussions.microsoft.com> wrote in message
> > news:289B3A96-34C6-4188-800A-C3635AEB984E@microsoft.com...
> > > In order to install SQL Server 2000 Report Service I applied that
stupid
> > hot
> > > build and got message :
> > > ODBC: [Microsoft][ODBC SQL Server Driver]Invalid cursor state
> > > in Enterprise Manager (which is not terrible because I can do the same
> > tasks
> > > in Query Analyzer) and when I debugging my extended stored procedures
> > working
> > > with my stored procedure with server cursor I saw in debugger that in
> > > sequential calls(while loop from stored procedure) there is different
> > MaxLen
> > > and type of parameters for the parameter.
> > > So the last thing suggest that problem belong not only to ODBC or User
> > > interface,but maybe more serious.
> > > I found in Microsoft Knowledge base article 831997 about hot fix to
fix
> > this
> > > particular problem,but no download info.
> > > Waiting for SQL Server 2000 SP4 (which will include cleaner versions
of
> > all
> > > those fixes) will take more than 3 months.
> > > Reporting Server is less important to me than above described stored
> > > procedures.
> > > What will be the better option to try get this hot fix(how?), or to
format
> > > whole partition and reinstalling from scratch Windows server 2003,
Office
> > > VS.NET and SQL Server 2000?
> >
> >
> >

Relevant Pages