Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 11th, 2004, 11:52 AM
Registered User
 
Join Date: Aug 2004
Location: Manchester, , United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Some confusion as to which SQL to use

Hello from sunny UK, my questions are this Iam in the middle of my crossover VB to VB.Net course and I have been using Access for years.

I was given a copy of SQL 7 to use by my course providers, do i buy books on SQL 7 or do i buy books for SQL Server 2000.

What is the difference between the two?

Which would be best to use, just for developing my own apps at home to gain experience?

What is SQL Server 2000 CE 2.0 as i have it in .Net?

What is MSDE 2000A as i have just downloaded it from a Microsoft web site?

Finally not to ramble on (sorry!) when i have downloaded MSDE 2000A it tells me that it cannot be installed because it requires 'A strong password is required for security reasons. Please use SAPDW switch to supply the same.' But the ReadMe file to it is as clear as muddy water.

Mark - Very confused.

Thanks



Dont get too offended if I get it wrong the first time!
  #2 (permalink)  
Old August 11th, 2004, 11:56 AM
Registered User
 
Join Date: Aug 2004
Location: Manchester, , United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ps. If I bought Professional SQL Server 2000 Programming by R Vieira would I be able to use it with SQL 7?

Mark uk

Dont get too offended if I get it wrong the first time!
  #3 (permalink)  
Old August 12th, 2004, 01:09 AM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

A good resource is the SQL 2000 Books online. Download a copy of the SQL 2000 Evaluation. Look on Books Online "What News" this will give good information once you have evaluated SQL 2000 and you will like to develop apps at home lookup purchase SQL 2000 Developers Edition; you can probably find it for about $39.00 ( Please read the requirements for using this version)

I hope this also helps.

  #4 (permalink)  
Old August 12th, 2004, 09:34 AM
Registered User
 
Join Date: Aug 2004
Location: Manchester, , United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks very much for the advice, until recently i had only used Access and the thought of switching to SQL Server seemed to be a bit daunting, but any way thanks alot.

Mark.uk

Dont get too offended if I get it wrong the first time!
  #5 (permalink)  
Old August 12th, 2004, 09:50 AM
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

1. Do not bother with SQL 7.0
2. SQL 2000 is current, SQL 2005 is due out "soon"
3. I do not know what SQL 2000 CE 2.0 is.. I assume it's a version for devices using the portable OS
4. MSDE 2000A is a "Desktop" version of MS SQL SErver- it has limited functionality but is a great way to get your SQL 2K feet wet.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
  #6 (permalink)  
Old August 12th, 2004, 10:44 AM
Registered User
 
Join Date: Aug 2004
Location: Manchester, , United Kingdom.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Hal for the advice i just wanted the answers you gave, a simple yes or no to SQL Server 7!

Its made my life (and anothers) alot easier, many thanks again.

Mark.uk

ps. Judging by the time of your post do you lot ever sleep in the US?

Dont get too offended if I get it wrong the first time!
  #7 (permalink)  
Old August 12th, 2004, 10:47 AM
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Times are adjusted so you see them in your local time... My answer to you was posted at 10:50AM today here..


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee


Similar Threads
Thread Thread Starter Forum Replies Last Post
foreach confusion stokerfed C# 2 June 13th, 2007 02:30 PM
Class' Confusion dpkbahuguna Beginning VB 6 4 September 20th, 2006 11:16 PM
Some confusion in these code hpatel_it ASP.NET 1.0 and 1.1 Basics 0 August 30th, 2006 08:19 AM
.net Confusion reyboy General .NET 1 December 29th, 2004 08:35 AM
Stream Confusion benburrows General .NET 1 February 27th, 2004 12:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.