"sp_cursor" error while printing web report using Reporting Servic

Hi there,
We're using MS SQL 2000 with MS Server 2003. It's a Xeon ( single processor)
based Server with 1GB RAM.
We also use 'Reporting Services' to generate web reports.
The problem is , our application will have problem writing ( ie. INSERT
INTO) to the transaction database if the web reporting is printing data from
the same transaction table.
Following errors were captured in our application.
_sp_cursor:_The_cursor_identifier_value_provided_(xxxxxxx)_is_not_valid
where xxxxxx cpuld be some kind of hex codes , for example 'abcdf08'
,'abcdf03' etc.
Could the MS SQL Server not able to cope during high traffic?
Pls. help.
Thanks.
CD MooHi
This sounds like you may have blocking/deadlocking which rolls back the
reporting services connection. To monitor this check out
http://support.microsoft.com/kb/271509/EN-US/. If you do not need to report
on the currently live data, then you would be better creating a copy
periodically and point the reports to that. If you need more up-to-date data
you may want to check out log shipping. With SQL 2005 you could use database
snapshots for this purpose.
John
"CD Moo" wrote:
> Hi there,
> We're using MS SQL 2000 with MS Server 2003. It's a Xeon ( single processor)
> based Server with 1GB RAM.
> We also use 'Reporting Services' to generate web reports.
> The problem is , our application will have problem writing ( ie. INSERT
> INTO) to the transaction database if the web reporting is printing data from
> the same transaction table.
> Following errors were captured in our application.
> _sp_cursor:_The_cursor_identifier_value_provided_(xxxxxxx)_is_not_valid
> where xxxxxx cpuld be some kind of hex codes , for example 'abcdf08'
> ,'abcdf03' etc.
> Could the MS SQL Server not able to cope during high traffic?
> Pls. help.
> Thanks.
> CD Moo
>|||Hi there,
We're using SQL Server 2000 with the latest service pack.
I have 2 SQL Servers, Server1 & Server2.
I created a table named Trade in Server1.
Created a view named vwTrade in Server2.
At first, I can see the data from vwTrade. Then I deleted the content of
Trade. Uploaded it with a new set of data using DTS from a foxpro database.
but after that, it is can no longer be seen in vwTrade. If I create another
view named vwTrade2 in Server1, it works fine. But when the view is
recreated in Server2, it just give and empty rowset.
Regards,
Jefrey

"sp_cursor" error while printing web report using Reporting Servic

Hi there,
We're using MS SQL 2000 with MS Server 2003. It's a Xeon ( single processor)
based Server with 1GB RAM.
We also use 'Reporting Services' to generate web reports.
The problem is , our application will have problem writing ( ie. INSERT
INTO) to the transaction database if the web reporting is printing data from
the same transaction table.
Following errors were captured in our application.
_sp_cursor:_The_cursor_identifier_value_
provided_(xxxxxxx)_is_not_valid
where xxxxxx cpuld be some kind of hex codes , for example 'abcdf08'
,'abcdf03' etc.
Could the MS SQL Server not able to cope during high traffic?
Pls. help.
Thanks.
CD MooHi
This sounds like you may have blocking/deadlocking which rolls back the
reporting services connection. To monitor this check out
http://support.microsoft.com/kb/271509/EN-US/. If you do not need to report
on the currently live data, then you would be better creating a copy
periodically and point the reports to that. If you need more up-to-date data
you may want to check out log shipping. With SQL 2005 you could use database
snapshots for this purpose.
John
"CD Moo" wrote:

> Hi there,
> We're using MS SQL 2000 with MS Server 2003. It's a Xeon ( single processo
r)
> based Server with 1GB RAM.
> We also use 'Reporting Services' to generate web reports.
> The problem is , our application will have problem writing ( ie. INSERT
> INTO) to the transaction database if the web reporting is printing data fr
om
> the same transaction table.
> Following errors were captured in our application.
> _sp_cursor:_The_cursor_identifier_value_
provided_(xxxxxxx)_is_not_valid
> where xxxxxx cpuld be some kind of hex codes , for example 'abcdf08'
> ,'abcdf03' etc.
> Could the MS SQL Server not able to cope during high traffic?
> Pls. help.
> Thanks.
> CD Moo
>

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim MorrisonTim Morrison wrote:
> I have customers that are starting to get "Invalid Cursor State"
> messages returned from my Clarion MS-SQL. based application.
>
Tried reading this article?
http://support.microsoft.com/kb/831997
- Peter
--
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
>> I have customers that are starting to get "Invalid Cursor State"
>> messages returned from my Clarion MS-SQL. based application.
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim Morrison
Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"Invalid Cursor State" - REPOST

MS-SQL 2000, Service Pack 3a and 4
I have customers that are starting to get "Invalid Cursor State" messages
returned from my Clarion MS-SQL. based application.
It appears to happen when i am issuing a "SELECT SUM(TOTAL) FROM..."
statement, but i can be sure of that. I cant pinpoint when the problem
starts. The solution has been to close the screen im on, which closes
connection to the database.
Where can i start to look for this problem?
TIA
Tim MorrisonTim Morrison wrote:

> I have customers that are starting to get "Invalid Cursor State"
> messages returned from my Clarion MS-SQL. based application.
>
Tried reading this article?
http://support.microsoft.com/kb/831997
- Peter
Hi! I'm a .signature *virus*!
Copy me into your ~/.signature to help me spread!|||Yup. SP4 is applied to the machine giving me the most problems. It does
however happen to SP3a machines as well.
Tim
"Peter Lykkegaard" <plykkegaard@.nospam.nospam> wrote in message
news:eZOsIYKPHHA.1248@.TK2MSFTNGP02.phx.gbl...
> Tim Morrison wrote:
>
> Tried reading this article?
> http://support.microsoft.com/kb/831997
> - Peter
> --
> Hi! I'm a .signature *virus*!
> Copy me into your ~/.signature to help me spread!
>

"CREATE TABLE" for files *.dbf with a custom float column

How to create dbase file based on SQL-92 which have a FLOAT column like
float(14,2):
=> xxxxxxxxxxxxxx,xx <=
Thanks in advance,
PatriceN(14,2)
"news.microsoft.com" <reprotechnic@.wanadoo.fr> escribi en el mensaje
news:u37grkt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
> How to create dbase file based on SQL-92 which have a FLOAT column like
> float(14,2):
> => xxxxxxxxxxxxxx,xx <=
> Thanks in advance,
> Patrice
>|||this solution doesn't run. it makes a float column of (20,4).
With more precision, i test this with odbc.net from Framework.NET v1.1
"Luis Camacho" <luibrac@.yahoo.com.ar> a crit dans le message de
news:%23VMvv5K$DHA.1036@.TK2MSFTNGP10.phx.gbl...
> N(14,2)
> "news.microsoft.com" <reprotechnic@.wanadoo.fr> escribi en el mensaje
> news:u37grkt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
>|||N(14,2): This does not work and gives a syntax error on command.
AndreB.
"Luis Camacho" <luibrac@.yahoo.com.ar> a crit dans le message de
news:%23VMvv5K$DHA.1036@.TK2MSFTNGP10.phx.gbl...
> N(14,2)
> "news.microsoft.com" <reprotechnic@.wanadoo.fr> escribi en el mensaje
> news:u37grkt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
>