Welcome! and rules
Joel on Software
database in xp prof to learn ASP.NET?
I have a pc with xp prof installed, with IIS and .NET SDK already installed. Most of the example in any sites or books use SQL Server. What is the alternative database to install on my stand-alone PC for learning purpose? Will MS Access XP do? Please give pointer to accessing the database from ASP.NET.
I think MS Access should be fine. You can setup MSDE also.
Yes, Access will work fine for ADO.NET experimentation. It's fairly easy to translate SQL Server-based examples. Just move from the System.Data.SqlClient namespace to System.Data.OleDb instead. That is, convert SqlDataAdapter to OleDbDataAdapter, SqlCommand to OleDbCommand, and so on. The help for the OleDbConnection.ConnectionString property will show you how to set up a connection string to use an Access database instead of a SQL Server database.
If you installed the demos included with the .NET SDK you should already have an instance of MSDE installed that you can use. It's (local)\NetSDK I think?
Guy Incognito, MVP DOA
You can actually get the SQL Server client tools for free. Download the 180-day trial version of SQL Sever from Microsoft's site, then do a "Client Tools Only" install. Although the server software has a 180-day time bomb in it, the client tools do not.
I'm pretty sure that's cheating... :) But hey, I won't turn you in!
Fog Creek Home