System.Data.OleDb.OleDbException: Unspecified error

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sarah
    #1

    System.Data.OleDb.OleDbException: Unspecified error

    I have a function residing in a module that is doing some file copy and
    database query operations. This function is called from a regular form under
    a System.Windows. Forms.Timer control. The problem is that sometimes it gives
    an error - even when it is doing the same exact operations. It may fail on
    the 20th tick event or the 100th. The file and data has no changes - so, it
    is doing the same operations repeatedly. I'm wondering if anyone can look at
    the error below and tell me where to start because I know that there is no
    problem with the code to copy the files or to read/write to the database.
    The error comes up during different points of the code execution in the
    function - pretty random.



    Error Message:

    See the end of this message for details on invoking

    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************

    System.Data.Ole Db.OleDbExcepti on: Unspecified error

    at System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr)

    at System.Data.Ole Db.OleDbConnect ion.InitializeP rovider()

    at System.Data.Ole Db.OleDbConnect ion.Open()

    at DominosUI_VBPro ject.mdlDatabas eConnection.Sta rtDBConnection( ) in
    F:\Source Code\mdlDatabas eConnection.vb: line 26

    at DominosUI_VBPro ject.mdlSoftwar eEventLog.fxLog DebugEvent(Stri ng
    CprtEventDescri ption) in F:\Source Code\mdlSoftwar eEventLog.vb:li ne 28

    at DominosUI_VBPro ject.mdlAutoPri ntPos1.AutoPrin tPos1() in F:\Source
    Code\mdlAutoPri ntPos1.vb:line 264

    at DominosUI_VBPro ject.MainForm.t imerAutomaticPr inting_Tick(Obj ect sender,
    EventArgs e) in F:\Source Code\MainForm.v b:line 1474

    at System.Windows. Forms.Timer.OnT ick(EventArgs e)

    at System.Windows. Forms.Timer.Deb uggableCallback (IntPtr hWnd, Int32 msg,
    IntPtr idEvent, IntPtr dwTime)



    ************** Loaded Assemblies **************

    mscorlib

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.288

    CodeBase: file:///c:/windows/microsoft.net/framework/v1.0.3705/mscorlib.dll

    ----------------------------------------

    DominosUI_VBPro ject

    Assembly Version: 1.0.1810.5631

    Win32 Version: 1.0.1810.5631

    CodeBase: file:///F:/Source Code/bin/DominosUI_VBPro ject.exe

    ----------------------------------------

    System.Windows. Forms

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.288

    CodeBase:
    file:///c:/windows/assembly/gac/system.windows. forms/1.0.3300.0__b77 a5c56193
    4e089/system.windows. forms.dll

    ----------------------------------------

    System

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.288

    CodeBase:
    file:///c:/windows/assembly/gac/system/1.0.3300.0__b77 a5c561934e089/system.d
    ll

    ----------------------------------------

    System.Drawing

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.288

    CodeBase:
    file:///c:/windows/assembly/gac/system.drawing/1.0.3300.0__b03 f5f7f11d50a3a/
    system.drawing. dll

    ----------------------------------------

    Microsoft.Visua lBasic

    Assembly Version: 7.0.3300.0

    Win32 Version: 7.00.9502

    CodeBase:
    file:///c:/windows/assembly/gac/microsoft.visua lbasic/7.0.3300.0__b03 f5f7f11
    d50a3a/microsoft.visua lbasic.dll

    ----------------------------------------

    System.Data

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.288

    CodeBase:
    file:///c:/windows/assembly/gac/system.data/1.0.3300.0__b77 a5c561934e089/sys
    tem.data.dll

    ----------------------------------------

    System.Enterpri seServices

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.288

    CodeBase:
    file:///c:/windows/assembly/gac/system.enterpri seservices/1.0.3300.0__b03 f5f
    7f11d50a3a/system.enterpri seservices.dll

    ----------------------------------------

    Accessibility

    Assembly Version: 1.0.3300.0

    Win32 Version: 1.0.3705.0

    CodeBase:
    file:///c:/windows/assembly/gac/accessibility/1.0.3300.0__b03 f5f7f11d50a3a/a
    ccessibility.dl l

    ----------------------------------------

    ************** JIT Debugging **************

    To enable just in time (JIT) debugging, the config file for this

    application or machine (machine.config ) must have the

    jitDebugging value set in the system.windows. forms section.

    The application must also be compiled with debugging

    enabled.

    For example:

    <configuratio n>

    <system.windows .forms jitDebugging="t rue" />

    </configuration>

    When JIT debugging is enabled, any unhandled exception

    will be sent to the JIT debugger registered on the machine

    rather than being handled by this dialog.





    Tags: None
    • scorpion53061
      #2
      Re: System.Data.Ole Db.OleDbExcepti on: Unspecified error

      Sarah,

      Try stepping through the program to see what line exactly is throwing
      the exception and then post that section of code here.

      "Sarah" <sarah.nntp@pow ertechcanada.co m> wrote in message
      news:sarah.nntp @powertechcanad a.com:[color=blue]
      > I have a function residing in a module that is doing some file copy and
      > database query operations. This function is called from a regular form
      > under
      > a System.Windows. Forms.Timer control. The problem is that sometimes it
      > gives
      > an error - even when it is doing the same exact operations. It may fail
      > on
      > the 20th tick event or the 100th. The file and data has no changes - so,
      > it
      > is doing the same operations repeatedly. I'm wondering if anyone can look
      > at
      > the error below and tell me where to start because I know that there is
      > no
      > problem with the code to copy the files or to read/write to the
      > database.
      > The error comes up during different points of the code execution in the
      > function - pretty random.
      >
      >
      >
      > Error Message:
      >
      > See the end of this message for details on invoking
      >
      > just-in-time (JIT) debugging instead of this dialog box.
      >
      > ************** Exception Text **************
      >
      > System.Data.Ole Db.OleDbExcepti on: Unspecified error
      >
      > at System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr)
      >
      > at System.Data.Ole Db.OleDbConnect ion.InitializeP rovider()
      >
      > at System.Data.Ole Db.OleDbConnect ion.Open()
      >
      > at DominosUI_VBPro ject.mdlDatabas eConnection.Sta rtDBConnection( ) in
      > F:\Source Code\mdlDatabas eConnection.vb: line 26
      >
      > at DominosUI_VBPro ject.mdlSoftwar eEventLog.fxLog DebugEvent(Stri ng
      > CprtEventDescri ption) in F:\Source Code\mdlSoftwar eEventLog.vb:li ne 28
      >
      > at DominosUI_VBPro ject.mdlAutoPri ntPos1.AutoPrin tPos1() in F:\Source
      > Code\mdlAutoPri ntPos1.vb:line 264
      >
      > at DominosUI_VBPro ject.MainForm.t imerAutomaticPr inting_Tick(Obj ect
      > sender,
      > EventArgs e) in F:\Source Code\MainForm.v b:line 1474
      >
      > at System.Windows. Forms.Timer.OnT ick(EventArgs e)
      >
      > at System.Windows. Forms.Timer.Deb uggableCallback (IntPtr hWnd, Int32 msg,
      > IntPtr idEvent, IntPtr dwTime)
      >
      >
      >
      > ************** Loaded Assemblies **************
      >
      > mscorlib
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.288
      >
      > CodeBase:
      > file:///c:/windows/microsoft.net/framework/v1.0.3705/mscorlib.dll
      >
      > ----------------------------------------
      >
      > DominosUI_VBPro ject
      >
      > Assembly Version: 1.0.1810.5631
      >
      > Win32 Version: 1.0.1810.5631
      >
      > CodeBase: file:///F:/Source Code/bin/DominosUI_VBPro ject.exe
      >
      > ----------------------------------------
      >
      > System.Windows. Forms
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.288
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/system.windows. forms/1.0.3300.0__b77 a5c56193
      >
      > 4e089/system.windows. forms.dll
      >
      > ----------------------------------------
      >
      > System
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.288
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/system/1.0.3300.0__b77 a5c561934e089/system.d
      >
      > ll
      >
      > ----------------------------------------
      >
      > System.Drawing
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.288
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/system.drawing/1.0.3300.0__b03 f5f7f11d50a3a/
      >
      > system.drawing. dll
      >
      > ----------------------------------------
      >
      > Microsoft.Visua lBasic
      >
      > Assembly Version: 7.0.3300.0
      >
      > Win32 Version: 7.00.9502
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/microsoft.visua lbasic/7.0.3300.0__b03 f5f7f11
      >
      > d50a3a/microsoft.visua lbasic.dll
      >
      > ----------------------------------------
      >
      > System.Data
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.288
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/system.data/1.0.3300.0__b77 a5c561934e089/sys
      >
      > tem.data.dll
      >
      > ----------------------------------------
      >
      > System.Enterpri seServices
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.288
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/system.enterpri seservices/1.0.3300.0__b03 f5f
      >
      > 7f11d50a3a/system.enterpri seservices.dll
      >
      > ----------------------------------------
      >
      > Accessibility
      >
      > Assembly Version: 1.0.3300.0
      >
      > Win32 Version: 1.0.3705.0
      >
      > CodeBase:
      >
      > file:///c:/windows/assembly/gac/accessibility/1.0.3300.0__b03 f5f7f11d50a3a/a
      >
      > ccessibility.dl l
      >
      > ----------------------------------------
      >
      > ************** JIT Debugging **************
      >
      > To enable just in time (JIT) debugging, the config file for this
      >
      > application or machine (machine.config ) must have the
      >
      > jitDebugging value set in the system.windows. forms section.
      >
      > The application must also be compiled with debugging
      >
      > enabled.
      >
      > For example:
      >
      > <configuratio n>
      >
      > <system.windows .forms jitDebugging="t rue" />
      >
      > </configuration>
      >
      > When JIT debugging is enabled, any unhandled exception
      >
      > will be sent to the JIT debugger registered on the machine
      >
      > rather than being handled by this dialog.[/color]

        Comment

        • Sarah
          #3
          Re: System.Data.Ole Db.OleDbExcepti on: Unspecified error

          [color=blue]
          >
          > Try stepping through the program to see what line exactly is throwing
          > the exception and then post that section of code here.
          >[/color]

          There are a lot of lines of code and the problem is that it does not happen
          every time. Sometimes it executes the tick every 5secs successfully for
          hours. So, I can't step through!

          It is executing the same code again and again - i.e. all running through the
          very same steps. It is connecting to an Access .mdb database file and only
          fails once in a while. Same problem on multiple systems. CPU resource and
          memory usage very low. Anything else to try?


            Comment

            • scorpion53061
              #4
              Re: System.Data.Ole Db.OleDbExcepti on: Unspecified error

              Without code I can't help you to diagnose the problem.

              "Sarah" <sarah.nntp@pow ertechcanada.co m> wrote in message
              news:sarah.nntp @powertechcanad a.com:[color=blue][color=green]
              > >
              > > Try stepping through the program to see what line exactly is throwing
              > > the exception and then post that section of code here.
              > >[/color]
              >
              > There are a lot of lines of code and the problem is that it does not
              > happen
              > every time. Sometimes it executes the tick every 5secs successfully for
              > hours. So, I can't step through!
              >
              > It is executing the same code again and again - i.e. all running through
              > the
              > very same steps. It is connecting to an Access .mdb database file and
              > only
              > fails once in a while. Same problem on multiple systems. CPU resource
              > and
              > memory usage very low. Anything else to try?[/color]

                Comment

                Previous template Next
                Working...