date and time diffs: hii

Showing posts with label hii. Show all posts

Tuesday, March 27, 2012

Datasource-Microsoft Visual Studio

I am new to all SQL Related. I am trying to create a datasource to our old database we used in the company to write reports on the data. when I create a new data source and enter all required info, when testing the connection, i get a reply that I do not have the necessary permissions to use this object, although my account is specified as an administrator? can somebody please explain this to me.

I am moving this to the SQL Server Security forum.|||

From where you are connecting (trying) to this new database?

Is it from Reporting services or any other application?

|||it is saved on my computer.|||You might check the permission for the user when trying to create this D-source connection, if the user do not have corresponding database privileges then it will fail.

Datasource-Microsoft Visual Studio

I am moving this to the SQL Server Security forum.|||

From where you are connecting (trying) to this new database?

Is it from Reporting services or any other application?

Datasource-Microsoft Visual Studio

Hi Hanel O,

Try posting this query to the MSDN SQL Server Data Access Forum:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1&bcsi_scan_A9C07E6225287F19=z5cf+RkCipiHryeey+QUUQYAAAAmrYMB&bcsi_scan_filename=ShowForum.aspx

Also here is the MSDN SQL Server Forum main page, where you will find many SQL forums dedicated to different aspects of Microsoft SQL Server:
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Also try looking in SQL Server Books Online, which comes as part of the SQL Server install package.

Hope this helps,

Frank

Thursday, March 22, 2012

Dataset to XML

Hi
I have an SQL Server stored procedure wich returns ceratin data and I have
it in a Dataset. I am supposed to change that data into an specific standard
XML format and write it to file.
I am using Visual Studio 2005 wich is completely new to me.
Could you help with some hints about how can I do that.
I have been looking a lot about this from the Net but every thing I have
found is very simple: GetXml() But that is not enough for me. I need to
change that XML so that I get it in the previously defined standard format
Thanks for any help
GabrielHello Gabriel,
Likely the fastest way to deal with this would be the write an XSL/T that
transforms the dataset XML to the desired format. Otherwise, if you have
SQL Server 2005 and are allowed to replace the stored procedure, you could
write a FOR XML PATH query and probably get pretty close to what you're look
ing
for straight out of SQL Server.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||Thanks a lot Kent.
I am completely new in this field and I have to study a lot. Your message
give me good hints to to start with.
greetings from Finland
Gabriel
"Kent Tegels" wrote:

> Hello Gabriel,
> Likely the fastest way to deal with this would be the write an XSL/T that
> transforms the dataset XML to the desired format. Otherwise, if you have
> SQL Server 2005 and are allowed to replace the stored procedure, you could
> write a FOR XML PATH query and probably get pretty close to what you're lo
oking
> for straight out of SQL Server.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>sql

Dataset to XML

Hi
I have an SQL Server stored procedure wich returns ceratin data and I have
it in a Dataset. I am supposed to change that data into an specific standard
XML format and write it to file.
I am using Visual Studio 2005 wich is completely new to me.
Could you help with some hints about how can I do that.
I have been looking a lot about this from the Net but every thing I have
found is very simple: GetXml() But that is not enough for me. I need to
change that XML so that I get it in the previously defined standard format
Thanks for any help
Gabriel
Hello Gabriel,
Likely the fastest way to deal with this would be the write an XSL/T that
transforms the dataset XML to the desired format. Otherwise, if you have
SQL Server 2005 and are allowed to replace the stored procedure, you could
write a FOR XML PATH query and probably get pretty close to what you're looking
for straight out of SQL Server.
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
|||Thanks a lot Kent.
I am completely new in this field and I have to study a lot. Your message
give me good hints to to start with.
greetings from Finland
Gabriel
"Kent Tegels" wrote:

> Hello Gabriel,
> Likely the fastest way to deal with this would be the write an XSL/T that
> transforms the dataset XML to the desired format. Otherwise, if you have
> SQL Server 2005 and are allowed to replace the stored procedure, you could
> write a FOR XML PATH query and probably get pretty close to what you're looking
> for straight out of SQL Server.
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>

DataSet Performance

