Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Sep 7, 1999

Centralized Administration in a Distributed Environment (ASP and SQL Server) - Page 3

By Bill Wunder

Installation of The Active Tasks Status Inquiry

  1. Define a new application on an IIS server
    Determine your security requirements
    If you're using IE only then require Windows NT challenge/response authentication. If you may need to use any other browser to connect to the site then specify 'Basic Authentication'. If you have no worry of inside malicious attack, you could even use anonymous access.
    It is suggested that you disable session state.
  2. Copy the web pages to the application directory defined above
    frame document
    navigation side bar (left frame)
    style sheet
    navigation frame
    action frame(clock)
    results side (right frame)
    first open page
    ADO include file
    ASP script that gets status
  3. Define an ODBC datasource on the IIS server
    Create a File DSN using the ODBC manager on the web Server
    Add an Application_onStart event handler in the global.asa that defines an "admin_ConnectionString" that exposes the File DSN.
  4. Open your new site from any browser that can see the web server
  5. What if you have problems?
    Debug ASP using Visual Interdev
    Use SQL Trace to watch the database connection
    Drop Bill an email if you can't figure it out
  6. On to the the next step...

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM