PDA

View Full Version : Add SQL Server to your test sites



awasson
01-10-2003, 06:51 PM
This is pretty cool if you want the performance of SQL Server for your test environment.

IE: You will want to be running something like Win2k Pro or WinXP Pro with Microsoft's Web Server.

It's kinda advanced stuff.

hhammash and I have been playing with SQL Server MSDE back and forth trying to figure out what you can do with it and although it is easier to use with FP2002 it got me to messing around and seeing what I could do with FP2000.

Here's the scoop.

MSDE is included with Office XP. I'm not sure which versions of Office XP but it's safe to assume it's on the one that FrontPage comes with.

More about that here:
At MS (http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp)

And here:
At MS (http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q290627&)

It also comes with the Dot.Net SDK (Software Development Kit) More about that here:
At DOT.NET Support (http://www.asp.net/download.aspx)

You have to install the dotnet framework etc... for that method but it's not too dificult really and if you get that going, there's another web development avenue for ya.

Ok, now that I have rambled for however long here's the good news. If you have Office XP with FrontPage you can have SQL Server for development...

and for those of us with FP2000...

If you download the Dot.Net Framework and SDK you can also install and use SQL Server MSDE with FrontPage 2000.

Ohhh by the way...

IT'S FREE :woohoo:

Now it's pretty amazing the things that you can do with Access using multiple table queries and advanced queries with joins etc... Think of the possibilities running Microsoft's Flagship Database.

Check it out
Andrew

awasson
01-17-2003, 01:19 PM
An additional note to the first post.

If you have MS Office 2000 with Access there is a copy of SQL Server MSDE on the disk as well. Search MSDE in the "Microsoft Access Help" menu. There is quite a bit of information including the following:


Installing MSDE
Although MSDE is not part of Microsoft Office 2000 or Microsoft Access 2000 standalone Setup, you can install MSDE from the CD-ROM by running Setupsql.exe located in the \Sql\x86\Setup folder.


Andrew