Any one using MSDE or SQL2005Express?

[sub]

Sorry, but I'm still not seeing anything that helps me work out what is wrong. Just from the quick look i've had, those insert statements look fine to me.

[Urbansk]

Sorry, but I'm still not seeing anything that helps me work out what is wrong. Just from the quick look i've had, those insert statements look fine to me.

Yes I agree those statements look fine.

What entries are supposed to exist in the database for the various recording types.
(all episodes this channel)
(all in this weakly timeslot, this channel)
(all in this daily timeslot, this channel)

My guess is this statement:

SELECT rs.oid as rsoid, * FROM RECORDING_SCHEDULE rs left join PROGRAMME p on rs.programme_oid = p.oid order by manual_start_time

But what parameter is the reoccuring?

[sub]

Sorry, but I dont have much time available for this. The best thing you can do is run the same tests with GB-PVR configured to use MS Access or SQLite, then look in the RECORDING_SCHEDULE table for an understanding of what data should be created.

[sub]

I should hopefully have some more time a available in a few days.

[Urbansk]

Sorry, but I dont have much time available for this. The best thing you can do is run the same tests with GB-PVR configured to use MS Access or SQLite, then look in the RECORDING_SCHEDULE table for an understanding of what data should be created.

Figured that one out. in recording_schedule the recording_type are supposed to be 5. The insert statement that are supposed to acomplish this never enter the SQL server, so the error must exist somewhere in the code itself. If the Insert statement that sets the recording_type to 5 never hits the server the problem must be elsevere.

[sub]

I dont have any special case logic for SQLite or MS Access, and those work just fine. I treat all databases the same. The exact same statements should be executed for MSDE. Something must be failing some with one of the database insert/update/select statements with MSDE.

[Urbansk]

I dont have any special case logic for SQLite or MS Access, and those work just fine. I treat all databases the same. The exact same statements should be executed for MSDE. Something must be failing some with one of the database insert/update/select statements with MSDE.

I must say I realy, realy, realy appreciate SUBs time and effort trying to help me.

Using the info in this link i tried to catch the error in a another stage in the process,
http://msdn.microsoft.com/library/defaul...access.asp with no success. I only get the same error message.I was hoping in a result similar to this:
" errorMessage='Syntax error converting the varchar value '172-32-1176' to a
column of data type int.' procedure='' lineNumber=1""




Does any one know if there are any way to trace the SQL queries sent to SQLlite/access and the responses sent from SQLlite/access?

Is there any way to get a better output from GBPVR logs ?

[sub]

Does any one know if there are any way to trace the SQL queries sent to SQLlite/access and the responses sent from SQLlite/access?

Sorry, I'm not sure. You could try asking here: http://sqlite.phxsoftware.com/. These guys are the authors of the SQLite Provider.

Is there any way to get a better output from GBPVR logs ?

There is no way to log the SQL to GB-PVR's logs.

[spyork]

I must say I realy, realy, realy appreciate SUBs time and effort trying to help me.

I haven't been around lately to mess around with this issue, but I would definitely like to thank Sub too for the time he has spent on helping to debug this issue.

Does any one know if there are any way to trace the SQL queries sent to SQLlite/access and the responses sent from SQLlite/access?

Is there any way to get a better output from GBPVR logs ?

I noticed the source code for the ADO.NET provider is available for download. We could put in some logging statements and then recompile. I could look into this next week if you think it's a worth while effort.