MSDE 2000 & SQL Server 7 installed together?

Hi group!
I'm developing an application using Access/SQL Server.
The end client (government...) only has SQL server 7
installed and has not plans to upgrade in the development
timeframe.
I'd like to use SQL Server 2000 functions in my app. So
I'm wondering if I can reccomend an installation of MSDE
2000 alongside their SLQ server 7.
Is this technically possible?
If not, I'll have to rethink my design and do it in SQL
Server 7.
TIA
Andrew
hi Andrew,
"Andrew Webster" <andrew@.SPAM_ME_NOTwebster.org> ha scritto nel messaggio
news:042701c499fd$d7915ca0$a601280a@.phx.gbl...
> Hi group!
> I'm developing an application using Access/SQL Server.
> The end client (government...) only has SQL server 7
> installed and has not plans to upgrade in the development
> timeframe.
> I'd like to use SQL Server 2000 functions in my app. So
> I'm wondering if I can reccomend an installation of MSDE
> 2000 alongside their SLQ server 7.
> Is this technically possible?
> If not, I'll have to rethink my design and do it in SQL
> Server 7.
MSDE 2000 and MSDE 1.0, as long as SQL Server 7.0 and SQL Server 2000, and
relative mix, can coexiste on the same server...
the 7.0 code based server will be the default instance while the 2000 code
based server(s) have to be named instances.. up to 16 different isntances of
SQL Server 2000/MSDE 2000 can be (technically) hosted on the same sarver...
MDAC stack will be updated at 2.6 version (minimum requirement for SQL
Server 2000 RTM version), or better at 2.7.1 for service pack 3a level,
which I strongly recommend.
if you install MSDE 2000 over SQL Server 7.0, all the client tools of the
7.0 edition should be unusable as the COM binaries will be replaced with the
higher version, and only 2000 based tools will be available for management..
one caveat.. MSDE does not provide those tools (Enterprise Manager, Query
Analyzer and so on) but only the COM objects they rely on... so I really
have no idea (never tried myself) what the end position will be...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for that - I've now got access to a machine with SQL 7.0 on it, so I
can have a go at the installation and see how it works.
Andrew
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2qojtiF127domU1@.uni-berlin.de...
> hi Andrew,
> "Andrew Webster" <andrew@.SPAM_ME_NOTwebster.org> ha scritto nel messaggio
> news:042701c499fd$d7915ca0$a601280a@.phx.gbl...
> MSDE 2000 and MSDE 1.0, as long as SQL Server 7.0 and SQL Server 2000, and
> relative mix, can coexiste on the same server...
> the 7.0 code based server will be the default instance while the 2000 code
> based server(s) have to be named instances.. up to 16 different isntances
of
> SQL Server 2000/MSDE 2000 can be (technically) hosted on the same
sarver...
> MDAC stack will be updated at 2.6 version (minimum requirement for SQL
> Server 2000 RTM version), or better at 2.7.1 for service pack 3a level,
> which I strongly recommend.
> if you install MSDE 2000 over SQL Server 7.0, all the client tools of the
> 7.0 edition should be unusable as the COM binaries will be replaced with
the
> higher version, and only 2000 based tools will be available for
management..
> one caveat.. MSDE does not provide those tools (Enterprise Manager, Query
> Analyzer and so on) but only the COM objects they rely on... so I really
> have no idea (never tried myself) what the end position will be...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>