Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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!
Reply With Quote
  #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!
Reply With Quote
  #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.

Reply With Quote
  #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!
Reply With Quote
  #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,102
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
Reply With Quote
  #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!
Reply With Quote
  #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,102
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 11:46 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.