How to use MSDE(SQL Server) as GBPVR Database

[Urbansk]

Hi!

After digging around i found some information that might bring some light to the issue.

When gbpvr connects it turns Quoted identifiers on. I have tried to set it to off in the database and the server buth it turns on whenever gbpvr connects to the db. Read moore on this link:
http://www.sqlteam.com/item.asp?ItemID=1649

[sub]

GB-PVR doesnt turn it on. It must be some default to have it enabled.

[KingArgyle]

Urbansk, check the options for the SQL Server OLEDB and set them to what you want them to be. I did manage in prior versions of GBPVR to get it working fairly well with SQL Sever, but it takes some tweaking to get it working. I haven't tried it in over a year though.

[matthrolf]

New verison works with MSDE/SQL 2k

[Urbansk]

Hi!

I might have some issues with the DB config. I have done a conversion of the access db with the upsizing tool in access.

When trying to schedule a recording for a whole season i get this in the log.

2006-05-31 19:39:44.973 VERBOSE [1] Looking for capture source to record: Människans sexualitet
2006-05-31 19:39:44.988 VERBOSE [1] Possible capture device: DEVICE:Hauppauge PVR500 with FM tuner:1
2006-05-31 19:39:45.004 VERBOSE [1] Possible capture device: DEVICE:Hauppauge PVR500 with FM tuner:2
2006-05-31 19:39:45.004 VERBOSE [1] Checking 'PVR Tuner ONE' (DEVICE:Hauppauge PVR500 with FM tuner:1)
2006-05-31 19:39:45.004 VERBOSE [1] Checking 'PVR Tuner TWO' (DEVICE:Hauppauge PVR500 with FM tuner:2)
2006-05-31 19:39:45.051 VERBOSE [1] RecordingFactory.save()
2006-05-31 19:39:45.191 ERROR [1] Unabled to save ScheduledRecording: Invalid character value for cast specification.
2006-05-31 19:39:45.301 ERROR [1] at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.x396614b3dae3b1da.xc979432fcc5a510a(ScheduledRecording xe41d2b9d98dc1269)
2006-05-31 19:39:45.316 VERBOSE [1] RecordingFactor.ScheduleSeasonRecordings(8, Människans sexualitet)
2006-05-31 19:39:45.316 VERBOSE [1] getValue() loading new key/value into cache: /settings/AvoidDuplicateRecordingsIfPossible
2006-05-31 19:39:45.316 VERBOSE [1] getValue: /settings/AvoidDuplicateRecordingsIfPossible : false
2006-05-31 19:39:45.410 VERBOSE [1] RecordingFactory.getExtrasForGroup(16)
2006-05-31 19:39:45.441 VERBOSE [1] Requesting recording service schedule reload
2006-05-31 19:39:45.535 VERBOSE [1] RecordingFactory.save()
2006-05-31 19:39:45.598 VERBOSE [1] Save(): Updated existing reoccuring extras record
2006-05-31 19:39:51.441 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:39:51.488 VERBOSE [1] controller.OnClick()
2006-05-31 19:39:51.566 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:39:51.691 VERBOSE [1] Initializing skin helper for: .\skin\Blue\recordings\skin.xml
2006-05-31 19:39:51.723 VERBOSE [1] getValue cached value: /settings/PreShowPadding : 1
2006-05-31 19:39:51.723 VERBOSE [1] getValue cached value: /settings/PostShowPadding : 2
2006-05-31 19:39:52.941 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:39:53.066 VERBOSE [1] controller.OnClick()
2006-05-31 19:39:54.488 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:39:54.582 VERBOSE [1] controller.OnClick()
2006-05-31 19:39:54.582 VERBOSE [1] Looking for capture source to record: Människans sexualitet
2006-05-31 19:39:54.582 VERBOSE [1] Possible capture device: DEVICE:Hauppauge PVR500 with FM tuner:1
2006-05-31 19:39:54.582 VERBOSE [1] Possible capture device: DEVICE:Hauppauge PVR500 with FM tuner:2
2006-05-31 19:39:54.582 VERBOSE [1] Checking 'PVR Tuner ONE' (DEVICE:Hauppauge PVR500 with FM tuner:1)
2006-05-31 19:39:54.582 VERBOSE [1] Checking 'PVR Tuner TWO' (DEVICE:Hauppauge PVR500 with FM tuner:2)
2006-05-31 19:39:54.582 VERBOSE [1] RecordingFactory.save()
2006-05-31 19:39:54.598 ERROR [1] Unabled to save ScheduledRecording: Invalid character value for cast specification.
2006-05-31 19:39:54.598 ERROR [1] at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.x396614b3dae3b1da.xc979432fcc5a510a(ScheduledRecording xe41d2b9d98dc1269)
2006-05-31 19:39:54.598 VERBOSE [1] RecordingFactor.ScheduleSeasonRecordings(8, Människans sexualitet)
2006-05-31 19:39:54.598 VERBOSE [1] getValue cached value: /settings/AvoidDuplicateRecordingsIfPossible : false
2006-05-31 19:39:54.598 VERBOSE [1] RecordingFactory.getExtrasForGroup(16)
2006-05-31 19:39:54.613 VERBOSE [1] Requesting recording service schedule reload
2006-05-31 19:39:54.613 VERBOSE [1] RecordingFactory.save()
2006-05-31 19:39:54.613 VERBOSE [1] Save(): Updated existing reoccuring extras record
2006-05-31 19:39:58.082 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:39:58.176 VERBOSE [1] controller.OnClick()
2006-05-31 19:39:58.191 VERBOSE [1] loadRecordings():1
2006-05-31 19:39:58.191 VERBOSE [1] RecordingFactory.loadSchedule()
2006-05-31 19:39:58.191 VERBOSE [1] getValue cached value: /settings/AutoRemoveMissingRecordings : false
2006-05-31 19:39:58.207 VERBOSE [1] loadRecordings():2
2006-05-31 19:39:58.207 VERBOSE [1] loadRecordings():3
2006-05-31 19:39:58.207 VERBOSE [1] loadRecordings():4
2006-05-31 19:39:58.207 VERBOSE [1] loadRecordings():5
2006-05-31 19:39:58.207 VERBOSE [1] loadRecordings():6
2006-05-31 19:39:58.207 VERBOSE [1] loadRecordings():7
2006-05-31 19:39:59.613 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:39:59.723 VERBOSE [1] controller.OnClick()
2006-05-31 19:39:59.738 VERBOSE [1] loadRecordings():1
2006-05-31 19:39:59.738 VERBOSE [1] RecordingFactory.loadSchedule()
2006-05-31 19:39:59.738 VERBOSE [1] getValue cached value: /settings/AutoRemoveMissingRecordings : false
2006-05-31 19:39:59.738 VERBOSE [1] loadRecordings():2
2006-05-31 19:39:59.754 VERBOSE [1] loadRecordings():3
2006-05-31 19:39:59.754 VERBOSE [1] loadRecordings():4
2006-05-31 19:39:59.754 VERBOSE [1] loadRecordings():5
2006-05-31 19:39:59.754 VERBOSE [1] loadRecordings():6
2006-05-31 19:39:59.754 VERBOSE [1] loadRecordings():7
2006-05-31 19:40:06.301 VERBOSE [1] HideMouse ref=-1
2006-05-31 19:40:10.613 VERBOSE [1] ShowMouse ref=0
2006-05-31 19:40:13.035 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:40:13.113 VERBOSE [1] controller.OnClick()
2006-05-31 19:40:14.738 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:40:14.879 VERBOSE [1] controller.OnClick()
2006-05-31 19:40:19.285 VERBOSE [1] HideMouse ref=-1
2006-05-31 19:40:19.598 VERBOSE [1] controller.OnMouseDown()
2006-05-31 19:40:19.691 VERBOSE [1] controller.OnClick()
2006-05-31 19:40:19.707 VERBOSE [1] getValue() loading new key/value into cache: /settings/NetRadioBufferSize
2006-05-31 19:40:19.707 VERBOSE [1] getValue: /settings/NetRadioBufferSize : 96000
.

