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!

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!

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.

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!

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

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!

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