Re: Accessing Jet Engines in Asp. Please help - A critical deadline is closing in.

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

From: Val Mazur (group51a_at_hotmail.com)
Date: 03/06/04 

Date: Fri, 5 Mar 2004 22:16:41 -0500

Hi Roger,

Does it fail when you call AddNew method of ADO recordset? If yes, then
check if recordset is not opened as read-only. If yes, then you could post
code, so we could see how you opened your recordset 

-- 
Val Mazur
Microsoft MVP
"Roger Stenson" <roger.stenson1@ntlworld.com> wrote in message 
news:uYPY$2tAEHA.2404@TK2MSFTNGP11.phx.gbl...
> Hi
> I have a web ASP application using Access 2000 format databases which I
> developed in vb script on Windows 2000. The product works fine on  IIS
> in the development machine and was fairly widely used for customer
> demonstration
> system with limited db's  in a trial ISP  using NT4.
>
> The web product is supported by a back-office vb6 system  used to build 
> the
> database  for real. The database is now ready and the client wishes to go
> live on the web
>
> When we run the proven asp code on IIS in an XP Pro machine with the new
> databases,  it immediatly halts with the browser displaying a message from
> the Jet Microsoft JET Database Engine "(0x80040E09) Cannot update. 
> Database
> or object is read-only."   We get the the same message when we upload the
> system  and data to the chosen ISP who also uses NT4.
> The database complained of is the "System database " which has already 
> been
> read from by
> global.asa on start up. The system  fails on an 'Addnew' instruction when
> adding a log- in to the log file.
>
> I have spent a lot of time pouring over ACCESS security texts and have 
> three
> versions of the database, one unsecured, one secured with all the update
> functions cleared for use by everyone and one imported from the working
> Windows 2k environment.
> All three work fine in the Windows 2k IIS  and with the  back office VB
> system. All three achieve the above error
> when running on  IIS on the XP machine and when uploaded to the new ISP.
>
> As the ASP vb script specifically opens the Ado connection in read write
> mode and
> has long been working, we can't believe it is the Asp code that is the
> problem.
>
> So I have recently spent some time comparing the IIS setups in W2k and 
> XPPro
> machines but can not find any differneces which look material to me. I
> would be really grateful for some ideas on how to move this problem 
> forward
> or how to set
> about furthering the diagnosis. as I am at my wits end.
>
> Roger Stenson
>
>
>

Relevant Pages

  • Re: Problem on quering Access link table
    ... Is "Alias" a field in the Exchange table? ... > simply test the recordset for BOF/EOF? ... > Access Database Samples: www.rogersaccesslibrary.com ... I wrote ASP code to use Alias ...
    (microsoft.public.access.queries)
  • Re: Accessing Jet Engines in Asp. Please help - A critical deadline is closing in.
    ... In your case it is possible that recordset was opened as read-only. ... > 'SET UP Database ... > 'OPEN LOG DATASET ... The product works fine on IIS ...
    (microsoft.public.vb.database.ado)
  • Re: ASP & Databases
    ... I am unable to insert a row in a database using an .asp ... I am running IIS 5.1 that comes with Windows XP. ... : in Control Panel. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Unable to get global configuration data.
    ... It did say All Unassigned with a port. ... I reset IIS. ... on the web server. ... Unable to connect to database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Insert Database Results - Get Error
    ... > Thomas A. Rowe ... > FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... Note that I do not have IIS installed. ... insert database results in a FP .asp page. ...
    (microsoft.public.frontpage.client)