Can Data Extension built with VS2005 work with RS2000 ?

For various reasons our next release of our software needs to continue to support SQL 2000 and Reporting Services 2000. We are using a Data Extension written in C#.

Can we build a data extension in VS2005, using .Net 2.0 and have it work with RS2000. A quick test did not work.

Is this a valid / supported configuration ?

If it is, what steps, modification to the various configuration files would I need to make to get it to work ?

Thanks

Richard

No this won't work. RS 2000 will only work with .NET 1.1. Since data extensions will get loaded into the same app. domain, a RS 2000 data extension has to be built with .NET 1.1 / VS 2003.

-- Robert

|||What about the other way around? Will RS2005 Support extensions I built with RS2000?|||

You should update the references (e.g. RS 2005: MS.RS.Interfaces.dll) and recompile the data extension with VS 2005.

-- Robert

Can Data Extension built with VS2005 work with RS2000 ?

For various reasons our next release of our software needs to continue to support SQL 2000 and Reporting Services 2000. We are using a Data Extension written in C#.

Can we build a data extension in VS2005, using .Net 2.0 and have it work with RS2000. A quick test did not work.

Is this a valid / supported configuration ?

If it is, what steps, modification to the various configuration files would I need to make to get it to work ?

Thanks

Richard

No this won't work. RS 2000 will only work with .NET 1.1. Since data extensions will get loaded into the same app. domain, a RS 2000 data extension has to be built with .NET 1.1 / VS 2003.

-- Robert

|||What about the other way around? Will RS2005 Support extensions I built with RS2000?|||

You should update the references (e.g. RS 2005: MS.RS.Interfaces.dll) and recompile the data extension with VS 2005.

-- Robert

Can all SS2000 jobs run as owner "sa"?

We have several servers, each with many jobs. Some jobs run as Owner "SA", and some jobs running as various domain admin accounts. We have been told to modify all jobs to run with Owner "SA". Now, some of the jobs read or write flat files and I am a little concerned about this. Does the domain account which starts the SS2000 services determine the rights to read and write files? If so, I guess changing all jobs owners to "SA" has no real risk?

Thanks!

Michael

With respect to accessing external resources, the service account which runs SQL Server Agent requires access rights to those resources for the job to be successful. The owner of the job has no effect on those rights.

HTH.

can a report read parameters from POST as opposed to GET?

My scenarios is that I have to have an ADHOC report page, which will
allow the user to select various attributes, and I have to then create
the SQL clause on the fly, based off these selected attributes. I then
have to have the report in reporting services run off of that generated
SQL clause.
I have two ideas how I can do this, but I am looking for the most
efficient.
My first idea, and the one I assume I will have to go with is this.
When the user clicks the run button, the SQL clause will be built based
on their selections. That SQL clause will then get passed into a
stored proc which will act like a "middle man", this "middle man"
procedure will store the clause into a "holding" table. The Reporting
Services report will then have to run, use a procedure that reads from
this "holding" table and uses the SQL clause, executes it, and if
successful, deletes it from the holding table, ready for the next run
of the page.
The other approach I am thinking of, but am not sure will work is
basically passing the generated SQL query to the report as a POST
variable. I am not sure if this will work or not since I haven't tried
it before.
does anyone know if you can pass in POST variables as opposed to GET
variables when calling a report as a url?answered my own question by searching through the help (which I should
have done in the first place). So far it looks like I can POST the SQL
query that I want....but the help file mentions something about a 2000
char limit, for even POST...anyone have any experience with a similar
situation?