Access linked server from linked server directly
<p>I have two SQL Server instances:</p>

<ul>
<li>SQLSERVER64 </li>
<li>SQLSERVER32</li>
</ul>

<p>In <code>SQLSERVER32</code>, I have a linked server to a Paradox database called <code>ParadoxDBLinkedServer</code>.</p>

<p>To access some of the Paradox tables in the server I just execute the following statement:</p>

<pre><code>SELECT * 
FROM [ParadoxDBLinkedServer]...Clients
</code></pre>

<p>Then, I need to access to these objects from the <code>SQLSERVER64</code> instance. In order to do so, I created a linked server called [<code>.\SQLSERVER32</code>] in this instance pointing to <code>SQLSERVER32</code>.</p>

<p>What I'm trying to do now is to access directly the <code>ParadoxDBLinkedServer</code> objects from the <code>SQLSERVER64</code> instance. I mean, accessing a linked server from another linked server.</p>

<p>The query I´m trying to run is the following one:</p>

<pre><code>SELECT * 
FROM [.\SQLSERVER32].[ParadoxDBLinkedServer ]...Clients
</code></pre>

<p>But I get this error:</p>

<blockquote>
  <p>The number name '.\SQLSERVER32.ParadoxDBLinkedServer ...Clients' contains more than the maximum number of prefixes. The maximum is 3.</p>
</blockquote>

<p>Is there any way to perform an access like this? What am I missing here?</p>

<p>I'm trying to avoid creating a View for each table of the <code>ParadoxDBLinkedServer</code> in the <code>SQLSERVER32</code> instance to reduce overhead.</p>