Problem with BOF and EOF

I have a adodb connection to a access database and the connection is opened. I want to be able to navigate the records using buttons (first, previous, next and last) and output the data into textboxes. I want to disable the buttons first and previous if BOF is true and next and last if EOF is true.

My problem is that i'm doing the check algorithm when the click event is pressed (set all buttons false, if EOF is false, enabled last and next buttons, if BOF is false, enable first and previous buttons. However, when i test it and click next until it reaches the last record, i have to click it one more time for it to be disabled:

rs a recordset object

Private Function checkRecord() As Boolean

checkRecord = True
tsbLast.Enabled = False
tsbNext.Enabled = False
tsbFirst.Enabled = False
tsbPrevious.Enabled = False
If Not rs.EOF Then
rs.MoveNext()
If Not rs.EOF Then
tsbLast.Enabled = True
tsbNext.Enabled = True
Else
checkRecord = False
End If
rs.MovePrevious()
End If

If Not rs.BOF Then
rs.MovePrevious()
If rs.BOF Then
checkRecord = False
Else
tsbFirst.Enabled = True
tsbPrevious.Enabled = True
End If
rs.MoveNext()
End If

End Function

Is there a cursor location property that returns a integer identifying location of the record? I really hate how BOF and EOF returns true only if the current cursor location is after the last or before the first (its like starting an index at -1, and not 0, and i can't add or subtract from the EOF and BOF indices) or a much more efficient way of doing this?

You might want to look into using the recordset object's AbsolutePosition property. Combined with the Recordcount property, you should be able to determine your current location at all times. Note this depends on the underlying OLEDB provider you are using. For more information please visit http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdproabpos.asp

Regards, Uwa.

|||

Hello,

What I've done in the past with ado to get around this is to create a member variable, called say "_CurrentPosition" that I set to 0 when I first populate the RS, then increment/decrement when MoveN is called. This way, you can just check the _CurrentPosition variable to achieve what you want:

if (CurrentPosition == rs.RecordCount)

{

// disable move next button etc

}

else if (CurrentPosition = 0) //or 1 if you didn't create it as zero-based!

{

// disable move first button etc

}

I know it's not exactly what you're after, but there is no native property/method that ado exposes. As you may have discovered, the EndOfRecordset event fires only after you attempt to move beyong EOF...

Cheers,

Rob

|||

Hello,

Just seconding what Uwa said: be careful using the AbsolutePosition property as this is provider dependent and I have never been able to utilise it with any degree of confidence.

Cheers,

Rob

|||You can try using ADO Data Control. You can find an example at - http://www.devarticles.com/c/a/Visual-Basic/Implementing-An-ADO-Data-Control-With-VB6/|||Thanks for all the replies, it seems that using OleDB as the provider instead of ADODB would make the most sense. It is a bit more coding, but not enough to persuade me to mess with ADO

problem with bit datatype conversion

Hi All,

I have create following table and inserted few records

Code Snippet

USE

---

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_position](
[part] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[price] [money] NOT NULL,
[opt] [bit] NOT NULL
) ON [PRIMARY]

I am executing following procedure to update the table.

Code Snippet

USE

---

GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[PROC1] ( @.part varchar(20), @.PRICE MONEY, @.OPT BIT )
AS
BEGIN
declare @.sSQL as nvarchar(max);
SET @.sSQL = 'update tbl_position set opt=@.OPT,price=@.PRICE WHERE part = '+ @.part;
exec sp_executesql @.sSQL
END

ex:

Code Snippet

exec PROC1 1,2.50,0

but I am getting following error

Code Snippet

Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@.OPT".

I am struck up with this query .

Please Help me regarding this issue.

Regards
Gomaz

Code Snippet

CREATE PROCEDURE [dbo].[PROC1] ( @.part varchar(20), @.PRICE MONEY, @.OPT BIT )

AS

BEGIN

declare @.sSQL as nvarchar(max);

SET @.sSQL = 'update tbl_position set opt=' +cast(@.OPT as char(1) )+',price='+@.PRICE+' WHERE part = '+ @.part;

exec sp_executesql @.sSQL

END

sp_executesql execute query in different bacth. As you couldn't use opt=@.OPT

Problem with big transfer

