Live GBPVR CD/DVD/Thumb drive :D

[pBS]

hmm,so do you just use ado to query using regular sql? i figured it would be the sqlite3.dll or something...is it relying on sqlite or windows for the temp stuff?
[tho it says that sqlite gets the temp from windows's docs n setts\user\local settings\temp] which doesn't seem to be working..]
i can compile a special sqlite.dll and change temp in there and include it if using that to access db..

if using ADO for db access and to select the temp dir, then i'll have to look into why it's not doing it right..

thanx for the help...so close...

[sub]

hmmm,is there any way to set a pragma command for the database on opening?
seems the pragma command to store temps has to be used before each open of the database...so if i do it outside of gbpvr it doesn't effect gbpvr accesses...

it may be able to be changed within the database structure itself...
it says by default it's supposed to write the files to the userprofile's temp dir and i have that setup but it doesn't seem to be using it..
i'll try changing the actual database schema so see if i can't put them in current dir for all accesses...which shouldn't be a problem even for the other users of the db...
[all locks and journals and temps should be in same place for that db]

i think it's actually just the indices creation that is creating he problem...
Recordings comes up fine...all files/info are there and playable...

To be honest, I dont know anything about these low-level aspects of SQLite. I've not had to know about any of this for GB-PVR's use of SQLite.

[sub]

hmm,so do you just use ado to query using regular sql?

Yes, via the SQLite provider from http://sqlite.phxsoftware.com/

[pBS]

ahhh,figured it was some other layer....that's where the answer is then...
cuz any db worth it's salt is gonna have configurable temp space...
but ya gotta know who's in charge..
thanx that should do the trick...it's in their code that i'll find the temp stuff...

tho it usually is on a per-transaction basis, i may be able to set it via some variable or something globally...

obviously they aren't using same method as sqlite3.exe or dll...
[which defaults to the user's temp first and keeps looking thru others till it finds one it's sure is writable..]
never had a problem using the sqlite3.exe from cdrom, even writing..

otherwise the whole idea's hosed if it can't be changed from the systemroot without recoding gbpvr..[but i know it can if pragma set before transactions, but that might be messy to do before every transaction..]

oh and tvlistings works fine, but for some reason won't let me watch a show..lol how are they accessing the db successfully? and how is the recordings screen coming up if db access is't working?
i figured the guide would be the only thing working cuz i'd just be reading it..
must be indexes...

can i specify a different db provider?
nm, will see if i can't set the temp thing globally first..

[sub]

can i specify a different db provider?

Yes, the ADO connection strings etc are specified in the config.xml.

[pBS]

Never-Mind...geez i must be losin it... it was just too small a temp/ram drive...
everything works now...even without ado support...as the dll you use is both ado factory provider and the sql exec, so nothing else needed..

seems i need about twice the size of the database for temp space...it's probably using expanded data in the temp files, making them much larger when temp..

so silly me, it really was just actually 'out of space' lol

next i'll be checking if i can run it all from dvd itself, or a network load...

thanx for the help and sorry,next time i'll wait till my head bleeds the answer...lol

what format are the you-toob videos?
i have ffdshow installed, but may need other codecs in the list activated by default...

also, on a side note, i have ati mpeg decoder working great as "ATI MPEG Video Decoder" and performs ok, deinterlacing is perfect...

[pBS]

hmmm, everything's working great....but no osd and the graph has 2 renderers...? and no skip/pause/etc. ability...
i register the filters before starting gbpvr...and even tried unregistering the ms mpeg splitter also...no go..
the graph shows your filters, but apparently it's connecting video to one renderer, and your filters to another...!
of course i only see the one with video on it so i can't get to the other one..
only esc works to exit...[and up/dn to change channels]

any thoughts?

video looks great....btw...and pretty zippy chann. changes...

[sub]

what format are the you-toob videos?
i have ffdshow installed, but may need other codecs in the list activated by default...

They downloaded as a .flv file, but converted to .mpg before playback.

hmmm, everything's working great....but no osd and the graph has 2 renderers...? and no skip/pause/etc. ability...

Zip and attach the logs and I'll take a look. A common cause of this is using the Cyberlink decoder with VMR, without adding the Cyberlink EnableVMR9=1 registry setting.

[pBS]

you toob is working....and the keys in video playback *are* working, just not the osd...maybe a transparency issue or cleartype possibly? i'll check to make sure transparency is't totally turned off or something...dx9 seems to be working fine..

other than that i'm running out of things to check...lol

on a side note wow-factor...
i found out how to make the cdrom itself writable!
actually it's just a filecache but it works and makes X: drive[the cdrom] writable for temp stuff...lol
so i could actually run gbpvr from cdrom no problem...takes about 10% of ram and adds free space to the cdrom...

notice in the pic...:eek: muhahaha

[K.S.]

i found out how to make the cdrom itself writable!
actually it's just a filecache but it works and makes X: drive[the cdrom] writable for temp stuff...lol

wow, how did you do that?