Reply to thread

Message

<blockquote data-quote="huha" data-source="post: 790632" data-attributes="member: 63847">elliottmc,as i see that you are in the test group i am asking you for help to get in contact with an experienced programmer who understands the Tvserver database in detail.I have reused a very nice and simple code piece from the Ipimp source code to make the connection to the Tvserver database as listed below. i suspect that this is conflicting with the Tv plugin in Mediaportal for a multiseat configuration. I am also not closing the connection after leaving the plugin (I do not know how). Is there a better way to do this? I need a connection to the Tvserver database to use the TvBusinessLayer layer = new TvBusinessLayer();&nbsp;Setting setting;in my plugin. Any help here would be very much appreciated. I do not know any other MP plugin, which is using the Tvserver database. If someone knows a source code here, please post.Update: I believe i found the bug. I did open the connection although it was open already. I changed the following lineSource Code:using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Collections.Generic;using TvDatabase;using Gentle.Framework;using TvControl;using MediaPortal.GUI.Library;namespace TvWishList{&nbsp;&nbsp; &nbsp; &nbsp; public class ServiceInterface : System.Web.Services.WebService&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; private static bool isDBConnected = false;&nbsp; &nbsp; &nbsp; &nbsp; public string gentleConfig;&nbsp; &nbsp; &nbsp; &nbsp; public string connStr;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public bool ConnectToDatabase()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //if (isDBConnected)&nbsp;&nbsp; bug!!!&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (RemoteControl.IsConnected)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string provider = &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RemoteControl.HostName = Environment.MachineName; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RemoteControl.Instance.GetDatabaseConnectionString(out connStr, out provider);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Gentle.Framework.ProviderFactory.SetDefaultProviderConnectionString(connStr);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; catch (Exception)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; isDBConnected = true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}</blockquote>

[QUOTE="huha, post: 790632, member: 63847"] elliottmc, as i see that you are in the test group i am asking you for help to get in contact with an experienced programmer who understands the Tvserver database in detail. I have reused a very nice and simple code piece from the Ipimp source code to make the connection to the Tvserver database as listed below. i suspect that this is conflicting with the Tv plugin in Mediaportal for a multiseat configuration. I am also not closing the connection after leaving the plugin (I do not know how). Is there a better way to do this? I need a connection to the Tvserver database to use the TvBusinessLayer layer = new TvBusinessLayer(); Setting setting; in my plugin. Any help here would be very much appreciated. I do not know any other MP plugin, which is using the Tvserver database. If someone knows a source code here, please post. [COLOR="Red"]Update: I believe i found the bug. I did open the connection although it was open already. I changed the following line [/COLOR] Source Code: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Collections.Generic; using TvDatabase; using Gentle.Framework; using TvControl; using MediaPortal.GUI.Library; namespace TvWishList { public class ServiceInterface : System.Web.Services.WebService { private static bool isDBConnected = false; public string gentleConfig; public string connStr; public bool ConnectToDatabase() { //if (isDBConnected) bug!!! [COLOR="Red"] if (RemoteControl.IsConnected)[/COLOR] return true; string provider = ""; RemoteControl.HostName = Environment.MachineName; try { RemoteControl.Instance.GetDatabaseConnectionString(out connStr, out provider); Gentle.Framework.ProviderFactory.SetDefaultProviderConnectionString(connStr); } catch (Exception) { return false; } isDBConnected = true; return true; } } } [/QUOTE]

Verification