Can I install SQL Server on Windows 98?

By Bill Graziano on 29 July 2000 | Tags: Installation

Chris writes "Hi, Thank for this helpful site but I can't understand anything on here. This is not your crime :P Just I don't know anything else about SQL Server. How can I install SQL Server and Oracle on my machine? My machine (at home) 's operating system is Windows 98. Is this enough? More..I'm developing ASP pages. Has advantage for my ASP pages? Thank you."

Well Chris, I can certainly cover the SQL Server side of your question. As far as Oracle, I'm not going to be much help. Sorry :( Maybe one of our sharp-eyed readers can post a comment with a link to a good Oracle site.

SQL Server does run on Windows 98. In the installation program you can install the Desktop edition. It is almost identical of the Standard edition which is installed on servers. The desktop edition also includes special code to minimize the amount of memory it uses. It does not support OLAP Services or full text indexing. I also would not use SQL Server on Windows 98 for any type of high throughput database. It does work just fine as a development workstation though.

Concerning your second question, SQL Server can provide a number of advantages for ASP developers. Those advantages come with added complexity though. It is much easier to learn Access and deploy a solution using Access than with SQL Server. That is the main benefit of Access: ease of use. SQL Server gives you better scalability and reliability. While Access might support tens of users at a time, SQL Server is capable of supporting hundreds or thousands. It is also less likely to have data corruption errors. You can perform backups while the database is running with almost no loss in performance.

In most hosted environments, the SQL Server machine is separate from the web server. That means that database queries are passed to a separate computer that is only handling database queries and is optimized for them. This leaves your web server free to focus on web serving. I hope this helps.

Related Articles

Notes from an Upgrade to SQL Server 2005 (26 February 2007)

Migrating from Oracle to SQL Server (29 September 2002)

Upgrading from SQL Server 7 to 2000 (Part 2) (29 May 2002)

Upgrading from SQL 7 to SQL 2000 (Part 1) (5 May 2002)

Service Pack 2 for SQL Server 7.0 (9 September 2000)

Other Recent Forum Posts

SQL Update Union (17h)

Use sp_Send_DBMail with Variable (1d)

Is there a function in SQL that does the same as the Excel forecast.ets function? (2d)

Case statement within and (3d)

SUM values based on values of another column (3d)

SSIS Error The type of the value (DBNull) being assigned to variable "User::FileName" differs from the current variable type (String) (3d)

Conversion failed when converting date and/or time from character string (4d)

Split String Update Query (4d)

- Advertisement -