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!

After I update the existed sql 2000 to sql 2005. But I saw the sql is still running v8.0 (

Dear All,
After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
running the 2000 core).
But I remembered that I had selected the options to upgraded the existed
SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
I saw some helps that when I setup the SQL2K5. Add one parameters when
setting up?
Thanks for your helps first,;)
Best Regards,
Benny Ng
Hi Benny
Your databases may be in 8.0 compatability mode, but if you upgraded
correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
If you look in the services applet you should see what services are running.
You should also have the SQL 2005 tools available on the start menu.
John
"Benny Ng" wrote:

> Dear All,
> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> running the 2000 core).
> But I remembered that I had selected the options to upgraded the existed
> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
> I saw some helps that when I setup the SQL2K5. Add one parameters when
> setting up?
> Thanks for your helps first,;)
>
> Best Regards,
> Benny Ng
>
>
|||Dear John Bell,
The command SELECT @.@.VERSION, After running. The result i got is
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
And surely i have the SQL2K5 tools on the start menu. The difference
between my laptop (it's normally installed SQL2K5) is only the SQL engine.
Best Regards,
Benny Ng
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...[vbcol=seagreen]
> Hi Benny
> Your databases may be in 8.0 compatability mode, but if you upgraded
> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> give?
> If you look in the services applet you should see what services are
> running.
> You should also have the SQL 2005 tools available on the start menu.
> John
> "Benny Ng" wrote:
|||Hi
What does the services applet show in terms of instances running? Are you
running the upgrade using the correct version of the CDs? Have you run the
latest upgrade advisor?
John
"Benny Ng" wrote:

> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference
> between my laptop (it's normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
>
>

After I update the existed sql 2000 to sql 2005. But I saw the sql is still running v8.0 (

Dear All,
After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
running the 2000 core).
But I remembered that I had selected the options to upgraded the existed
SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
I saw some helps that when I setup the SQL2K5. Add one parameters when
setting up?
Thanks for your helps first,;)
Best Regards,
Benny NgHi Benny
Your databases may be in 8.0 compatability mode, but if you upgraded
correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
If you look in the services applet you should see what services are running.
You should also have the SQL 2005 tools available on the start menu.
John
"Benny Ng" wrote:
> Dear All,
> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> running the 2000 core).
> But I remembered that I had selected the options to upgraded the existed
> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
> I saw some helps that when I setup the SQL2K5. Add one parameters when
> setting up?
> Thanks for your helps first,;)
>
> Best Regards,
> Benny Ng
>
>|||Dear John Bell,
The command SELECT @.@.VERSION, After running. The result i got is
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
And surely i have the SQL2K5 tools on the start menu. The difference
between my laptop (it's normally installed SQL2K5) is only the SQL engine.
Best Regards,
Benny Ng
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
> Hi Benny
> Your databases may be in 8.0 compatability mode, but if you upgraded
> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> give?
> If you look in the services applet you should see what services are
> running.
> You should also have the SQL 2005 tools available on the start menu.
> John
> "Benny Ng" wrote:
>> Dear All,
>> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
>> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
>> running the 2000 core).
>> But I remembered that I had selected the options to upgraded the
>> existed
>> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
>> Can anyone tell me how can I upgrade the existed SQL2K core to
>> SQL2K5?
>> I saw some helps that when I setup the SQL2K5. Add one parameters when
>> setting up?
>> Thanks for your helps first,;)
>>
>> Best Regards,
>> Benny Ng
>>
>>|||Perhaps you have several instances of SQL Server and you didn't upgrade the instance you are looking
at...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Benny Ng" <benny_wufree@.hotmail.com> wrote in message news:O85gxiIDHHA.628@.TK2MSFTNGP04.phx.gbl...
> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003
> Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference between my laptop (it's
> normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
>> Hi Benny
>> Your databases may be in 8.0 compatability mode, but if you upgraded
>> correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION give?
>> If you look in the services applet you should see what services are running.
>> You should also have the SQL 2005 tools available on the start menu.
>> John
>> "Benny Ng" wrote:
>> Dear All,
>> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
>> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
>> running the 2000 core).
>> But I remembered that I had selected the options to upgraded the existed
>> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
>> Can anyone tell me how can I upgrade the existed SQL2K core to SQL2K5?
>> I saw some helps that when I setup the SQL2K5. Add one parameters when
>> setting up?
>> Thanks for your helps first,;)
>>
>> Best Regards,
>> Benny Ng
>>
>>
>|||Hi
What does the services applet show in terms of instances running? Are you
running the upgrade using the correct version of the CDs? Have you run the
latest upgrade advisor?
John
"Benny Ng" wrote:
> Dear John Bell,
> The command SELECT @.@.VERSION, After running. The result i got is
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
> And surely i have the SQL2K5 tools on the start menu. The difference
> between my laptop (it's normally installed SQL2K5) is only the SQL engine.
> Best Regards,
> Benny Ng
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FCEDD671-606D-4245-AC07-774ADC5D10CC@.microsoft.com...
> > Hi Benny
> >
> > Your databases may be in 8.0 compatability mode, but if you upgraded
> > correctly it should be the SQL 2005 engine. What does SELECT @.@.VERSION
> > give?
> >
> > If you look in the services applet you should see what services are
> > running.
> > You should also have the SQL 2005 tools available on the start menu.
> >
> > John
> >
> > "Benny Ng" wrote:
> >
> >> Dear All,
> >>
> >> After I upgraded the existed SQL SERVER2000 to SQL SERVER 2005. But I
> >> saw the SQL SERVER is still running V8.0(It means the SQL SERVER is still
> >> running the 2000 core).
> >>
> >> But I remembered that I had selected the options to upgraded the
> >> existed
> >> SQL SERVER. (Not runs on SQL2K and SQL2K5 parallel).
> >>
> >> Can anyone tell me how can I upgrade the existed SQL2K core to
> >> SQL2K5?
> >> I saw some helps that when I setup the SQL2K5. Add one parameters when
> >> setting up?
> >>
> >> Thanks for your helps first,;)
> >>
> >>
> >> Best Regards,
> >>
> >> Benny Ng
> >>
> >>
> >>
> >>
>
>