How to use MSDE(SQL Server) as GBPVR Database

[Darryl]

The only database related thing that happens next is:

Object returnObject = indentityQuery.ExecuteScalar();
int programOID = (int)System.Decimal.ToInt32(returnObject);

To me this looks correct, but if it isnt, then tell me what it should be. It obviously works fine with access.

The error must be occuring somewhere later in the code.

The error message

ERROR [3] Failure in ChannelFactory:toreChannels(): Specified cast is not valid.

indicates the error is in ChannelFactory:toreChannels() .

Is it possible to release a test version of the file that contains this function with a whole lot of extra debugging statememts scattered through it? It might help track down the problem.

Darryl

[sub]

I can add some more diagnostic messages in the next release. My build has moved on too far to give you an updated version of this file.

[JonRoyle]

Reading through the link I can see that people have tried MySQL. Has anyone got it to reliably work?

I have MySQL 4.1 running on the server (for websites) and wanted to try and use rather than Access. I have managed to upload Access DB to MySQL (using the excellent Migration Toolkit) but I am unable to connect.

.net and odbc connectors are installed for MySQL, and GBpvr config has been changed to
<DatabaseConnectionString>Provider=MySQLProv;Data Source=(local);User Id=gbpvr;Password=password</DatabaseConnectionString>

However I repeatedly get the error "The 'MySQLProv' provider is not registered on the local machine"

Can anyone advise what I am doing wrong?

Thanks

Jon

[sub]

Reading through the link I can see that people have tried MySQL. Has anyone got it to reliably work?

No, it wont work with MySQL. Much of the SQL is incompatible.

[Urbansk]

Hi all!

Trying to use SQL2005 Express with gbpvr.

When trying to update the EPG i get this message:


2006-05-21 19:30:01.357 ERROR [4] 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)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at GBPVR.Backend.Common.ChannelFactory.x091b0bb67b0c21bd(ICollection xb539b3782652833f, Int32 xeba3e20435eb0e32)
2006-05-21 19:30:01.357 ERROR [4] Error UpdateEPG()'ing: 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 GBPVR.Backend.Common.ChannelFactory.x091b0bb67b0c21bd(ICollection xb539b3782652833f, Int32 xeba3e20435eb0e32)
at GBPVR.Backend.Common.xbdfb880686f2538b.x52e8ddd0b9bc8c68(xda34526142ca690b x347261624b519e9a, IEpgUpdateProgressCallback x421ce789b9741187)
at Config.xca74b9c9b310df0b.xcba1f05fb5a46d5f()

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?

[sub]

What data type have you used for the favourite_channel column?

[Urbansk]

Hi!

Here is the DDL for that table:

USE [gbpvr]
GO
/****** Object: Table [dbo].[CHANNEL] Script Date: 05/21/2006 21:25:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CHANNEL](
[oid] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[channelID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[channel_number] [int] NULL,
[favourite] [bit] NOT NULL CONSTRAINT [DF__CHANNEL__favouri__03317E3D] DEFAULT ((0)),
[favourite_channel] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
CONSTRAINT [aaaaaCHANNEL_PK] PRIMARY KEY NONCLUSTERED
(
[oid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

[sub]

You probably need to use nvarchar(1) rather than 'text'.

[Urbansk]

Hi!

Tried it with no success! Still get the same error message.

[sub]

Sorry, I dont know. The only database I've tested are MS Access and SQLite.