Results 1 to 7 of 7

Thread: MDB not SQL

  1. #1
    Join Date
    Mar 2007
    Location
    Isle of Wight, UK
    Posts
    58

    MDB not SQL

    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?

  2. #2
    Join Date
    Nov 2003
    Location
    NextPVR HQ, Wellington, New Zealand
    Posts
    91,107
    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.O LEDB.4.0;Data Source=".\gbpvr.mdb";User Id=admin;Password=</DatabaseConnectionString>
    <DatabaseProviderFactory>System.Data.OleDb.OleDbFa ctory</DatabaseProviderFactory>
    <DatabaseIdentityQuery>select @@identity</DatabaseIdentityQuery>

  3. #3
    Join Date
    Mar 2007
    Location
    Isle of Wight, UK
    Posts
    58
    Thanks sub

    I'll give it a go.

  4. #4
    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

  5. #5
    Join Date
    Nov 2003
    Location
    NextPVR HQ, Wellington, New Zealand
    Posts
    91,107
    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.

  6. #6
    Thanks

  7. #7
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •