Reply to thread

Message

<blockquote data-quote="porky996t" data-source="post: 914138" data-attributes="member: 75318">Hi mm,&nbsp;Thanks for the input.&nbsp;None of the laptops or MP machines have 64 bit version on them. All running Win 7 x86&nbsp;I have disabled both firewalls - no change. The client is still not connecting to the database.&nbsp;&nbsp;gentle.config files will not attach, due to file extension type. So this is a copy of the text from client machine:-&nbsp;[spoiler][/spoiler]&nbsp;This is the same from the Server machine...&nbsp;EDIT: This is actually from the MP Client that sits on the TV Server machine, it is not the gentle.config detail from the TV Server itself, that file detail is a couple of posts further on. Thanks to HomeY for pointing this out.&nbsp;&nbsp;[spoiler]&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt; &lt;Gentle.Framework&gt; &lt;!-- See the API documentation for the Gentle.Framework.GentleSettings class for detailed information on the keys available in the Options section --&gt; &lt;Options&gt; &lt;!-- the default timeout value in seconds for IDbCommand instances created by Gentle --&gt; &lt;CommandTimeout&gt;30&lt;/CommandTimeout&gt; &lt;!-- whether to enable support for Gentle-managed concurrency control columns --&gt; &lt;ConcurrencyControl&gt;false&lt;/ConcurrencyControl&gt; &lt;!-- options: Attributes or XML (XML currently unused) --&gt; &lt;MasterDefinition&gt;Attributes&lt;/MasterDefinition&gt; &lt;Analyzer&gt; &lt;!-- options: None, OnDemand (the default), Full --&gt; &lt;Level&gt;OnDemand&lt;/Level&gt; &lt;!-- whether to warn about unmapped columns and other non-fatal errors --&gt; &lt;Silent&gt;false&lt;/Silent&gt; &lt;/Analyzer&gt; &lt;Cache&gt; &lt;!-- default cache strategy (use only Never or Temporary) --&gt; &lt;DefaultStrategy&gt;Temporary&lt;/DefaultStrategy&gt; &lt;CacheStatements&gt;true&lt;/CacheStatements&gt; &lt;CacheObjects&gt;true&lt;/CacheObjects&gt; &lt;!-- when true Gentle will try to bypass query execution and compose the result from cached data alone --&gt; &lt;SkipQueryExecution&gt;true&lt;/SkipQueryExecution&gt; &lt;!-- the scope within which to ensure uniqing options: Thread (default), Application or WebSession --&gt; &lt;UniqingScope&gt;Application&lt;/UniqingScope&gt; &lt;/Cache&gt; &lt;Logging&gt; &lt;!-- This setting controls the lowest log level emitted. See the Verbosity enum for details on the available values. --&gt; &lt;Verbosity&gt;Warning&lt;/Verbosity&gt; &lt;!-- Do not edit this unless you know what you're doing. This setting controls at what level error conditions are considered fatal. --&gt; &lt;Frailty&gt;Warning&lt;/Frailty&gt; &lt;!-- Use values defined in the LogCategories enum to turn logging on/off for selected categories. The available values include: All (all categories) StatementExecutionRead (select statements) StatementExecutionWrite (insert/update/delete statements) StatementExecutionOther (any other kind of statement) StatementExecution (any kind of statement; same as all three groups above) Cache (cache accesses) Metadata (metadata updates) General (everything else) --&gt; &lt;!-- The following sample first disables all categories, then selectively turns on various subcategories --&gt; &lt;Category name=&quot;All&quot; enabled=&quot;false&quot; /&gt; &lt;Category name=&quot;StatementExecution&quot; enabled=&quot;false&quot; /&gt; &lt;Category name=&quot;Cache&quot; enabled=&quot;false&quot; /&gt; &lt;Category name=&quot;Metadata&quot; enabled=&quot;false&quot; /&gt; &lt;/Logging&gt; &lt;/Options&gt; &lt;!-- &lt;NamespaceProviders&gt; &lt;Namespace namespace=&quot;Gentle.First&quot; provider=&quot;SQLServer&quot; connectionstring=&quot;...&quot; /&gt; &lt;Namespace namespace=&quot;Gentle.Second&quot; provider=&quot;SQLServer&quot; connectionString=&quot;...&quot; /&gt; &lt;/NamespaceProviders&gt; --&gt; &lt;DefaultProvider name=&quot;MySQL&quot; connectionString=&quot;Server=TVPC;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;&quot; /&gt; &lt;!-- &lt;DefaultProvider name=&quot;Firebird&quot; connectionString=&quot;User=SYSDBA;Password=masterkey;Data Source=TvLibrary.fdb;ServerType=1;Charset=UNICODE_FSS;&quot; /&gt; &lt;DefaultProvider name=&quot;Jet&quot; connectionString=&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Code\Gentle.NET\Source\Gentle.Framework.Tests\Database Files\Gentle_MSAccess.mdb;OLE DB Services=-1;&quot; /&gt; &lt;DefaultProvider name=&quot;MySQL&quot; connectionString=&quot;Server=10.0.0.2;Database=test;User ID=xxx;Password=xxx&quot; /&gt; &lt;DefaultProvider name=&quot;PostgreSQL&quot; connectionString=&quot;Server=10.0.0.2;Database=Test;User ID=xxx;Password=xxx&quot; /&gt; &lt;DefaultProvider name=&quot;Oracle&quot; connectionString=&quot;Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx&quot; /&gt; &lt;DefaultProvider name=&quot;OracleODP&quot; connectionString=&quot;Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx&quot; /&gt; &lt;DefaultProvider name=&quot;SQLite&quot; connectionString=&quot;URI=file:c:/Code/Gentle.NET/Source/Gentle.Framework.Tests/Database Files/Gentle_SQLite.db&quot; /&gt; &lt;DefaultProvider name=&quot;SQLServer&quot; connectionString=&quot;data source=127.0.0.1;initial catalog=Test;user id=xxx;password=xxx;packet size=4096&quot; /&gt; --&gt; &lt;!-- IMPORTANT: You must uncomment ONLY the providers that you will be using. If a provider is defined below, but Gentle cannot find or load the associated library, an exception will most likely be raised! --&gt; &lt;Providers&gt; &lt;!-- list known provider assemblies; the assembly .dll suffix is optional --&gt; &lt;!-- Provider name=&quot;CE&quot; assembly=&quot;Gentle.Provider.CE&quot; /--&gt; &lt;!-- Provider name=&quot;Firebird&quot; assembly=&quot;Gentle.Provider.Firebird&quot; /--&gt; &lt;!-- Provider name=&quot;Jet&quot; assembly=&quot;Gentle.Provider.Jet&quot; /--&gt; &lt;Provider name=&quot;MySQL&quot; assembly=&quot;Gentle.Provider.MySQL.dll&quot; /&gt; &lt;!-- Provider name=&quot;Oracle&quot; assembly=&quot;Gentle.Provider.Oracle&quot; /--&gt; &lt;!-- Provider name=&quot;OracleODP&quot; assembly=&quot;Gentle.Provider.OracleODP&quot; /--&gt; &lt;!-- Provider name=&quot;PostgreSQL&quot; assembly=&quot;Gentle.Provider.PostgreSQL&quot; /--&gt; &lt;!-- Provider name=&quot;SQLite&quot; assembly=&quot;Gentle.Provider.SQLite&quot; / --&gt; &lt;Provider name=&quot;SQLServer&quot; assembly=&quot;Gentle.Provider.SQLServer&quot; /&gt; &lt;!-- Provider name=&quot;Sybase&quot; assembly=&quot;Gentle.Provider.Sybase&quot; / --&gt; &lt;!-- Provider name=&quot;SybaseASA&quot; assembly=&quot;Gentle.Provider.SybaseASA&quot; / --&gt; &lt;/Providers&gt; &lt;/Gentle.Framework&gt;[/spoiler]&nbsp;I'll install the workbench and see if I can connect that way..&nbsp;Thanks for assistance so far.</blockquote>

