p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

aspdotnet_website_programming thread: Has anyone got SQL 7 working?


Message #1 by "Mike Gale" <info@d...> on Thu, 16 May 2002 08:51:36 +1200
I received the book yesterday.

When attempting to install to a SQL Server 7 (on W2K Server) I get
messages that includes text like
"on-disk structure version 539.  Server supports 515 and cannot restore
or upgrade"

This looks like trying to load a SQL 2000 backup into SQL 7.  (Although
I haven't checked.)

The application is meant to run on SQL 7 (Page 29 for example).

Has anyone actually got it running on SQL 7 out of the box?

If not has someone found another way to get it into SQL 7 (like
producing a differently formatted backup!)?

Mike Gale, Decision Engineering (NZ) Ltd.

Message #2 by "Jacques PHILIP" <jphilip@n...> on Thu, 16 May 2002 05:50:03
Hello,

I had the same problem at first.
You can install the SQL 2000 desktop edition that comes with VS or .NET 
framework, it will create a new instance of SQL server called 
YOURMACHINE\VSDOTNET.
From enterprise manager version 7, you can login to this instance and 
restore the database using the sql 2000 engine.

Jacques PHILIP


> I received the book yesterday.

When attempting to install to a SQL Server 7 (on W2K Server) I get
messages that includes text like
"on-disk structure version 539.  Server supports 515 and cannot restore
or upgrade"

This looks like trying to load a SQL 2000 backup into SQL 7.  (Although
I haven't checked.)

The application is meant to run on SQL 7 (Page 29 for example).

Has anyone actually got it running on SQL 7 out of the box?

If not has someone found another way to get it into SQL 7 (like
producing a differently formatted backup!)?

Mike Gale, Decision Engineering (NZ) Ltd.

Message #3 by David Barnes <DavidB@w...> on Thu, 16 May 2002 12:52:42 +0100
Hello all

I was the lead editor on ASP.NET Website Programming. I'm sorry that the
download hasn't included a backup for SQL Server 7. I've had a lot of
enquiries, and I've finally managed to figure something out. There is now a
separate download on www.wrox.com that contains a backup of the same
database, but created in SQL Server 7.

I hope that this helps, and I apologise for the delay.

Regards

David

 
-- 
So You'd Like To Program ASP.NET Websites?
<http://www.amazon.com/exec/obidos/tg/guides/guide-display/-/YAEJ7I55O1ED/10
2-8074949-6987353> 

> -----Original Message-----
> From: Jacques PHILIP [mailto:jphilip@n...]
> Sent: 16 May 2002 06:50
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] Re: Has anyone got SQL 7
> working?
> 
> 
> Hello,
> 
> I had the same problem at first.
> You can install the SQL 2000 desktop edition that comes with 
> VS or .NET 
> framework, it will create a new instance of SQL server called 
> YOURMACHINE\VSDOTNET.
> From enterprise manager version 7, you can login to this instance and 
> restore the database using the sql 2000 engine.
> 
> Jacques PHILIP
> 
> 
> > I received the book yesterday.
> 
> When attempting to install to a SQL Server 7 (on W2K Server) I get
> messages that includes text like
> "on-disk structure version 539.  Server supports 515 and 
> cannot restore
> or upgrade"
> 
> This looks like trying to load a SQL 2000 backup into SQL 7.  
> (Although
> I haven't checked.)
> 
> The application is meant to run on SQL 7 (Page 29 for example).
> 
> Has anyone actually got it running on SQL 7 out of the box?
> 
> If not has someone found another way to get it into SQL 7 (like
> producing a differently formatted backup!)?
> 
> Mike Gale, Decision Engineering (NZ) Ltd.
> 
> 
Message #4 by "Mike Gale" <info@d...> on Fri, 17 May 2002 10:01:56 +1200
Thanks David

Great.  Works with a "force restore over".

(I'm scheduled to move over to SQL 2000 in July and I'm not eager to
have multiple database services and Enterprise Manager problems "ahead
of time".  So this is very welcome.)

Mike Gale, Decision Engineering (NZ) Ltd.

-----Original Message-----
From: David Barnes [mailto:DavidB@w...] 
Sent: Thursday, 16 May 2002 23:53
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] Re: Has anyone got SQL 7 work
ing?


Hello all

I was the lead editor on ASP.NET Website Programming. I'm sorry that the
download hasn't included a backup for SQL Server 7. I've had a lot of
enquiries, and I've finally managed to figure something out. There is
now a
separate download on www.wrox.com that contains a backup of the same
database, but created in SQL Server 7.

I hope that this helps, and I apologise for the delay.

Regards

David


  Return to Index