Re: IIS, asp and a database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mark Schupp (mschupp_at_ielearning.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 08:16:21 -0700

It would also be helpful if you posted the ASP script. 

-- 
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:u0eKPobJEHA.3848@TK2MSFTNGP09.phx.gbl...
> Please try to run the ASP page directly, to determine if the problem is
> within the ASP page, or with the ASP page's ADO objects accessing the
Access
> database.
>
> Otherwise, the problem may be in the Authorware part of your application.
>
> Cheers
> Ken
>
> "Jim Bowman" <anonymous@discussions.microsoft.com> wrote in message
> news:0b2501c425a3$66d86090$a501280a@phx.gbl...
> : I am getting inconsistent results from an e-learning
> : program - asp page - database connection.
> :
> : I have installed IIS on my computer from Win XP Pro.  My
> : authoring program (Authorware 5.2) executes a ReadURL
> : function that calls an asp page.  The asp page contains a
> : SQL SELECT command that is sent to an Access database.
> : If the desired record exists in the database, the record
> : is sent back to the asp page which sends it back to the
> : Authorware file where the contents of the record
> : display.  If an error occurs, an error message displays.
> :
> : When I first boot up the computer and run the Authorware
> : file, the sequence runs correctly.  On the 2nd run and
> : most subsequent runs, Authorware returns an error,
> : IOStatus = 5006 and a message = "unknown error (5006)".
> : On an occasional subsequent run, the example runs
> : correctly.  Then on the next run, it returns the same
> : error.
> :
> : I have uninstalled and reinstalled IIS and have checked
> : the Authorware and asp page carefully. The problem
> : persists.  What might be the cause of this inconsistency?
> :
> : Thanks.
> :
> : Jim Bowman
> :
>
>

Relevant Pages

  • IIS, asp and databases
    ... program - asp page - database connection. ... I have installed IIS on my computer from Win XP Pro. ... authoring program (Authorware 5.2) executes a ReadURL ... SQL SELECT command that is sent to an Access database. ...
    (microsoft.public.windowsxp.network_web)
  • IIS, asp and a database
    ... program - asp page - database connection. ... I have installed IIS on my computer from Win XP Pro. ... authoring program (Authorware 5.2) executes a ReadURL ... SQL SELECT command that is sent to an Access database. ...
    (microsoft.public.inetserver.asp.db)
  • Re: IIS, asp and a database
    ... within the ASP page, or with the ASP page's ADO objects accessing the Access ... the problem may be in the Authorware part of your application. ... program - asp page - database connection. ... On an occasional subsequent run, ...
    (microsoft.public.inetserver.asp.db)
  • Re: IIS, asp and a database
    ... Use the Jet OLEDB Provider, not the ODBC driver, and you should avoid these ... Otherwise, you can delete the DSN, and recreate it, and the problem ... Authorware is not the cause. ... I run the asp page with a connection to an Access ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)