Hello,
I may have posted in the wrong place, if so, feel free to move my post (just
notify me where you put it via email or something)
I’m having a problem with my program that I cant readily explain. The
program connects to, then reads and creates a new flat old Dbase files (.DBF)
stored on a network drive. The program itself is run from the very same
network drive/folder.
When I run the program over a WORKGROUPed network, it has no problems. When
I try to execute the program in a DOMAIN network, it crashes with an
unhandled exception error found at the bottom of this post.
I have pasted below the code that appears to be generating the error.
I have check the NTFS and share permissions of all files and folders
involved, and everything looks right. I even tried giving “everyone” full
permissions- no help.
QUESTION:
Other than permissions- what would cause a program to generate unhandled
exceptions on a DOMAIN network, but not an a WORKGROUP network?
I don’t know if I will be able to install visual studio debugger on the
domain network to step through the program. What other suggestions would you
have for debugging this (both at home, where I have the visual studio AND on
the domain where I do not)?
Many thanks for your help,
Oliver
CODE:
Dim DBConn
DBConn = OpenDBFConn(".\\") 'specify the current folder
..
..
..
Dim create_string = "SELECT [CTtemp#DBF].*, [SYSPROF1#DBF].SYSCOMP AS cocode "
create_string += "INTO [" + Dest_File_Name + "#dbf] FROM
[CTtemp#DBF], [SYSPROF1#DBF] "
create_string += "WHERE ((([SYSPROF1#DBF].SYSCOMP)='" +
CompanyCode + "'));"
On Error GoTo CantCreateDestination
Dim create_result = DBConn.Execute(create_string)
ERROR:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Runtime.InteropServices.COMException (0x80040E21): Index not found.
at Microsoft.VisualBasic.CompilerServices.LateBinding .LateGet(Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack)
at VBTableCombiner.Form1.CombineButton_Click1(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage (Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(M essage& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase: file:///c:/winnt/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/winnt/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/winnt/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
VBTableCombiner
Assembly Version: 1.0.2022.3794
Win32 Version: 1.0.2022.3794
CodeBase: file:///T:/cmswin/VBTableCombiner.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.2032
CodeBase:
file:///c:/winnt/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 7.0.5000.0
Win32 Version: 7.10.6001.4
CodeBase:
file:///c:/winnt/assembly/gac/microsoft.visualbasic/7.0.5000.0__b03f5f7f11d50a3a/microsoft.visualbasic.dll
----------------------------------------
************** 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:
<configuration>
<system.windows.forms jitDebugging="true" />
</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.