Reply to thread

Message

Hello

Here is an okay place for this question.
I think it would be good if you could explain exactly what you're trying to do, because in general it would be better if you could let the TV service handle the database connection and use the TVDatabase.dll and TvBusinessLayer.dll to access the data you need. If you need to use custom queries then it makes sense to have your own connection.

To directly address the problem...
For a start, make sure you have the Gentle.NET provider DLLs in the right place. You need all of the following DLLs:
Gentle.Common.dll
Gentle.Framework.dll
Gentle.Provider.MySQL.dll
Gentle.Provider.SQLServer.dll
MySql.Data.dll

I'm not sure exactly what is going wrong, but since Gentle.NET is open source I would suggest to check the source code to work out why the exception is being thrown. The source code is here:
https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/
https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/Gentle.Framework/Core/ProviderFactory.cs

I hope that helps at least a little.

mm

<blockquote data-quote="mm1352000" data-source="post: 942448" data-attributes="member: 82144">Hello&nbsp;Here is an okay place for this question.I think it would be good if you could explain exactly what you're trying to do, because in general it would be better if you could let the TV service handle the database connection and use the TVDatabase.dll and TvBusinessLayer.dll to access the data you need. If you need to use custom queries then it makes sense to have your own connection.&nbsp;To directly address the problem...For a start, make sure you have the Gentle.NET provider DLLs in the right place. You need all of the following DLLs:Gentle.Common.dllGentle.Framework.dllGentle.Provider.MySQL.dllGentle.Provider.SQLServer.dllMySql.Data.dll&nbsp;I'm not sure exactly what is going wrong, but since Gentle.NET is open source I would suggest to check the source code to work out why the exception is being thrown. The source code is here:<a href="https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/" target="_blank">https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/</a><a href="https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/Gentle.Framework/Core/ProviderFactory.cs" target="_blank">https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/Gentle.Framework/Core/ProviderFactory.cs</a>&nbsp;I hope that helps at least a little.&nbsp;mm</blockquote>

[QUOTE="mm1352000, post: 942448, member: 82144"] Hello Here is an okay place for this question. I think it would be good if you could explain exactly what you're trying to do, because in general it would be better if you could let the TV service handle the database connection and use the TVDatabase.dll and TvBusinessLayer.dll to access the data you need. If you need to use custom queries then it makes sense to have your own connection. To directly address the problem... For a start, make sure you have the Gentle.NET provider DLLs in the right place. You need all of the following DLLs: Gentle.Common.dll Gentle.Framework.dll Gentle.Provider.MySQL.dll Gentle.Provider.SQLServer.dll MySql.Data.dll I'm not sure exactly what is going wrong, but since Gentle.NET is open source I would suggest to check the source code to work out why the exception is being thrown. The source code is here: [url]https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/[/url] [url]https://github.com/MediaPortal/MediaPortal-1/blob/master/Common-MP-TVE3/External/Gentle.NET/Source/Gentle.Framework/Core/ProviderFactory.cs[/url] I hope that helps at least a little. mm [/QUOTE]