[QUOTE="porky996t, post: 914138, member: 75318"] Hi mm, Thanks for the input. None of the laptops or MP machines have 64 bit version on them. All running Win 7 x86 I have disabled both firewalls - no change. The client is still not connecting to the database. gentle.config files will not attach, due to file extension type. So this is a copy of the text from client machine:- [spoiler][/spoiler] This is the same from the Server machine... EDIT: This is actually from the MP Client that sits on the TV Server machine, it is not the gentle.config detail from the TV Server itself, that file detail is a couple of posts further on. Thanks to HomeY for pointing this out. [spoiler][I]<?xml version="1.0" encoding="utf-8"?>[/I] [I]<Gentle.Framework>[/I] [I] [/I] [I] <Options>[/I] [I] [/I] [I] <CommandTimeout>30</CommandTimeout>[/I] [I] [/I] [I] <ConcurrencyControl>false</ConcurrencyControl>[/I] [I] [/I] [I] <MasterDefinition>Attributes</MasterDefinition>[/I] [I] <Analyzer>[/I] [I] [/I] [I] <Level>OnDemand</Level>[/I] [I] [/I] [I] <Silent>false</Silent>[/I] [I] </Analyzer>[/I] [I] <Cache>[/I] [I] [/I] [I] <DefaultStrategy>Temporary</DefaultStrategy>[/I] [I] <CacheStatements>true</CacheStatements>[/I] [I] <CacheObjects>true</CacheObjects>[/I] [I] [/I] [I] <SkipQueryExecution>true</SkipQueryExecution>[/I] [I] [/I] [I] <UniqingScope>Application</UniqingScope>[/I] [I] </Cache>[/I] [I] <Logging>[/I] [I] [/I] [I] <Verbosity>Warning</Verbosity>[/I] [I] [/I] [I] <Frailty>Warning</Frailty>[/I] [I] [/I] [I] [/I] [I] <Category name="All" enabled="false" />[/I] [I] <Category name="StatementExecution" enabled="false" />[/I] [I] <Category name="Cache" enabled="false" />[/I] [I] <Category name="Metadata" enabled="false" />[/I] [I] </Logging>[/I] [I] </Options>[/I] [I] [/I] [I] <DefaultProvider name="MySQL" connectionString="Server=TVPC;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;" />[/I] [I] [/I] [I] [/I] [I] <Providers>[/I] [I] [/I] [I] [/I] [I] [/I] [I] [/I] [I] <Provider name="MySQL" assembly="Gentle.Provider.MySQL.dll" />[/I] [I] [/I] [I] [/I] [I] [/I] [I] [/I] [I] <Provider name="SQLServer" assembly="Gentle.Provider.SQLServer" />[/I] [I] [/I] [I] [/I] [I] </Providers>[/I] [I]</Gentle.Framework>[/I][/spoiler] I'll install the workbench and see if I can connect that way.. Thanks for assistance so far. [/QUOTE]

Verification