Hi,
I have MSSQl 2000 , SP3 with WIn2000
when I transfer from one table to another, 115852 records, le server hangs.
I tried with 70000 records and it worked. even with 90000 records.
With more than 90000 records, the server hangs.
Any idea ? It might be a bug in MSSQLsvr ? any known bugs ?
Thanks for your help
OlivierHi
How do you transfer the data?
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:e4t6$UySFHA.628@.tk2msftngp13.phx.gbl...
> Hi,
>
> I have MSSQl 2000 , SP3 with WIn2000
> when I transfer from one table to another, 115852 records, le server
hangs.
> I tried with 70000 records and it worked. even with 90000 records.
> With more than 90000 records, the server hangs.
> Any idea ? It might be a bug in MSSQLsvr ? any known bugs ?
> Thanks for your help
> Olivier
>
>|||Using UPDATE table set (select ...) with T SQL
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ORiGwYySFHA.2916@.TK2MSFTNGP15.phx.gbl...
> Hi
> How do you transfer the data?
> "oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
> news:e4t6$UySFHA.628@.tk2msftngp13.phx.gbl...
> hangs.
>|||Hi
I have just finished test to UPDATE table with 200K rows and have not met
any problems.
Do you update a PK also?
What is about memory? 2GB or more?
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:OBSJ$kySFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Using UPDATE table set (select ...) with T SQL
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ORiGwYySFHA.2916@.TK2MSFTNGP15.phx.gbl...
>sql

Problem with big data transfer

Hi,
I have MSSQl 2000 , SP3 with WIn2000
when I transfer from one table to another, 115852 records, le server hangs.
I tried with 70000 records and it worked. even with 90000 records.
With more than 90000 records, the server hangs.
Any idea ? It might be a bug in MSSQLsvr ? any known bugs ?
Thanks for your help
Olivier
How are you transferring the data?
I have used BCP, DTS and T-SQL to "transfer" data from one location to
another. I have successfully transferred more than 10x the data you are
talking about. I used T-SQL for table-table transfer (within the same
server) and DTS for server-server transfer.
Keith
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:uNrXWVySFHA.3176@.TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I have MSSQl 2000 , SP3 with WIn2000
> when I transfer from one table to another, 115852 records, le server
> hangs.
> I tried with 70000 records and it worked. even with 90000 records.
> With more than 90000 records, the server hangs.
> Any idea ? It might be a bug in MSSQLsvr ? any known bugs ?
> Thanks for your help
> Olivier
>
>
|||I am transfering using UPDATE Table SET (SELECT ...)
from one table to another table within the same server
That s strange
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:eC2qgcySFHA.2324@.TK2MSFTNGP10.phx.gbl...
> How are you transferring the data?
> I have used BCP, DTS and T-SQL to "transfer" data from one location to
> another. I have successfully transferred more than 10x the data you are
> talking about. I used T-SQL for table-table transfer (within the same
> server) and DTS for server-server transfer.
> --
> Keith
>
> "oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
> news:uNrXWVySFHA.3176@.TK2MSFTNGP09.phx.gbl...
>
|||When the "transfer" (UPDATE) statement fails what error do you receive? I
am guessing that the drive with your data or log file on it is full. Do you
receive an error along the lines of "cannot allocate space...full?"
Keith
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:uM2vJkySFHA.2128@.TK2MSFTNGP14.phx.gbl...
>I am transfering using UPDATE Table SET (SELECT ...)
> from one table to another table within the same server
> That s strange
>
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:eC2qgcySFHA.2324@.TK2MSFTNGP10.phx.gbl...
>
|||First check your source table .... can you retrieve more than 90000 row
from source table ?
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:eX91hsySFHA.584@.TK2MSFTNGP15.phx.gbl...
> When the "transfer" (UPDATE) statement fails what error do you receive? I
> am guessing that the drive with your data or log file on it is full. Do
you[vbcol=seagreen]
> receive an error along the lines of "cannot allocate space...full?"
> --
> Keith
>
> "oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
> news:uM2vJkySFHA.2128@.TK2MSFTNGP14.phx.gbl...
are
>
|||yes, i run the SQL query SELECT top 90000 and it worked.
i even put the data in two different tables and i managed to transfer them
but when i try to transfer all in one go, it hangs
one of my colleague find that
http://support.microsoft.com/?kbid=892205
can it be the cause ?
"John" <joh@.mailcity.com> wrote in message
news:%23crW6ozSFHA.3980@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> First check your source table .... can you retrieve more than 90000 row
> from source table ?
>
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:eX91hsySFHA.584@.TK2MSFTNGP15.phx.gbl...
I[vbcol=seagreen]
> you
to[vbcol=seagreen]
> are
same[vbcol=seagreen]
server
>
|||SELECT top 90000 * from tablename order by 1 desc
is it working ? I am just woundering like your table is alright or not...
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:erAp#B0SFHA.3156@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> yes, i run the SQL query SELECT top 90000 and it worked.
> i even put the data in two different tables and i managed to transfer them
> but when i try to transfer all in one go, it hangs
> one of my colleague find that
> http://support.microsoft.com/?kbid=892205
>
> can it be the cause ?
>
>
>
>
> "John" <joh@.mailcity.com> wrote in message
> news:%23crW6ozSFHA.3980@.TK2MSFTNGP12.phx.gbl...
row[vbcol=seagreen]
receive?[vbcol=seagreen]
> I
Do[vbcol=seagreen]
> to
you[vbcol=seagreen]
> same
> server
records.
>
|||this command is working
My server is using Hyper threading, is this ring a bell ?
"John" <joh@.mailcity.com> wrote in message
news:etGP8E0SFHA.3184@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> SELECT top 90000 * from tablename order by 1 desc
> is it working ? I am just woundering like your table is alright or not...
>
> "oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
> news:erAp#B0SFHA.3156@.TK2MSFTNGP15.phx.gbl...
them[vbcol=seagreen]
> row
> receive?
> Do
location
> you
> records.
>
|||Hi
Probably not. Does sp_who2 show increasing CPU and IO whilst the process has
"hung"?
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/
"oLiVieR CheNeSoN" <ocheneson@.hotmail.com> wrote in message
news:%237TiTK0SFHA.612@.TK2MSFTNGP12.phx.gbl...
> this command is working
> My server is using Hyper threading, is this ring a bell ?
>
>
> "John" <joh@.mailcity.com> wrote in message
> news:etGP8E0SFHA.3184@.TK2MSFTNGP14.phx.gbl...
> them
> location
>

