asked on

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)

tmhechler

ASKER

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...)

THANKS IN ADVANCE!!!!

ASKER CERTIFIED SOLUTION

mastoo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tmhechler

ASKER

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!