Re: Application Error 1000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JimOlson (JimOlson_at_nospam.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 12:05:09 -0700

Here is the code that is executing...

...
    Dim cnCustomerDB2 As ADODB.Connection
    Set cnCustomerDB2 = New ADODB.Connection
    
    cnCustomerDB2.Open "FileDSN=" & App.Path & "\CustomerDB.dsn"
    
    '// Expire all runs for this issue that are active and were not pulled
into pagination.
    sSQL = "UPDATE Runs SET Status = 'EXPIRE', Comment = LEFT('Not Placed '
+ Comment, 50)"
    sSQL = sSQL & " WHERE Status = 'ACTIVE' AND Date = '" & gsIssueStr & "'
AND Edition = '" & sCustFileTable & "'"

oLog.Add "Executing: " & sSQL
    cnCustomerDB2.Execute sSQL

oLog.Add "Re-Closing db connection"
…

Where:
gsIssueStr = "9/24/2004" (any date in string format)
sCustFileTable = "WEST"
oLog = a log file class we created to log events to a text file.

The last event that oLog writes is 'Executing' + the SQL statement. The
statement does execute properly, but the error occurs before the next event
is written to the log file. This updates ~50-100 records. I also tried to
implement this logic by doing a SELECT statement and looping thru the
records, updating them one at a time, but it bombed at the SELECT statement's
.execute. So it appears to be a problem in ADO. This is referencing ADO
2.5, and they have up to 2.7 installed on their XP pc's.

Jim

"Val Mazur" wrote:

> Which line of code cause it? Could you post it here? Based on it we could
> try to find some clues
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "JimOlson" <JimOlson@nospam.com> wrote in message
> news:98B240CD-7EA5-4BCB-8F1B-AD507E9F9429@microsoft.com...
> > We used the vb6 installation tool to make a Setup. This was built on a
> > win2k
> > box. We then installed it on an XP computer and used Norton's Ghost to
> > copy
> > the HD and then copied this out to all our users (100+). I tried creating
> > a
> > Setup for this project on an XP pc. But when I ran the installation on
> > another XP pc, the setup blew up.
> >
> > Is there a tool I can use to analyze the error log that this is generating
> > to see exactly what component is erroring out? I know exactly what line
> > of
> > code causes it, but I don't know how to resolve it. I've tried using
> > RegMon.exe to monitor the registry access while running the program, but I
> > have not been able to reproduce the error while running this.
> >
> > Jim
> >
> > "Val Mazur" wrote:
> >
> >> I think some component is missing or it is incorrect version of it. How
> >> did
> >> you install you application - copy&paste or using some sort of
> >> installation?
> >>
> >> --
> >> Val Mazur
> >> Microsoft MVP
> >>
> >>
> >> "JimOlson" <JimOlson@nospam.com> wrote in message
> >> news:CC657561-B4E1-48BD-B4EB-F24CD3A9C0D1@microsoft.com...
> >> > First, the generic XP message comes up "xxxxx has encountered a problem
> >> > and
> >> > needs to close. ..." with the "Please tell Microsoft about this
> >> > problem"
> >> > options. If I Click to see the error report data, I see my VB AppName
> >> > &
> >> > version, ModName is typically 'unknown', but occasionally dbnetlib.dll.
> >> > ModVer: 2000.81.9042.0 Offset: 00009bb5
> >> >
> >> > If I click on view technical information, I see Exception
> >> > Information...
> >> > Code: 0xc0000005 Flags: 0x00000000
> >> > Record: 0x0000000000000000 Address: 0x0000000002bb9c6f
> >> > ...and then my system information and a list of loaded modules.
> >> >
> >> > If I look in the Event Viewer, I see Application Error 1000. my VB
> >> > AppName
> >> > & version, unknown, 0.0.0.0, 01ee9c6f.
> >> >
> >> > Jim
> >> >
> >> > "Val Mazur" wrote:
> >> >
> >> >> Hi,
> >> >>
> >> >> What is exact error message or error code?
> >> >>
> >> >> --
> >> >> Val Mazur
> >> >> Microsoft MVP
> >> >>
> >> >>
> >> >> "JimOlson" <JimOlson@nospam.com> wrote in message
> >> >> news:EB19C6B3-240E-4767-BF72-394EBD852949@microsoft.com...
> >> >> >I am trying to figure out a fix for an Application Error 1000 that is
> >> >> >being
> >> >> > generated by a VB6sp3 app we have written in house. The error
> >> >> > showed
> >> >> > up
> >> >> > when
> >> >> > we first upgraded to WinXP and only shows up on most of our WinXP
> >> >> > computers.
> >> >> > It happens when we are using ADO (2.5)'s command object to 'UPDATE'
> >> >> > a
> >> >> > batch
> >> >> > of >100 records residing in a SQL2k database. The command executes
> >> >> > but
> >> >> > generates the App Err 1000 immediately after this code executes.
> >> >> > The
> >> >> > faulting module is 'unknown' mostly, but I have occasionally seen
> >> >> > dbnetlib.dll as the culprit. In this same routine we are also using
> >> >> > DAO
> >> >> > 3.5
> >> >> > to loop thru an Access 95 database. I have also seen it happen when
> >> >> > doing
> >> >> > a
> >> >> > 'SELECT' statement that returned >100 records, in this same code
> >> >> > module.
> >> >> > I
> >> >> > have compared .dll versions between computers where it works and
> >> >> > doesn't
> >> >> > by
> >> >> > using listdlls.exe to list the dlls in use at the time and
> >> >> > everything
> >> >> > seems
> >> >> > to be the same. The one difference we have discovered is that
> >> >> > installing
> >> >> > Visual Studio 6 seems fix the problem. Obviously that is not a
> >> >> > solution
> >> >> > that
> >> >> > we can consider. Any ideas as to what might be going on here? Or
> >> >> > what
> >> >> > tools
> >> >> > I could use to troubleshoot this
> >> >> > further?
> >> >> >
> >> >> >
> >> >> > thanks,
> >> >> > Jim
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Relevant Pages

  • Re: Application Error 1000
    ... that since you application uses DSN, ADO will use OLEDB for ODBC between ADO ... > The last event that oLog writes is 'Executing' + the SQL statement. ... > is written to the log file. ... >>> We used the vb6 installation tool to make a Setup. ...
    (microsoft.public.vb.database.ado)
  • Windows Credentialing Security Problem
    ... think this is an IIS security issue, since I'm able to access the page I'm ... My web site has a virtual directory named FPSNowAuth. ... code executing in the context of a page request should be executing in ... the log file snippet. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Windows Credentialing Security Problem
    ... think this is an IIS security issue, since I'm able to access the page I'm ... My web site has a virtual directory named FPSNowAuth. ... code executing in the context of a page request should be executing in ... the log file snippet. ...
    (microsoft.public.inetserver.iis)
  • Windows Credentialing Security Problem
    ... think this is an IIS security issue, since I'm able to access the page I'm ... My web site has a virtual directory named FPSNowAuth. ... code executing in the context of a page request should be executing in ... the log file snippet. ...
    (microsoft.public.windows.server.security)
  • Re: Concurrent Batch/queue entries
    ... concurrent jobs that may be executing in that queue. ... If you have a log file for the executing job, wait one minute for the system ... usually means that it is waiting for I/O to complete. ...
    (comp.os.vms)