MSDE 2000 and rda.pull?

Hi , i've install the msde 2000 and tried to install the sql server ce 2.0,
but it notify me that it needs sql server 2000 in order to install the
server tools.
now, i know that in order to perform a pull command from sql server, you
need the sscesa20.dll to run on the IIS, after i've managed to do that, and
check that it works from the internet explorer, i've tried the pull command,
but i got an exception from the sql server 2000 : An internal error occurred
[ID,,,,].

The question is of course why does this happens, do i need some more dlls?

The whole purpose of installing msde is for disposing the need of buying the
expensive sql server 2000 by every customer that wants a ppc application
that handles a database.

Tomer.

Ginny
Mon Jan 26 11:14:50 CST 2004

Tomer,

Perhaps this article will be helpful:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q303789
--
Ginny Caughey
.Net Compact Framework MVP

"Tomer" <Tomek13m@hotmail.com> wrote in message
news:%23APR3WC5DHA.2624@TK2MSFTNGP09.phx.gbl...
> Hi , i've install the msde 2000 and tried to install the sql server ce
2.0,
> but it notify me that it needs sql server 2000 in order to install the
> server tools.
> now, i know that in order to perform a pull command from sql server, you
> need the sscesa20.dll to run on the IIS, after i've managed to do that,
and
> check that it works from the internet explorer, i've tried the pull
command,
> but i got an exception from the sql server 2000 : An internal error
occurred
> [ID,,,,].
>
> The question is of course why does this happens, do i need some more dlls?
>
> The whole purpose of installing msde is for disposing the need of buying
the
> expensive sql server 2000 by every customer that wants a ppc application
> that handles a database.
>
> Tomer.
>
>

chris-s
Tue Jan 27 02:46:40 CST 2004

In short, when installing the SQLCE toolkit it checks to see what service
pack of sql server is installed, when it finds MSDE, it doesn't recognise it
as a valid SQL Server service pack level. There are several ways around
this...

1/ Un-Install the MSDE, install SQLCE then re-install MSDE
2/ Delete the MSDE registry keys, but keep a backup of them, then install
SQLCE then re-install the registry keys
3/ Install the SQLCE on a separate PC that just has IIS not MSDE or SQL
Server

Whilst the MSDE works fine, be aware of the limitations on the number of
users. Also, presumably you are using IIS that comes with XP Pro or Win2K
Pro rather than the server editions, this also has limitations on the number
of users/sessions.

Chris


"Tomer" <Tomek13m@hotmail.com> wrote in message
news:#APR3WC5DHA.2624@TK2MSFTNGP09.phx.gbl...
> Hi , i've install the msde 2000 and tried to install the sql server ce
2.0,
> but it notify me that it needs sql server 2000 in order to install the
> server tools.
> now, i know that in order to perform a pull command from sql server, you
> need the sscesa20.dll to run on the IIS, after i've managed to do that,
and
> check that it works from the internet explorer, i've tried the pull
command,
> but i got an exception from the sql server 2000 : An internal error
occurred
> [ID,,,,].
>
> The question is of course why does this happens, do i need some more dlls?
>
> The whole purpose of installing msde is for disposing the need of buying
the
> expensive sql server 2000 by every customer that wants a ppc application
> that handles a database.
>
> Tomer.
>
>

Tomer
Tue Jan 27 03:49:14 CST 2004

First of all thanks of the info, I'll check it out.
But I think i found another way around it, when installing the sqlce server
tools, then setup extracts its file to the temp directory (cabs and msi) but
delete them after it fails to install. So when the setup pops up the error
message you can grab those files before pressing ok on the error message,
after that you can run the msi, and install the server tools.
I haven't checked it fully yet, have some problem with accessing the sql
database, but I think it would be ok.
Since I don't have the enterprise manager, I'm looking for a replacement
applications, I've tried the "vale software MSDE manager" but its not good
enough, I need DTS design feature, scheduler ,and replication control
feature, know any program that does that?

Tomer.

"chris-s" <chris-s@mailcity.com> wrote in message
news:e3tbKJL5DHA.1292@TK2MSFTNGP11.phx.gbl...
> In short, when installing the SQLCE toolkit it checks to see what service
> pack of sql server is installed, when it finds MSDE, it doesn't recognise
it
> as a valid SQL Server service pack level. There are several ways around
> this...
>
> 1/ Un-Install the MSDE, install SQLCE then re-install MSDE
> 2/ Delete the MSDE registry keys, but keep a backup of them, then install
> SQLCE then re-install the registry keys
> 3/ Install the SQLCE on a separate PC that just has IIS not MSDE or SQL
> Server
>
> Whilst the MSDE works fine, be aware of the limitations on the number of
> users. Also, presumably you are using IIS that comes with XP Pro or Win2K
> Pro rather than the server editions, this also has limitations on the
number
> of users/sessions.
>
> Chris
>
>
> "Tomer" <Tomek13m@hotmail.com> wrote in message
> news:#APR3WC5DHA.2624@TK2MSFTNGP09.phx.gbl...
> > Hi , i've install the msde 2000 and tried to install the sql server ce
> 2.0,
> > but it notify me that it needs sql server 2000 in order to install the
> > server tools.
> > now, i know that in order to perform a pull command from sql server, you
> > need the sscesa20.dll to run on the IIS, after i've managed to do that,
> and
> > check that it works from the internet explorer, i've tried the pull
> command,
> > but i got an exception from the sql server 2000 : An internal error
> occurred
> > [ID,,,,].
> >
> > The question is of course why does this happens, do i need some more
dlls?
> >
> > The whole purpose of installing msde is for disposing the need of buying
> the
> > expensive sql server 2000 by every customer that wants a ppc application
> > that handles a database.
> >
> > Tomer.
> >
> >
>
>