Web Wiz Forums on MySQL

Hello.

I have some question about Web Wiz Forums and some database.

It's working on MySQL database? I read the "documents" but I found just it:

It has been tested on PWS 4 and IIS 4, 5 and 6 on Windows 2003/2000/XP/NT4/98.
The ASP Discussion Forum has been tested on MS SQL Server 7 and SQL Server 2000. Please
note some features will not run on MS SQL Server 7.

How Can I made the database in "MySQL" and "Microsoft SQL Server 2000"? With import (*.mdb) database, run some (*.sql) file or something else...?

How Can I install "Micorosoft SQL Server 2000" on "Windows XP" or "Windows Server 2003" without SP3? When I try to install "Database", it write this:

Can someone help me about this!?

Thanks.

Ok, about MySQL. I read old posts. At the moment It doesn't work!

About using Web Wiz Forums on Micorosoft SQL Server, I find the file (msSQL_server_setup.asp) for create the database.

But about install "Micosoft SQL Server 2000 Enterprise Edition" on "Windows Server 2003", It's the some error because this operation sistem have a security level! About this I reed on this site (http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp), but I don't found how I can resolve?

In an effort to provide customers with more secure products, Microsoft Windows Server� 2003 supports only SQL Server 2000 with Service Pack 3 (SP3) or later and MSDE 2000 with SP3 or later. You can also choose to run SQL Server 2000 with SP3 on Microsoft Windows 2000 Server. SQL Server 7.0 and MSDE 1.0 will not be supported on Windows Server 2003. Customers running applications with SQL Server version 7.0 and MSDE 1.0 should consider evaluating and upgrading to SQL Server 2000 and MSDE 2000 respectively with SP3 on Windows Server 2003 to achieve a more secure operating environment.

I have only "Micosoft SQL Server 2000" without SP3. At the moment. When I will install the database, I will install the SP3.

Can you help me?

Yeah, the MySQL issue is not possible at this moment to just recreate MySQL databases/tables, because there is incompatibility issues, MySQL does not support paging and stored procedures on it's current version.

As it was said before you can only install SQL srv ent. on a server OS, and WinSrv2003 only allows SQLSrv2000 with SP3 to be installed, this is because of a few serious issues were found in SQL srv 2000 that would compromise the more secure WinSrv2003 if left unpatched, so MS forced people to install SQLSrv2000 on WinSrv2003 with SP3 only, non-negotiable option. You can however install SQLSrv2000 with no SP3 on Win2000Srv without any issues or contact your vendor and get SQLSrv2000 with SP3, in the mean time you could run MSDE2000.

Alternatevely, and this is truly advanced stuff, you may try to fidle with it a bit:

1. Get SP3, and find a way to extract all files and write down all registry changes it does.
2. Backup SQLSrv2000 installation and copy it to the local hard-drive.
3. Check wether SQLSrv files are compressed or not (you know the filename.ex_).
4. If they are not, just import all files from the extracted SP3 to match all files and dirs on the SQLSrv installation, overwritting as necessary.
5. If you reached this stage, then maybe there's a chance for you, now before you run setup, update the registry with all SP3 changes you had written down, then run setup, and hope for the best. Even thou if it's all made correctly, it may fail because SQLSrv setup will still tell WinSrv2003 that it is SQLSrv2000 and not SQLSrv2000SP3, so you may have to try to find where in the setup files is that value and correct it, this may prove to be the most tricky part of all.

Anyway, enjoy.