Sharing MDB databases

[jmoger]

I've experimented with file-sharing the GBPVR MDB database between a "server" machine with the TV-tuner card and a "client" machine which has no tv-tuner. This does seem to work for the database stuff, anyway (although my "Available" recordings are not listed on the "client" machine - possibly because of drive mappings/file availability?). All recordings are accessible through My Videos which I have pointing to my recordings shared folder.

Are there any database-safety concerns with this approach? I imagine that Access handles all data-locking... but is GBPVR equipped to handle multi-point access to the MDB?

It would probably be a good idea to disable EPG updates on the client machine.

What would happen on the client machine if its running while the server is recording something? Would the client attempt to record even though it does not have a tuner card?

[sub]

Quote[/b] ]Are there any database-safety concerns with this approach? I imagine that Access handles all data-locking... but is GBPVR equipped to handle multi-point access to the MDB?

I'm not really sure. I've not tried it myself. It should be ok. Several processes already access the mdb simultaneous.

Quote[/b] ]It would probably be a good idea to disable EPG updates on the client machine.

Just dont run the recording service on the client machine.

Quote[/b] ]What would happen on the client machine if its running while the server is recording something? Would the client attempt to record even though it does not have a tuner card?

It'll generate an error unless you set the <RecordingServiceLocation> setting in config.xml

[jmoger]

Most things work. Running config restarts the recording service on the client machine - doh!

If I schedule a recording from the client machine, the server will acknowledge the addition in "Pending Recordings", but the server will not start the recording without manually restarting the recording service on the server. I assume that cancel recording might have the same problem.

I've set the <RecordingServiceLocation> to my server but the client systray does not show me a status of the server and will not indicate recording/not-recording.

This error repeats itself in the log and I suspect it is related to the systray not showing a status...

2/14/2005 2:29:38 PM.968 VERBOSE [13] RecordingFactory.loadSchedule()
2/14/2005 2:29:39 PM.031 ERROR [13] Caught unexpected exception: The Microsoft Jet database engine cannot open the file '\\hms\storage (e)\gbpvr.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
2/14/2005 2:29:39 PM.031 ERROR [13] at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at h.e()
at bn.i()
at bw.g()