Hi!
I've a DataTable with 100 rows and 100 columns. Then I'm updating each
column in each row. When I call the Update method on the DataAdapter, this
generates 10000 UPDATE statements.
Are there any solutions how I can create a better solution, which reduces
the UPDATE statements? Or how can I handle such big updates with SQL Server?
Thanks
Klaus Aschenbrenner
MVP Visual C#
www.csharp.at,www.anecon.com
http://weblogs.asp.net/klaus.aschenbrennerUse a stored procedure to do the update. This sounds very much like you
are using a table as an array though, which isn't generally a good way
to model data in SQL.
David Portas
SQL Server MVP
--|||I've already tried it with stored procedures and the performance isn't
better.
The problem on the data model is that the 100 rows and 100 columns are
representing a fincance plan. So each column must save additional
information (like formats, formula, ...).
So I have a table for each row (called "Position") and this table references
another table which stores the columns (called "PosVal") of the row. With
this data model I've the possibility that the table "PosVal" can reference
other tables which contains the format, formulas...
Or this there any other way to model this?
Thanks
Klaus Aschenbrenner
MVP Visual C#
www.csharp.at,www.anecon.com
http://weblogs.asp.net/klaus.aschenbrenner
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1109333983.806317.283120@.g14g2000cwa.googlegroups.com...
> Use a stored procedure to do the update. This sounds very much like you
> are using a table as an array though, which isn't generally a good way
> to model data in SQL.
> --
> David Portas
> SQL Server MVP
> --
>|||It seems like you are trying to model an abstraction ("rows", "columns"
and "formulae" from a hypothetical spreadsheet) instead of modelling
the actual data. Isn't your metadata static enough to create a proper
relational representation of it? If not then I suggest you need a
middle tier to present this data. The back end may be largely
irrelevent - I'm not sure just what benefit you are hoping to get from
using SQL Server as the data store for this.
If you do have some real data to model, then A) Normalize your tables,
B) post a CREATE TABLE statement and your stored proc. Since your proc
can update an entire row at a time I would have expected 100 updates to
outperform 10,000 but that largely depends on how you are doing the
updates and what your data looks like.
David Portas
SQL Server MVP
--|||Klaus Aschenbrenner wrote:
> Hi!
> I've a DataTable with 100 rows and 100 columns. Then I'm updating each
> column in each row. When I call the Update method on the DataAdapter,
> this generates 10000 UPDATE statements.
> Are there any solutions how I can create a better solution, which
> reduces the UPDATE statements? Or how can I handle such big updates
> with SQL Server?
>
Are you using the CommandBuilder to generate the code? It probably makes
more sense to write the code yourself.
You stated in a subsequent reply that you created a stored procedure to do
the update but that it did not improve performance. Could you elaborate on
what the procedure did? I'm assuming you created a procedure that accepted
parameters for each of the 100 columns and did the update for an entire row
at a time, requiring 100 calls to the procedure instead of 10000 calls to a
procedure that did 1 column at a time...
Is that correct?
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.|||Klaus,
You can use SQLXML that comes with MDAC to reduce the number of hits going
to your database. You can then send an updategram. With 2.0, you have a
graceful upgrade to the Managed SQLXML driver, so it's not a deadend.
This is obviously SQL Server specific, but Oracle has other such equivalent
solutions.
- Sahil Malik
http://codebetter.com/blogs/sahil.malik/
"Klaus Aschenbrenner" <Klaus.Aschenbrenner@.anecon.com> wrote in message
news:#hBwlNzGFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi!
> I've a DataTable with 100 rows and 100 columns. Then I'm updating each
> column in each row. When I call the Update method on the DataAdapter, this
> generates 10000 UPDATE statements.
> Are there any solutions how I can create a better solution, which reduces
> the UPDATE statements? Or how can I handle such big updates with SQL
Server?
> Thanks
> Klaus Aschenbrenner
> MVP Visual C#
> www.csharp.at,www.anecon.com
> http://weblogs.asp.net/klaus.aschenbrenner
>|||First and foremost, an RDBMS is NOT FOR PERFORMANCE. You gain performance
by using the tool correctly and using the native enhancements to boost
performance. That is not to say that an RDBMS can not be fast, on the
contrary; however, that is not its chief purpose.
If performance is your ONLY concern, use a flat file or an XML file.
You use an RDBMS to MODEL THE DATA, so that others can query it in a myriad
of ways and garauntee that there results are accurate. Therefore, you have
to use the RELATIONAL rules to model your data before you build the physical
database and constrain it in order to provide DATA INTEGRITY. It is this
integrity that you build on an RDBMS system. The system is optimized for
performance, but only after providing the foundation, a relational database
properly constrained.
Sincerely,
Anthony Thomas
"Klaus Aschenbrenner" <Klaus.Aschenbrenner@.anecon.com> wrote in message
news:%23hBwlNzGFHA.2976@.TK2MSFTNGP15.phx.gbl...
Hi!
I've a DataTable with 100 rows and 100 columns. Then I'm updating each
column in each row. When I call the Update method on the DataAdapter, this
generates 10000 UPDATE statements.
Are there any solutions how I can create a better solution, which reduces
the UPDATE statements? Or how can I handle such big updates with SQL Server?
Thanks
Klaus Aschenbrenner
MVP Visual C#
www.csharp.at,www.anecon.com
http://weblogs.asp.net/klaus.aschenbrenner|||You must be a consultant. :)
- Sahil Malik
http://codebetter.com/blogs/sahil.malik/
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:OIk#AyDHFHA.3352@.TK2MSFTNGP10.phx.gbl...
> First and foremost, an RDBMS is NOT FOR PERFORMANCE. You gain performance
> by using the tool correctly and using the native enhancements to boost
> performance. That is not to say that an RDBMS can not be fast, on the
> contrary; however, that is not its chief purpose.
> If performance is your ONLY concern, use a flat file or an XML file.
> You use an RDBMS to MODEL THE DATA, so that others can query it in a
myriad
> of ways and garauntee that there results are accurate. Therefore, you
have
> to use the RELATIONAL rules to model your data before you build the
physical
> database and constrain it in order to provide DATA INTEGRITY. It is this
> integrity that you build on an RDBMS system. The system is optimized for
> performance, but only after providing the foundation, a relational
database
> properly constrained.
> Sincerely,
>
> Anthony Thomas
>
>
> --
> "Klaus Aschenbrenner" <Klaus.Aschenbrenner@.anecon.com> wrote in message
> news:%23hBwlNzGFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi!
> I've a DataTable with 100 rows and 100 columns. Then I'm updating each
> column in each row. When I call the Update method on the DataAdapter, this
> generates 10000 UPDATE statements.
> Are there any solutions how I can create a better solution, which reduces
> the UPDATE statements? Or how can I handle such big updates with SQL
Server?
> Thanks
> Klaus Aschenbrenner
> MVP Visual C#
> www.csharp.at,www.anecon.com
> http://weblogs.asp.net/klaus.aschenbrenner
>|||Klaus,
The rows are updated depending on the rowstate.
It can be that when you start that the rowstate are set to "added" while you
don't want to update them all. (The dataadapter.fill set them automaticly
to unchanged when you have not set the property for that to false, however
when you load them by hand, by instance using a datareader they are all set
to "added".).
You can by instance in the case of that filling with the datareader set the
rowstate of all rows to unchanged by ds.acceptchanges
Maybe this helps?
Cor|||If only consultants would be so highly critical.
Sincerely,
Anthony Thomas
"Sahil Malik" <contactmethrumyblog@.nospam.com> wrote in message
news:%23Phk7IcHFHA.2984@.TK2MSFTNGP15.phx.gbl...
You must be a consultant. :)
- Sahil Malik
http://codebetter.com/blogs/sahil.malik/
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:OIk#AyDHFHA.3352@.TK2MSFTNGP10.phx.gbl...
> First and foremost, an RDBMS is NOT FOR PERFORMANCE. You gain performance
> by using the tool correctly and using the native enhancements to boost
> performance. That is not to say that an RDBMS can not be fast, on the
> contrary; however, that is not its chief purpose.
> If performance is your ONLY concern, use a flat file or an XML file.
> You use an RDBMS to MODEL THE DATA, so that others can query it in a
myriad
> of ways and garauntee that there results are accurate. Therefore, you
have
> to use the RELATIONAL rules to model your data before you build the
physical
> database and constrain it in order to provide DATA INTEGRITY. It is this
> integrity that you build on an RDBMS system. The system is optimized for
> performance, but only after providing the foundation, a relational
database
> properly constrained.
> Sincerely,
>
> Anthony Thomas
>
>
> --
> "Klaus Aschenbrenner" <Klaus.Aschenbrenner@.anecon.com> wrote in message
> news:%23hBwlNzGFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi!
> I've a DataTable with 100 rows and 100 columns. Then I'm updating each
> column in each row. When I call the Update method on the DataAdapter, this
> generates 10000 UPDATE statements.
> Are there any solutions how I can create a better solution, which reduces
> the UPDATE statements? Or how can I handle such big updates with SQL
Server?
> Thanks
> Klaus Aschenbrenner
> MVP Visual C#
> www.csharp.at,www.anecon.com
> http://weblogs.asp.net/klaus.aschenbrenner
>sql

