MSDE 2000 and rda.pull?

  • Thread starter Thread starter Tomer
  • Start date Start date
T

Tomer

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.
 
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
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top