Upgrade.exe keeps failing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rof - 10 Sep 2007 12:46 GMT

I am trying to use the SQL Server Mobile Database Upgrade tool,
Upgrade.exe. It was giving me error 25046, "database file not found",
byt I've solved that and I'm not getting that error any more. What I
am now getting is 25017, which means "the database file is corrupted"
- but I don't believe it is, because the application that uses it
works fine.

Does anyone out there know what else could produce this error?

TIA,
Peter Royle

Reply to this Message

Erik Ejlskov - 10 Sep 2007 16:36 GMT

How large is your SQL CE 2.0 file. If larger than 128 MB, compact before
upgrading

Is it encrypted, then unencrypt before upgrading.

Try to run repair and compact before upgrading.

Signature

Erik Ejlskov Jensen
- see my SQL Compact blog at
http://erikej.blogspot.com

>I am trying to use the SQL Server Mobile Database Upgrade tool,
> Upgrade.exe. It was giving me error 25046, "database file not found",
[quoted text clipped - 7 lines]
> TIA,
> Peter Royle

Reply to this Message

Rof - 11 Sep 2007 09:32 GMT

> How large is your SQL CE 2.0 file. If larger than 128 MB, compact before
> upgrading
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Thanks, but the one I am trying to test the upgrade on is only 760 kb.
I don't know what tool to use to "repair" it - and, as I say, it works
perfectly OK with the application that uses it.

Peter Royle

Reply to this Message

Pete Vickers - 11 Sep 2007 13:34 GMT

Hi,
it produces a log file (upgrade.log?) if I remember correctly - what does
the log file say, or is this where you are getting the error from?

Pete

>I am trying to use the SQL Server Mobile Database Upgrade tool,
> Upgrade.exe. It was giving me error 25046, "database file not found",
[quoted text clipped - 7 lines]
> TIA,
> Peter Royle

Reply to this Message

Rof - 18 Sep 2007 09:21 GMT

On Sep 11, 1:34 pm, "Pete Vickers" <pete.vick...@thesleepdepot.com>
wrote:

> Hi,
> it produces a log file (upgrade.log?) if I remember correctly - what does
[quoted text clipped - 13 lines]
>
> - Show quoted text -

Yes, but it's not the most helpful log in the world:

HRESULT: 0x80004005

Error Record 1
Minor: 25017
HRESULT: 0x80004005
Source: Microsoft SQL Server 2000 Windows CE Edition
Description: Unspecified error
Database upgrade failed

Error 25017 means "Database file is corrupted" - which I don't
believe, 'cos as I say, the application works fine.

Rof

Reply to this Message