Author: Michael Gonzalez
Frequently Answered Questions
Miscellaneous

File Text Search & Replace Utility
HTML Text Extraction using innerText
E-mail (CDONTS.NewMail) Sample Code
SQL Server 7.0/2000

Incorporating ASP and SQL Server
100's of T-SQL Scripts
Don't Use @@ERROR with UPDATE Statements
Exporting Tables to Text Files
Creating SQL Server Databases
ASP (SQL) Query Analyzer
Increasing SQL Server Performance with Indexes
Distributed SQL Server Transactions & Queries
COM/COM+ Development
What is COM?
Isn't ActiveX and COM the same?
How can Components benefit my ASPs?
Am I using COM Components now?
How do I use COM Components in my ASPs?
Creating your First COM Component
Creating a COM Component that uses ASP Intrinsic Objects
Creating a COM Component to access an MS-Access Database
MTS Component Template
MSMQ Component Template / Example

Incorporating SQL Server 7.0/2000 Databases into your ASP Pages

What you need to have ready before you can continue with these tutorials:
  1. SQL Server 7.0 - installed on a server. This can be either a Windows NT 4 or Windows 2000 Server system. For help on seting up SQL Server, click HERE.
  2. Configure SQL Server to use SQL Server and Windows NT authentication:
    1. Open the SQL Server Enterprise Manager.
    2. Right-click on the SQL Server which will be used with your ASP pages.
    3. Click on Properties.
    4. Click on the Security tab.
    5. In the Authentication: section, click on SQL Server and Windows NT.
    6. Click on the OK button to finish.
  3. Internet Information Server 4.0 (IIS4) - installed on a Windows NT 4 Server.
  4. ADO 2.0 (or later) - installed on the same server as the IIS4 computer. ADO comes as part of Microsoft's MDAC components. Click here to download MDAC 2.6 RTM.
    Tutorial Table of Contents:

  1. Creating SQL Server 7.0/2000 Databases
  2. Creating SQL Server 7.0/2000 Tables
  3. Creating SQL Server 7.0/2000 Logins
  4. Setting SQL Server 7.0/2000 Permissions
  5. Increasing SQL Server 7.0/2000 Performance with Indexes
  6. Distributed SQL Server 7.0/2000 Transactions & Queries
Comments & Questions Form

Send It!