Showing posts with label release. Show all posts
Showing posts with label release. Show all posts

Thursday, March 29, 2012

Can I install both Management Studio and Management Studio Express on same machine?

I want to install the following on my machine:

MSDE 2000 Release A

SQL Server 2000 SP4

SQL Server 2005 Developer Edition with SP1

SQL Server 2000 Express with SP1

Management Studio

Management Studio Express

The only one that I'm concerning is whether Management Studio and Management Studio Express can coexist in one machine.

Thanks for any help,

Peter

NO. Products have been mutually exclusive since early betas.sql

Thursday, March 8, 2012

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