Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1023
  • Last Modified:

System.Runtime.InteropServices.COMException (0x80040E37): Invalid object name

Getting this message on VB App when trying to run on server - works great on my XP machine.....

System.Runtime.InteropServices.COMException (0x80040E37): Invalid object name 'A'.
   at ADODB.ConnectionClass.Execute(String CommandText, Object& RecordsAffected, Int32 Options)
   at PNOC.mssql_connect.Get_Records(String& strSQL)
   at PNOC.mainform.ProcessData(String& strFile)
   at PNOC.mainform.Timer1_Tick(Object eventSender, EventArgs eventArgs)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  • 2
1 Solution
tmhechlerAuthor Commented:
Oops...forgot to say...PLEASE HELP!  My applciation was working FINE..then the SQL log file for the DB became "FULL"....Applcation crashed....I get same error now as when it initially crashed. (I have been rebuilding/republishing for two days now, trying to figure this out).

This is a shared server, so someone could have made changes to it that I am unaware of....however, I've checked the logs for the time it crashed, and don't see anything except for the fact that the LOG file got full (which I have rectified now with a scheduled DTS package to shrink once a day...)

I believe this can be a sql error.  You might display the exact sql being run and then eyeball it or try it from query analyzer.
tmhechlerAuthor Commented:
Thanks.  The query ran fine.  However, while in SQL I did check a few other things out, and it ended up being a bad update trigger on the main table.  So, your answer led me to the issue.  Thanks!

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now