Problem with AddNew on SQL server in c++ 2003

Hello,
I created a very simple database with only one table (Records) and on
that table only one column (Category datatype nvarchar).
I am trying to use the AddNew ado example found on msnd but it always
inserts a null value instead of the value I am trying to insert.
All my HRESULTs say S_OK but the CategoryStatus is alway 3 (which is
null).
I am using UNICODE.
I can insert records just fine if I use the INSERT INTO command but I
am not having any luck with the AddNew API.
Can anyone help?
Here is my code:
class CJournalRecord :public CADORecordBinding
{
BEGIN_ADO_BINDING(CJournalRecord)
ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, Category, sizeof(Category),
CategoryStatus, TRUE)
END_ADO_BINDING()
public:
CString Category;
ULONG CategoryStatus;
};
HRESULT hr = S_OK;
_RecordsetPtr pRstEvents = NULL;
IADORecordBinding *picRs = NULL;
hr = pRstEvents.CreateInstance(__uuidof(Recordset));
if (hr != S_OK)
{
}
else
{
//the connection is already open
CJournalRecord newEvent;
hr = pRstEvents->Open(_T("Records"),_variant_t((IDispatch *)
connection, true),adOpenKeyset,adLockOptimistic,adCm
dTable);
//Open an IADORecordBinding interface pointer which we'll use for
Binding Recordset to a class
hr =
pRstEvents-> QueryInterface(__uuidof(IADORecordBindin
g),(LPVOID*)&picRs);
hr = picRs->BindToRecordset(&newEvent);
newEvent.Category = _T("SeeYou");
newEvent.CategoryStatus = adFldNull;
if(hr!=S_OK)
{
}
else
{
hr = picRs->AddNew(&newEvent);
int status = (int)newEvent.CategoryStatus;
//hr = pRstEvents->Update();
}
}Try creating a stored procedure and executing that. Using AddNew from the
middle tier is kinda hokey.
<roberta.coffman@.emersonprocess.com> wrote in message
news:1134768159.533377.64050@.g43g2000cwa.googlegroups.com...
> Hello,
> I created a very simple database with only one table (Records) and on
> that table only one column (Category datatype nvarchar).
> I am trying to use the AddNew ado example found on msnd but it always
> inserts a null value instead of the value I am trying to insert.
> All my HRESULTs say S_OK but the CategoryStatus is alway 3 (which is
> null).
> I am using UNICODE.
> I can insert records just fine if I use the INSERT INTO command but I
> am not having any luck with the AddNew API.
> Can anyone help?
> Here is my code:
> class CJournalRecord :public CADORecordBinding
> {
> BEGIN_ADO_BINDING(CJournalRecord)
> ADO_VARIABLE_LENGTH_ENTRY2(1, adVarChar, Category, sizeof(Category),
> CategoryStatus, TRUE)
> END_ADO_BINDING()
> public:
> CString Category;
> ULONG CategoryStatus;
> };
> HRESULT hr = S_OK;
> _RecordsetPtr pRstEvents = NULL;
> IADORecordBinding *picRs = NULL;
> hr = pRstEvents.CreateInstance(__uuidof(Recordset));
> if (hr != S_OK)
> {
> }
> else
> {
> //the connection is already open
> CJournalRecord newEvent;
> hr = pRstEvents->Open(_T("Records"),_variant_t((IDispatch *)
> connection, true),adOpenKeyset,adLockOptimistic,adCm
dTable);
> //Open an IADORecordBinding interface pointer which we'll use for
> Binding Recordset to a class
> hr =
> pRstEvents-> QueryInterface(__uuidof(IADORecordBindin
g),(LPVOID*)&picRs);
> hr = picRs->BindToRecordset(&newEvent);
> newEvent.Category = _T("SeeYou");
> newEvent.CategoryStatus = adFldNull;
> if(hr!=S_OK)
> {
> }
> else
> {
> hr = picRs->AddNew(&newEvent);
> int status = (int)newEvent.CategoryStatus;
> //hr = pRstEvents->Update();
> }
> }
>|||I'm not sure binding to the CString Category works here, also
sizeof(Category) is pretty meaningless. Suggest you change
CString to a fixed sized array to mirror the size of the column
in your table, i.e. change
CString Category;
to
CHAR Category[80];

