media center database!

tombidibuzz · **8th February 2006, 03:00 AM**

i replace my question in the right place!

I am trying to reproduce behaviour of Lineup Editor powertoy and we have a question regarding the storage of information.

i found that some info is writen in prefs.xml but also some in sdf file (D:\Documents and Settings\All Users\Application Data\Microsoft\eHome\EPG\)

It seems it is a database format but we do not found information about about how database table are used.

the question to sum up is : is the source code of an exemple that open, change and save .sdf file ) available somewhere ? It would help me to reproduce the full behaviour

thanks, toto

tombidibuzz · **8th February 2006, 08:49 PM**

in other words, i want to access "media center datase", in order to modify some informations. it seems all informations are stocked in a sdf file just here -> D:\Documents and Settings\All Users\Application Data\Microsoft\eHome\EPG\xxxxxx.sdf

i want to modify this file, and for the moment i just want to open it and take a look!
i use an query tool from Daniels but doesn't work!

Daniels blog
MCE database query :

http://httpcode.com/blogs/posts/663.aspx

i develop a microsoft visual studio application in c#(via pocket pc and sqlce), i success in creating, modifying and saving sdf file but i don't success in openening mce.sdf!

i ve got this error message: file corrupted......repair utility.....

so if someone knows how to open this file and modify it, could you give me some advices! and tell me if i am on the wrong way!

thanks,
toto

dan_p · **10th February 2006, 12:51 PM**

What is the error you get from my Database Query tool? have you made sure that .net security is turned off first? (caspol -security off)

It's been a while since I've used this tool, there could be problems with rollup 2 I guess ...

tombidibuzz · **10th February 2006, 05:42 PM**

hello dan, thanks for reply!
i made sure that .net security is turned off first (caspol -security off) with the right version
of framework

and then your application start and just after i ve got an alert message -> "cannot find table 0" (just see the affach file)

thanks, thomas

tombidibuzz · **10th February 2006, 06:00 PM**

I've got few more questions to ask to you, if i could?

I would like to have more details on the format sdf and mediacenter! is it sqlce or sqlLite?
usualy this type of file is used with sqlce but i'am not sure they use sqlce with media center. I just have a look on QuickGuide sources and it seems to be SqlLite!
they have used Microsoft.Ehome.Epg.Helper and Microsoft.Ehome.Epg.Database; and SqlLite commands.

if you could tell me more, i would be happy.
regards, thomas

dan_p · **10th February 2006, 07:35 PM**

Yeah its SQLLite, it shares the same file extension as the mobile SQL stuff, but thats it.

If I recall correctly those assemblies Microsoft.Ehome.Epg.Helper and Microsoft.Ehome.Epg.Database are the ones to reference.

Also the static property EpgFileHelper.CurrentEpgFile gives you the path to the current epg database.

So the code to open a database connection is:
SqlLiteConnection c = new SqlLiteConnection();
c.Init(EpgFileHelper.CurrentEpgFile, false);
c.Open();

The code to run a query is the same as any .net example you'll find.

The problem you describe 'can't find table 0' means that the sql that got executed didn't return any results, try running some different sql on some other tables (I think I had a list on my blog post)

tombidibuzz · **13th February 2006, 05:42 PM**

thanks a lot!

tombidibuzz · **13th February 2006, 06:05 PM**

nice tool!! it would help me a lot!!
i could do what i want now!

merci beaucoup

regards, thomas

tombidibuzz · **14th February 2006, 03:19 AM**

few more questions...... sorry!

after having ran caspol to disable the .NET security before you run your tool, i succed in opening all tables in ordrer to learn more about mce database! but i've got a last problem!
i don't succed in modifying datas in mce database
i have tried to modify directly in the dataset and use save function, or run sqllite command in the edit control and then "run" but as a result it seems that nothing has happened!

should i do something wrong, or is there someting special to do to modify datas?

in my addins wrote in c# i succed in opening mce datase and saving and the data in an XML document, but when i want to start to modify the datas............. nothing

i don't succed in modifying and inserting or updating......
have you got an idea ?

thanks, thomas