[ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Events'. on INSERT

[subsume]

dim eventInsertQuery

eventInsertQuery = "INSERT INTO dbo.Events ('id','event_type','staff_id','department','subdepartment','event_date','timestamp','time_spent','comm_serv_id','advocacy_issue','notes')VALUES ('','" & request.Form("event_type") & "','" & request.Form("staff_id") & "','" & request.Form("dept") & "','" & request.Form("subdept") & "','" & request.Form("event_date") & "','" & NOW & "','" & request.Form("time_spent") & "','" & request.Form("comm_serv_id") & "','" & request.form("advocacy_issue") & "','" & request.form("event_notes") & "')"

 
'Response.Write(eventInsertQuery) 'testing echo

dim insertCmd
Set insertCmd = Server.CreateObject("ADODB.Command")
insertCmd.ActiveConnection = MM_editConnection
insertCmd.CommandText = eventInsertQuery
insertCmd.Execute  '''Offending line 454
insertCmd.ActiveConnection.Close

Err0r:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Events'.

/private/community_Services/addCommunitySvcContact.asp, line 454

--

According to Enterprise Manager owner is dbo.

[subsume]

Dunno why its being inconsistent, but I solved the problem by putting dbname.dbo.table

[mehere]

is your connection set up to use that database that contains that table?