Problem with added data from external gathering software to SQL DB

Hello
Im used SQL server 2000 with Services pack 3
i have problem if external program "gathercoda" want adding records to sql
db.
error message:
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, Start
to read the metrics
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
"RDS_LINUX_FILESYSTEMS"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
"RDS_LINUX_DISKSIZES"
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, 117
matched metrics available
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL records are up to date with 86400 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
UPTIME records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
APPLICATION records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
TRANSACTIONS records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (6)2648) server_where_gathercoda_gathering_data,
Validating metrics for GLOBAL::CODA
2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
00:00:00)
2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data, Read
14 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; SELECT
permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (5)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (2)2648) Cannot use bulk append; SELECT permission
denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (2)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
invalid at this time
2005/06/30 13:53:23 (5)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
at this time
2005/06/30 13:53:23 (1)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
2005/06/30 13:53:23 (9)2648) Exception attempting to close ignored;
SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; SELECT
permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (5)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (2)2648) Cannot use bulk append; SELECT permission
denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (2)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9)2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
invalid at this time
2005/06/30 13:53:23 (5)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
2005/06/30 13:53:23 (1)2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
03:00:00)
2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data, Read
11 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL_CODA records are up to date with 86400 second summarization
2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (4)2648) server_where_gathercoda_gathering_data,
Collected 0 records for RDS_GLOBAL_CODA
2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data,
Collected 0 records in 0: 0: 2
2005/06/30 13:53:23 (E)2648) GatherCODA Exception: Memory access violation
2005/06/30 13:53:23 (6)2648) End of Program
can u help me please
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
This looks like a permissions problem. Check to ensure that the account
being used to run this process has the needed permissions on the objects and
columns used. See GRANT in the SQL Server Books Online.
Hope this helps.
Dan Guzman
SQL Server MVP
"DoDo" <DoDo@.discussions.microsoft.com> wrote in message
news:8A74281F-A0F8-4437-A06F-E23BC8F2D1E1@.microsoft.com...
> Hello
> Im used SQL server 2000 with Services pack 3
> i have problem if external program "gathercoda" want adding records to sql
> db.
> error message:
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Start
> to read the metrics
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec ->
> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, 117
> matched metrics available
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6)2648) server_where_gathercoda_gathering_data,
> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
> 00:00:00)
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA',
> database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation
> invalid
> at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close ignored;
> SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA',
> database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
> 03:00:00)
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (4)2648) server_where_gathercoda_gathering_data,
> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data,
> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E)2648) GatherCODA Exception: Memory access
> violation
> 2005/06/30 13:53:23 (6)2648) End of Program
>
> can u help me please
>
|||It seems that someone has messed up the permissions for the user that this application runs as. You
should contact the vendor of the application to see what permissions is required so you can set them
properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DoDo" <DoDo@.discussions.microsoft.com> wrote in message
news:8A74281F-A0F8-4437-A06F-E23BC8F2D1E1@.microsoft.com...
> Hello
> Im used SQL server 2000 with Services pack 3
> i have problem if external program "gathercoda" want adding records to sql
> db.
> error message:
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, Start
> to read the metrics
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data, 117
> matched metrics available
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5)2648) server_where_gathercoda_gathering_data,
> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6)2648) server_where_gathercoda_gathering_data,
> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
> 00:00:00)
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data, Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
> at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3)2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9)2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close ignored;
> SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2)2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9)2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9)2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5)2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1)2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9)2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
> 03:00:00)
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data, Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (E)2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2)2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5)2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1)2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (4)2648) server_where_gathercoda_gathering_data,
> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1)2648) server_where_gathercoda_gathering_data,
> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E)2648) GatherCODA Exception: Memory access violation
> 2005/06/30 13:53:23 (6)2648) End of Program
>
> can u help me please
>