Error during V7 to 2000 upgrade. Its URGENT

I launch an installatino of SQL Server 2000 on a server, upgrading the V7 original datbase but it failed with error :
"the ordinal 105 could not be located in the dynamic link library opends60.dll"

And the SQL server services cant' start.

Can someone help me ?
It's urgent.I suggest you contact Microsoft -- I cannot find anything that relates to your problem|||I concur. I hope you made some backups somewhere. Have you tried reinstalling 7. Google, books online, my large SQL book says nothing about this.

Get MS engineer on the phone.|||OK, step back.

HOW did you do the "upgrade"?|||Thanks all, I found the way to correct this problem on another forum:

The cause of this is the sqlservr.exe and sqlsort.dll in the MSSQL7BINN directory are still on a hotfix build. When the upgrade wizard tries to stop SQL 7.0 and tries to start SQL 2000 it checks the version on the sqlservr.exe and sqlsort.dll. It is unable to recognise the hotfix versioning and therefore SQL 2000 stops. SQL 7.0 which has already been stopped by this point ends up corrupted.

The following options are available to recover from this problem

a) Pull out the hotfix and go back to Sp3 on the machines where upgrade has not been attempted

b) On the machines that upgrade has been attempted, rename the 4 files that are part of the hotfix: sqlservr.exe, sqlservr.pdb, sqlservr.dbg, sqlsort.dll. Copy the sqlservr.exe and sqlsort.dll from the SQL 2000 install point to the MSSQL7BINN. Re-run setup and allow it to resume from where it stopped before.

c) Upgrade to Sp4 prior to upgrading the machine to SQL 2K.

This error does not seem to be documented anywhere. It is not on Technet and I only got the explanation through a contact in Microsoft

Error during upgrade of SQL Server 7.0 to 2000

Hello!
I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
2000 on Windows 2000 server, during the upgrade
I received the following error message " Error running
script:messages.sql(1)".
I found Microsoft article 300676 how to fix this problem.
In this article they provide link to the new setup.ins file
you have to download in order to fix your installation.
Here's the link and it doesn't work:
ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
Does anybody know the correct link? Or where I can download this file from?
Thank you,
LenaArticle says:
To use the fix, use these steps:
1.. Download s80305i.exe
from:ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
The password is: 8.00.305
2.. To install SQL Server 2000 using the new Setup.ins file, copy all of
the files on the SQL Server 2000 CD to a directory on your drive.
3.. Replace the existing Setup.ins in the \x86\Setup\ folder with the
Setup.ins file that you downloaded in the fix.
4.. Rerun the SQL Server 2000 setup.
It is working fine. I just cheked this out. If you will not able to download
it let me know your EMail I'll send it to you.
Regards
---
All information provided above AS IS.
"Lena" <lenaglozman@.yahoo.com> wrote in message
news:fc1e8071.0310310848.12b948d5@.posting.google.com...
> Hello!
> I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
> 2000 on Windows 2000 server, during the upgrade
> I received the following error message " Error running
> script:messages.sql(1)".
> I found Microsoft article 300676 how to fix this problem.
> In this article they provide link to the new setup.ins file
> you have to download in order to fix your installation.
> Here's the link and it doesn't work:
> ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
> Does anybody know the correct link? Or where I can download this file
from?
> Thank you,
> Lena|||I could download the file from
ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/s80
305i.exe and then ran winzip to extract the setup.ins
file, the password to unzip this file is 8.00.305.
Let me know if you still having problem downloading this
file, i can email the setup.ins file to you.
>--Original Message--
>Hello!
>I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
>2000 on Windows 2000 server, during the upgrade
> I received the following error message " Error running
>script:messages.sql(1)".
>I found Microsoft article 300676 how to fix this problem.
>In this article they provide link to the new setup.ins
file
>you have to download in order to fix your installation.
>Here's the link and it doesn't work:
>ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
>Does anybody know the correct link? Or where I can
download this file from?
>Thank you,
>Lena
>.
>

Error during SQL 2000 SP3a upgrade

I received the following error while executing the
REPLCOM.SQL script during the upgrade.
[DBNETLIB]General network error. Check your network
documentation.
[DBNETLIB]ConnectionRead (recv()).
This was the only output in REPLCOM.OUT.
Any ideas, I upgraded other servers and this did not
happen. I was upgrading from SQL 2000 SP2.
Mark,
Is the SQL Server service pack directory you are installing from on the
network or on your local machine? Perhaps there was a network outage
whilst the upgrade was running?
Can you copy the install directory locally and run it again?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Gozick wrote:
> I received the following error while executing the
> REPLCOM.SQL script during the upgrade.
> [DBNETLIB]General network error. Check your network
> documentation.
> [DBNETLIB]ConnectionRead (recv()).
> This was the only output in REPLCOM.OUT.
> Any ideas, I upgraded other servers and this did not
> happen. I was upgrading from SQL 2000 SP2.
sql

Error during SQL 2000 SP3a upgrade

I received the following error while executing the
REPLCOM.SQL script during the upgrade.
[DBNETLIB]General network error. Check your network
documentation.
[DBNETLIB]ConnectionRead (recv()).
This was the only output in REPLCOM.OUT.
Any ideas, I upgraded other servers and this did not
happen. I was upgrading from SQL 2000 SP2.Mark,
Is the SQL Server service pack directory you are installing from on the
network or on your local machine? Perhaps there was a network outage
whilst the upgrade was running?
Can you copy the install directory locally and run it again?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Gozick wrote:
> I received the following error while executing the
> REPLCOM.SQL script during the upgrade.
> [DBNETLIB]General network error. Check your network
> documentation.
> [DBNETLIB]ConnectionRead (recv()).
> This was the only output in REPLCOM.OUT.
> Any ideas, I upgraded other servers and this did not
> happen. I was upgrading from SQL 2000 SP2.

Error during SQL 2000 SP3a upgrade

I received the following error while executing the
REPLCOM.SQL script during the upgrade.
[DBNETLIB]General network error. Check your network
documentation.
[DBNETLIB]ConnectionRead (recv()).
This was the only output in REPLCOM.OUT.
Any ideas, I upgraded other servers and this did not
happen. I was upgrading from SQL 2000 SP2.Mark,
Is the SQL Server service pack directory you are installing from on the
network or on your local machine? Perhaps there was a network outage
whilst the upgrade was running?
Can you copy the install directory locally and run it again?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Gozick wrote:
> I received the following error while executing the
> REPLCOM.SQL script during the upgrade.
> [DBNETLIB]General network error. Check your network
> documentation.
> [DBNETLIB]ConnectionRead (recv()).
> This was the only output in REPLCOM.OUT.
> Any ideas, I upgraded other servers and this did not
> happen. I was upgrading from SQL 2000 SP2.

Error Code 2259 applying SQL2005 service pack

I have SQL 2005 Express installed. When I try to apply service pack 1 to this by going through the upgrade process, I get an error ' THe installer has encountered an unexpected error. The error code is 2259. Table(s) update failed'

Any ideas? Help!

Ranjit Charles

Ranjit, are you trying to run the Express SP1 refresh package or the full SP1 installer?

Thanks,
Sam Lester (MSFT)

|||

Sam,

I was using the full SP1 installer. I couldn't really find the SP1 refresh ..

Ranjit

|||

Ah, OK. That should be the issue. If you go to the SP1 page at http://www.microsoft.com/downloads/details.aspx?FamilyID=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&DisplayLang=en

It has a link midway down the page for the Express upgrades. Here's a snippet...

Overview

Service Pack 1 for Microsoft SQL Server 2005 is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions:

Enterprise Enterprise Evaluation Developer Standard Workgroup