Any hints or perhaps you could provide a DDL script for the db?

Regards,

Urban

[matthrolf]

Which version are you running (both gbvr and msde)?

[Urbansk]

Gbpvr 0.97.7
SQL Server 2005 Express Edition SP1

[matthrolf]

I don't know how to do this in SQL 2005 express, but try to change the database compatibiliy to 80 (back to 2k sql commands and datatypes). I know this is possible in the full versions of SQL 2k5. Other than that it looks like a data type problem in the recording_schedule table. Try to upload a screenshot of the design of that table if the compatibility does not help.

Matt

[Urbansk]

Tried changing to 80 with no succes.
However, the following schedule type works:
Record Season (all in this weekly timeslot, this channel)
Record Season (all in this daily timeslot, this channel)

But not:
Record Season (all episodes on this channel)

I get this error message in gbpvr.exe.log:

2006-06-03 13:27:15.912 ERROR [1] Unabled to save ScheduledRecording: Invalid character value for cast specification.
2006-06-03 13:27:16.006 ERROR [1] at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.x396614b3dae3b1da.xc979432fcc5a510a(ScheduledRecording xe41d2b9d98dc1269)

Using SQLiteSpy.exe i have checked the datatypes to match my settings.

I am fresh out of ideas. perhaps it has to do with date handling as i live in Sweden and we have a different way of presenting dates and times.

I do not know what the difference is in the various recording season and date handling.

[Spartan]

I just wanted to chime in and say that I got SQL Server 2005 (developer ed) working smoothly with GBPVR with little trouble at all. I used the Access upsizing wizard to create the database, set the connection string in the config.xml and was off to the races.

Once I enabled TCP/IP connectivity to the database I was able to get my GBPVR client running as well (from another machine).