C# Win App DB problem, ... on remote machine only

[pod]

Hello

My OS is Windows2000

I am new to .NET

I developed a C# Windows Application that connects to a MS Access database on the network using proper UNC format.

It works perfectly on my main machine (from which I have developed it).

Then I published it to the same location where the database is located on the network. Again the application works perfectly from my main machine.

I logged in onto another machine with the same profile, I go the published location, click the setup.exe file and then I get the .NET Framework Error popup displaying error information about the application having a problem finding table 0.

When I click continue on the error popup, the application portion that has nothing to do with the database is working perfectly, but the combobox that is supposed to be filled with a recordset, is empty.

I tried publishing it using both options "Available Online only" and "Online/Offline"

For debugging purposes, I have removed any connection strings to my machine , here's my config file:

<configuration>
  <appSettings>
    <add key="connStringDEV" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\echqw2ks04\Public\Office Search\_EC Tool\testdb\database\DB_OVR_Tracking.mdb" />
    <add key="connStringPRO" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\echqw2ks04\Public\Office Search\_EC Tool\testdb\database\DB_OVR_Tracking.mdb" />
  </appSettings>
  <system.windows.forms jitDebugging="true" />
</configuration>
 

Here's the error message:

************** Exception Text **************
System.IndexOutOfRangeException: Cannot find table 0.
   at System.Data.DataTableCollection.get_Item(Int32 index)
   at Tracking_WIN.OVRform.load_OVRform()
   at Tracking_WIN.OVRform.OVRform_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
 
 
************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Tracking_WIN
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Documents%20and%20Settings/pdorion/Local%20Settings/Apps/2.0/7GP2JMTR.G4B/8X8N69TN.12Z/trac..tion_f76f81ac2debb27c_0001.0000_21eca0aa59181f35/Tracking_WIN.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
winDBtools
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Documents%20and%20Settings/pdorion/Local%20Settings/Apps/2.0/7GP2JMTR.G4B/8X8N69TN.12Z/trac..tion_f76f81ac2debb27c_0001.0000_21eca0aa59181f35/winDBtools.DLL
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.832 (QFE.050727-8300)
    CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
 

It seems to load all the required DLLs, I am using two separate classes (winDBtools.DLL and customFunctions .dll) which are present on the remote machine.


Thank you in advance for any help


Perry :-D

[Plater]

Wow. I am amased you got an access database to work over the network at all.
(at least without creating an odbc object for it)
Only thing I can guess is there is some kinda of computer-based credentials that aren't allowed full access to the database or something?

[pod]

well, MS Access is the only alternative for now, and I am able to build really good tools with it, not without struggling but they do work well.

returning to my problem, as I am logged in on both machine with the same user rights, one would think I would have the same access rights from both location. I was under the impression that it could be the machine themselves, ... I don't really know where to go from here, but I will try something else...

Thanks Plater for your input

[Plater]

Aye, it could be the machine. I was having trouble with my own (granted it was an MS SQL server) where even though I was the same user with all the rights, it was trying to validate the machine as well.

[pod]

is this something I have to set in my win App properties? I am looking at the Application files, Prerequisites, and Options under the Publish section tab, and I am finding out all sorts of stuff but nothing that will solve my problem...

[Plater]

My problem was I had add my computer as a valid user of the database.
Does your database (or the server hosting it) have any strange permisions that need to be set? Like domain permisions?

[pod]

no strange permissions needed, and I even gave everyone full control

[pod]

FOUND IT!

After talking to a few colleagues, I inserted a few more TRY CATCH tags and found the error: "need MDAC 2.6 or later"

So in the Win App properties, I checked the MDAC in the Prerequisistes

...and with this, the problem disappeared ..

So it was a machine problem after all,

thanks again Plater


P :-D