DataSet Performance

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:OIk#AyDHFHA.3352@.TK2MSFTNGP10.phx.gbl...
> First and foremost, an RDBMS is NOT FOR PERFORMANCE. You gain performance
> by using the tool correctly and using the native enhancements to boost
> performance. That is not to say that an RDBMS can not be fast, on the
> contrary; however, that is not its chief purpose.
> If performance is your ONLY concern, use a flat file or an XML file.
> You use an RDBMS to MODEL THE DATA, so that others can query it in a
myriad
> of ways and garauntee that there results are accurate. Therefore, you
have
> to use the RELATIONAL rules to model your data before you build the
physical
> database and constrain it in order to provide DATA INTEGRITY. It is this
> integrity that you build on an RDBMS system. The system is optimized for
> performance, but only after providing the foundation, a relational
database
> properly constrained.
> Sincerely,
>
> Anthony Thomas
>
>
> --
> "Klaus Aschenbrenner" <Klaus.Aschenbrenner@.anecon.com> wrote in message
> news:%23hBwlNzGFHA.2976@.TK2MSFTNGP15.phx.gbl...
> Hi!
> I've a DataTable with 100 rows and 100 columns. Then I'm updating each
> column in each row. When I call the Update method on the DataAdapter, this
> generates 10000 UPDATE statements.
> Are there any solutions how I can create a better solution, which reduces
> the UPDATE statements? Or how can I handle such big updates with SQL
Server?
> Thanks
> Klaus Aschenbrenner
> MVP Visual C#
> www.csharp.at,www.anecon.com
> http://weblogs.asp.net/klaus.aschenbrenner
>|||Klaus,
The rows are updated depending on the rowstate.
It can be that when you start that the rowstate are set to "added" while you
don't want to update them all. (The dataadapter.fill set them automaticly
to unchanged when you have not set the property for that to false, however
when you load them by hand, by instance using a datareader they are all set
to "added".).
You can by instance in the case of that filling with the datareader set the
rowstate of all rows to unchanged by ds.acceptchanges
Maybe this helps?
Cor|||If only consultants would be so highly critical.
Sincerely,
Anthony Thomas
"Sahil Malik" <contactmethrumyblog@.nospam.com> wrote in message
news:%23Phk7IcHFHA.2984@.TK2MSFTNGP15.phx.gbl...
You must be a consultant.

