Showing posts with label values. Show all posts
Showing posts with label values. Show all posts

Thursday, March 29, 2012

Error when using rsconfig utility

When i try to use the rsconfig utility to add the values to the

<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>

The WMI Provider returned an error: HRESULT=0x8004021D

I too am getting this error. Has any resolution been found?

Error when using rsconfig utility

When i try to use the rsconfig utility to add the values to the

<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>

The WMI Provider returned an error: HRESULT=0x8004021D

I too am getting this error. Has any resolution been found?

Error when using a stored procedure in OLE DB source

I am trying to use a stored procedure in the OLE DB source, I am using the SQL Command for the Data Access mode. It returns values when using the preview but when I test the package I receive the error, "A rowset based on the SQL command was not returned by the OLE DB provider."how is the ole db source configured?|||For the the connection manager I just have a basic connection to the Sql server and then I am using the SQL command for the data access mode. The connection manager does work when I use other access modes like the table and view option.|||how is the connection manager configured? you may need to use a different configuration.|||ConnectionManagerType = OLEDB
Data Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True;
DataSourceID =
DelayValidation = False
Description =
RetainSameConnection = False
SupportsDTCTransactions = True|||

DustinT wrote:

ConnectionManagerType = OLEDB
Data Source = ABCSERVER;Initial Catalog=ABCDATABASE;Provider=SQLNCLI.1;OLE DB Services=-13;Integrated Security=SSPI;Auto Translate=True;
DataSourceID =
DelayValidation = False
Description =
RetainSameConnection = False
SupportsDTCTransactions = True

if i'm not mistaken, the sql native client provider (SQLNCLI.1) only works with sql server 2005.

if you are using a different version of sql server, then try using the microsoft ole db provider for sql server (SQLOLEDB.1)

|||See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=366077&SiteID=1

Error when trying to update

Hi All
I get this error when i open a specific table from enterprise manager and
try to update values in it.
Data has changed since the results pane was last updated. Do you want to
save your changes now?
Click Yes to save your chnages and update the database.
Click No to discard your changes and refresh the results pane.
Click Cancel to continue editing.
If i click Yes which is of course what i wnated to do from the begining i
get this error:
Row cannot be located for updating.Some values may have been changed since
it was last Read.
So i was wonderring if anybody can give me some help with that.
Thanks in Advance
Naderseems like someone else already made a change to your data or that you are
trying to make a change to a key value that is used by em to locate the
record you want to update
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Nader Galal" <ngalal@.health-insights.com> wrote in message
news:uNxO%23CD1DHA.3224@.tk2msftngp13.phx.gbl...
quote:

> Hi All
> I get this error when i open a specific table from enterprise manager and
> try to update values in it.
> Data has changed since the results pane was last updated. Do you want to
> save your changes now?
> Click Yes to save your chnages and update the database.
> Click No to discard your changes and refresh the results pane.
> Click Cancel to continue editing.
> If i click Yes which is of course what i wnated to do from the begining i
> get this error:
> Row cannot be located for updating.Some values may have been changed since
> it was last Read.
> So i was wonderring if anybody can give me some help with that.
> Thanks in Advance
> Nader
>
sql

Wednesday, March 7, 2012

Error using more than one dataset

Hi,

I have a problem using more than one dataset to create my report. I wish to use data from one stored procedure to create the values for a combobox, that I use as input to another stored procedure.

When I create more than one dataset and set up my report parameters to use one of them to create comboboxes, I get the following error, when I want to see the preview:

An error occured during local report processing.

The definition of the report '/StockInTrade' is invalid.

The data set name is missing in the data region 'DataSetName'

The report worked just fine when I used hardcodede values for my combobox. The error occurs as soon as I define more than one dataset (meaning it fails even before I try to use the second dataset as report parameter values).

Does anyone know what I am doing wrong?

-- Heidi :-)

The error occured because I had a table without a dataset attached!