MSDE Component

[Guest]

Is there an MSDE Component for XPE? If so, how do we get it? If not, is there a schedule for release of this component

I have seen numerous postings on this subject, and have yet to see a definitive response from Microsoft. Maybe someone has independently componentized MSDE. If this has been done, I'm not quite sure that we could "share" this component... from Microsoft's view point, but it would be good to know if it can be done and the amount of effort involved

Fortunately we are at a point in the development phase that we could use a third party embedded database that could be componentized. Has anyone out there done this

If anyone is interested in these efforts, and would like to share information and ideas, please email me at (e-mail address removed)

Thanks
Jake

 

[Andy Allred [MS]]

This is not an easy one to do for many reasons, including licensing, how to
service it and getting the SQL team on board to support it and fit it into
their schedules that have already been planned out for a very long time.
Componentizing it is the actually the easy part for me compared to the other
issues we need to resolve!

Our marketing folks and myself are working on these issues and I am just as
anxious to see this done as you are. While we work on the component we are
also investigating other ways of getting MSDE onto runtimes.

I can't make any promises on when or if this will be done because there are
so many factors outside of my control.

Thanks again for your patience.

Andy

--

This posting is provided "AS IS" with no warranties, and confers no rights.
==========================================================

Is there an MSDE Component for XPE? If so, how do we get it? If not, is

there a schedule for release of this component?

I have seen numerous postings on this subject, and have yet to see a

definitive response from Microsoft. Maybe someone has independently
componentized MSDE. If this has been done, I'm not quite sure that we could
"share" this component... from Microsoft's view point, but it would be good
to know if it can be done and the amount of effort involved.

Fortunately we are at a point in the development phase that we could use a

third party embedded database that could be componentized. Has anyone out
there done this?

If anyone is interested in these efforts, and would like to share

information and ideas, please email me at (e-mail address removed).

 

[Pieter]

Jake,

I have created a MSDE component. It seems like working. I even installed the
XPE database on it ). But didn't have the time to actualy build a image
with it. (
Sharing it could be a problem because I did the work in company time. I have
to consult a few people.
I can outline the work i did. It a quick and dirty job. Partly because of a
time problem an partly because my limted knowledge of registry entries and
working of the Component designer. So Iam open for suggetions to do a
cleaner job.

This is how i did the job:
1)
On a XPE machine I installed Inctrl. After that I installed MSDE with
Servicepack 3 with Inctrl monitoring.
2)
With the information from Inctrl I created a repository for the SQL files. I
did not compare the files with the same name I just compared the timestamp
and size. That could be a problem.
3)
I did a DLL/COM regstration for every dll in the repository.
4)
Imported the component in the database. Next I builded an image with the
MSDE component.
5)
Compared the registery entries of my image with the Inctrl file:
Added the registry information for DISTRIB.EXE, REPLMERGE.EXE and
SNAPSHOT.EXE because these are EXE and not DLL's. (I was not sure of this is
the same method) regsvr32 gave a error. So I guess not.
Added the HKLM\Software\Microsoft keys for DataAccess, Microsoft SQL server
and MSSQLSERVER.
Added keys for HKLM\Software\Description\microsoft\rpc\UuidTemporarydata
added keys (?) for HKCU\software\Microsoft\Microsoft SQL server
6)
Added the services in HKLM\System\Currentcontrolset\Services\SQLSERVERAGENT
and HKLM\System\Currentcontrolset\Services\MSSQLServer.
HKLM\System\Currentcontrolset\Services\eventlog\application.
HKLM\System\Currentcontrolset\Enum\Root\Legacy_MSSQLSERVER. (Some of this
could be done with a servicedata call from resources within CD. I think)

Todo:
Resolve dependencies for SQL server.



HTH

Pieter

Is there an MSDE Component for XPE? If so, how do we get it? If not, is

there a schedule for release of this component?

I have seen numerous postings on this subject, and have yet to see a

definitive response from Microsoft. Maybe someone has independently
componentized MSDE. If this has been done, I'm not quite sure that we could
"share" this component... from Microsoft's view point, but it would be good
to know if it can be done and the amount of effort involved.

Fortunately we are at a point in the development phase that we could use a

third party embedded database that could be componentized. Has anyone out
there done this?

If anyone is interested in these efforts, and would like to share

information and ideas, please email me at (e-mail address removed).