System Requirements

 

System Requirements

You'll need the following hardware and software to build and run the code samples for this book:

  • Microsoft Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003 with Service Pack 1 (SP1), or Windows 2000 with Service Pack 4 (SP4).

  • Visual Studio 2005 Standard Edition or Professional Edition. (The latter is required for Chapter 9 sample code.)

  • Microsoft SQL Server 2005 Express (included with Visual Studio 2005) and/or Microsoft SQL Server 2005. (See the next section.)

  • 600 MHz Pentium or compatible processor (1 GHz Pentium recommended).

  • 192 MB RAM (256 MB or more recommended).

  • 800 x 600 or higher resolution video monitor with at least 256 colors (1024 x 768 High Color 16-bit recommended).

  • DVD-ROM drive.

  • Microsoft Mouse or compatible pointing device.

SQL Server 2005 vs. SQL Server 2005 Express Edition

I have tried to use SQL Server 2005 Express Edition (SQL Server Express) where possible because it's easy to use. Further, SQL Server Express makes it easy to set up standalone samples because the database files can simply be included in the project. Some chapters use SQL Server 2005 because the features being covered are not available in SQL Server Express or because they are easier to use in SQL Server 2005.

The following table shows which release of SQL Server 2005 is used in the sample code, using these entries:

  • N/A Not applicable; database access not required

  • Yes Used in the code sample

  • No Not usable for the code sample

  • Possible Can optionally be used in place of the other version but requires connection string change

SQL Server Edition Used for Sample Code

Chapter and Topics

SQL Server 2005

SQL Server 2005 Express Edition

1: Overview of ADO.NET Disconnected Classes

N/A

N/A

2: Overview of ADO.NET Connected Classes

Yes, Possible

Yes, Possible

3: ADO.NET Trace Logging

Yes

No

4: Advanced Connectivity to the Data Store

   
  1. ConnectionStringBuilder

  1. Possible

  1. Yes

  1. Asynchronous access

  1. Yes

  1. Possible

  1. Connection pooling/failover

  1. Yes

  1. No

  1. StatisticsTest

  1. Possible

  1. Yes

5: Working with Disconnected Data

Possible

Yes

6: Working with Relational Disconnected Data

Possible

Yes

7: Working with the Windows Data Grid Control

Possible

Yes

8: Working with the Web Data Grid Control

Possible

Yes

9: Working with the SQLCLR

Yes

No

10: Understanding Transactions

Possible

Yes

11: Retrieving Metadata

Possible

Yes

12: Data Caching for Performance

   
  1. SqlDependency

  1. Yes

  1. No

  1. SqlCacheDependency

  1. Yes

  1. Possible

  1. CommandNotification

  1. Yes

  1. No

13: Implementing Security

   
  1. Security

  1. N/A

  1. N/A

  1. PartialTrust

  1. Possible

  1. Yes

  1. EncryptedWebSite

  1. Possible

  1. Yes

  1. SqlInjection

  1. Possible

  1. Yes

14: Working with Large Objects (LOBs, BLOBs, and CLOBs)

Possible

Yes

15: Working with XML Data

Possible

Yes

Configuring SQL Server 2005 Express Edition

This book requires that you have access to SQL Server 2005 Express Edition (and/or SQL Server 2005) to create and use the Northwind Traders and the Pubs sample databases. If you are using SQL Server 2005 Express, log in as Administrator on your computer, and follow these steps to grant access to the user account that you will use for performing the exercises.

  1. On the Windows Start menu, click All Programs, Accessories, Command Prompt to open a command prompt window.

  2. In the command prompt window, type the following command:

    sqlcmd -S YourServer\SQLExpress -E 

Replace YourServer with the name of your computer. You can find the name of your computer by running the hostname command in the command prompt window before running the sqlcmd command.

  • At the 1> prompt, type the following command, including the square brackets, and then press Enter:

    SP_GRANTLOGIN [YourServer\UserName] 
  • Replace YourServer with the name of your computer, and replace UserName with the name of the user account that you will be using.

  • At the 2> prompt, type the following command, and then press Enter:

    GO 
  • If you see an error message, make sure that you typed the SP_GRANTLOGIN command correctly, including the square brackets.

  • At the 1> prompt, type the following command, including the square brackets, and then press Enter:

    SP_ADDSRVROLEMEMBER [YourServer\UserName], dbcreator 
  • At the 2> prompt, type the following command, and then press Enter:

    GO 

    If you see an error message, make sure that you typed the SP_ADDSRVROLEMEMBER command correctly, including the square brackets.

  • At the 1> prompt, type the following command, and then press Enter:

    EXIT 
  • Close the command prompt window.

  •  


    Programming Microsoft ADO. NET 2.0 Applications. Advanced Topics
    Linux Application Development (2nd Edition)
    ISBN: 735621411
    EAN: 2147483647
    Year: 2004
    Pages: 85
    Authors: Michael K. Johnson, Erik W. Troan
    BUY ON AMAZON

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net