Any one using MSDE or SQL2005Express?

[Urbansk]

Hi all!

Trying to use SQL2005 Express with gbpvr.

When trying to update the EPG i get this message:

Failure in ChannelFactory:toreChannels(): System.Data.OleDb.OleDbException: The name "Y" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

From SQL Server Profiler i get this:

exec sp_executesql N'insert into CHANNEL (name, channel_number, favourite_channel) values (@P1,@P2,"Y")',N'@P1 nvarchar(13),@P2 int',N'Animal Planet',102

Any suggestions?

[ZaDDaZ]

At first glance, the "Y" in the values is the problem. Those should be single quotes. Not sure there is much you can do about it...

[sub]

the "Y" in the values is the problem. Those should be single quotes

Thats just the way the SQL Server Profiler is showing it. It has a single quote in my code.

[Urbansk]

Using the Config app to manually import EPG creates the error. Using the scheduled EPG import in recording service works.
I am also having trouble with Scheduled recordings.

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.ExecuteReaderIntern al(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.x396614b3dae3b1da.xc979432fcc 5a510a(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.

[sub]

What is the SQL statement that is failing?

[Urbansk]

exec sp_executesql N'insert into RECORDING_SCHEDULE (programme_oid, capture_source_oid, filename, status, recording_group, recording_type, manual_channel_oid, manual_start_time, manual_end_time, quality_level,
pre_pad_minutes, post_pad_minutes) values (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12)',N'@P1 int,@P2 int,@P3 nvarchar(10),@P4 int,@P5 int,@P6 int,@P7 int,@P8 datetime,@P9 datetime,@P10 int,@P11 int,@P12
int',143308,1,N'Kära Susan',0,32,0,12,''2006-06-05 14:30:00:000'',''2006-06-05 15:00:00:000'',1,1,2

[Urbansk]

This is from gbpvr.exe.log:
2006-06-05 07:09:17.012 VERBOSE [1] RecordingFactory.save()
2006-06-05 07:09:17.278 ERROR [1] Unabled to save ScheduledRecording: Invalid character value for cast specification.
2006-06-05 07:09:17.496 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-06-05 07:09:17.528 VERBOSE [1] RecordingFactor.ScheduleSeasonRecordings(12, Kära Susan)

[sub]

Sorry, I cant see anything obvious.

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

It shouldnt be related to the format of the dates. This is taken care of by the ADO.NET provider.

[spyork]

Urbansk, have you had any luck with this problem. I'm now receiving the same error. Any luck this will be sorted out in the next release?

[Urbansk]

I think i have found some more info.

By using profiler have have fetched all querys to the database and then run them in Query analyzer. When i run this query i get the error:

Error converting data type varchar to datetime

The query:

exec sp_executesql N'insert into RECORDING_SCHEDULE (programme_oid, capture_source_oid, filename, status, recording_group, recording_type, manual_channel_oid,
manual_start_time, manual_end_time, quality_level, pre_pad_minutes, post_pad_minutes) values (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12)',N'@P1 int,@P2 int,@P3
nvarchar(19),@P4 int,@P5 int,@P6 int,@P7 int,@P8 datetime,@P9 datetime,@P10 int,@P11 int,@P12 int',177748,2,N'Lilla röda traktorn',4,40,5,16,''2006-06-21
17:00:00:000'',''2006-06-21 20:00:00:000'',1,1,2



If i remove all time entrys and leave the dates it works.