Monday, March 19, 2012

Datareader, DBNull and ? Operator

Hi!

I was trying to use the ?? operator with an DBDatareader. eg:

long lValue = Convert.ToInt32(objReader["ParentID"] ?? -1);

which throws the following exception:"... Object cannot be cast from DBNull to other types."
I think the reason is, that DBNull.Value isn′t actually null. Therefore I changed my code to:

long lValue = objReader["ParentID"] != DBNull.Value ? Convert.ToInt32(objReader["ParentID"]) : -1;

Is there a better way of doing this ? Can one use the ?? operator with a Datareader anyway?

Thanks for your help!

PS: sorry for my poor english.

Hi,

the ?? operator is used in conjunction with nullable types. The way you wrote it using the ?: operator is just fine.

Grz, Kris.

|||

Thanks a lot!

Datareader and dataset

I am using a datareader to access data via a stored procedure. The reason for using the datareader is that the stored procedure is multi level depending on the variable sent to it. However I want to do two things with the data being returned.

The first is to poulate a datagrid - which I've done.
The second is to produce an Infragistic Web Graph. However according to the background reading I have done so far, I can only populate the graph from one of the following: datatable,dataview,dataset,Array or Ilist.

I don't want to make another call to the server for the same information, so how can I get the data out of a stored procedure into a dataset or dataview?

regards

JimSorry about that - found and article on the web site which told me that I was going about it the wrong way - should have read it first!

The article was at http://www.dotnetjunkies.com/quickstart/aspplus/doc/webdataaccess.aspx#storedprocs
and showed me how to access data from a stored procedure and put it into a dataset and a dataview.

regards

Jim

Thursday, March 8, 2012

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped

And the Second one is:

Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END

One RUN on two reports: ERROR

1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.

My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

And the Second one is:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

One RUN on two reports: ERROR

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

And the Second one is:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

One RUN on two reports: ERROR

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Tuesday, March 27, 2012

Datasource-Microsoft Visual Studio

Datasource-Microsoft Visual Studio

Datasource-Microsoft Visual Studio

Thursday, March 22, 2012

Dataset to XML

Dataset to XML

DataSet Performance

DataSet Performance

Monday, March 19, 2012

Datareader, DBNull and ? Operator

Datareader and dataset

Thursday, March 8, 2012

Data-Driven Subscriptions

Data-Driven Subscriptions

Data-Driven Subscriptions

date and time diffs

Blog Archive

About Me