MDB not SQL

[Amused]

Sub
Is there still support for MDB within GBPVR? I'm trying to link Digiguide to GBPVR using a plugin (for digiguide) called DABDig by Paul Webster.

Digiguide is a prog I've used for years now and I find it 100x easier to use that the build in EPG (or any EPG that ties to video capture software for that mater). The interface seems to clunky, searching for programmes is awkward when compare to Digiguide.
Basically I want Digiguide to setup a marker to record all the weekly recording series, the one offs, any Film directed by Kubrick, anything I want and then have it call GBPVR just before the show is set to start and record it for me. DABDig does exactly that. Only trouble is that to work the plugin accesses GBPVR channel information stored in a MDB file, not SQL, so is there anyway I can configure GBPVR to use MDB instead?

[sub]

Sub
Is there still support for MDB within GBPVR?

The MDB database should still work, but I havnt personally tested it in a few releases myself. The default install these days is SQLite.

If you have the following settings in config.xml then it'll try to try to use the MDB database:

<DatabaseConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".\gbpvr.mdb";User Id=admin;Password=</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.OleDb.OleDbFactory</DatabaseProviderFactory>
<DatabaseIdentityQuery>select @@identity</DatabaseIdentityQuery>

[Amused]

Thanks sub

I'll give it a go.

[Paul Webster]

My recollection, from when I first made DABDig stuff entries into the GBPVR.mdb, is that GBPVR periodically (approx every 10 minutes) polled the database.
It looks like it does not do it any more - perhaps something lost in the switch to SQLLite or perhaps removed for efficiency purposes. (Note I am still using MDB)

Problem for me is that my code is written in VBScript and I don't think that I can reaily call a GBPVR API function to force a reload.
Perhaps forcing an EPGReload from the command line would do it but that might be an overkill.

Doing a stop/start of the scheduler works - but 2 problems:
- recordings in progress when the scheduler restarts might be interrupted
- cannot readily stop/start services on Vista unless being run as Admin

[sub]

I've added a command line call you can use in the next GB-PVR release to force a database reload:

Code:

gbpvr.exe -reloadrecordings

Call this and the recording service will reload its recording list.

[Paul Webster]

Thanks

[Paul Webster]

Update to a very old thread ... but I thought I'd let future searchers know that I have recently added support for NextPVR via the included command-line scheduler (Schedule.exe). It is in version 2.60 - if that is not on my site yet (still testing) and you need it then let me know and I'll send you a beta.