After upgrading to 2005, update and add no longer work in ASP pages.

Upgraded to SQL 2005 and now I get the following error when trying to add or update a record

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'NS1' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

/manage/inc_post_events.asp, line 57

The setup is one server running Windows Server 2000 with IIS and SQL 2005 installed. We previously had SQL 2000 and no issues. Now we cant add new records or update records. Anyone have any ideas? When looking in the tables, I notice in one database, some tables have a schema of dbo and some of a username.... HELP!Probably the wrong forum for this but:

Whats the name of the machine that you upgraded?
is it NS1?

If it is. . . did you name 2005 instance, or leave it as default?

Lets see a simple example of some update SQL that doesnt work

as far as schema names, db objects belong to the schema of the user who created them unless the user explictly declares the schema -

user 'foo' logs in

foo executes:
CREATE TABLE [BAR](i int)
CREATE TABLE [dbo].[BAR](i int)

now there are two tables:

[FOO].[BAR] & [DBO].[BAR]
lastly. . . Why are you using ODBC? SLOWWWWWWWWWWW and faulty!