Linking to SQL server - Mailing list pgsql-interfaces

<div class="Section1"><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">HelloList,</span></font><font color="black"><span
style="color:black;mso-color-alt:windowtext"></span></font><pclass="MsoNormal"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;color:black"> </span></font><font color="black"><span
style="color:black;mso-color-alt:windowtext"></span></font><pclass="MsoNormal"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;color:black">I don’t know if such a thing exists, and I have been looking
inthe archives and haven’t found what I’m looking for.<span style="mso-spacerun: yes">  </span>Here’s my question:
</span></font><fontcolor="black"><span style="color:black;mso-color-alt:windowtext"></span></font><p
class="MsoNormal"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black"> </span></font><fontcolor="black"><span
style="color:black;mso-color-alt:windowtext"></span></font><pclass="MsoNormal"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;mso-bidi-font-size:10.0pt;color:black">I am trying to find a way to link a
tablein a remote SQL Server database to</span></font><font color="black"><span
style="mso-bidi-font-size:10.0pt;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt; 
mso-bidi-font-size:10.0pt;color:black">my pgsql database.<span style="mso-spacerun: yes">  </span>Is there a way to do
thiswithout a middleman such as</span></font><font color="black"><span style="mso-bidi-font-size: 
10.0pt;color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
mso-bidi-font-size:10.0pt;color:black">Access?<span style="mso-spacerun:
yes">  </span>I am able to link the tables from both databases in access, but I</span></font><font color="black"><span
style="mso-bidi-font-size:10.0pt;
color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
mso-bidi-font-size:10.0pt;color:black">want to be able to control it all from the Linux machine.<span
style="mso-spacerun:yes">  </span>Any suggestions</span></font><font color="black"><span
style="mso-bidi-font-size:10.0pt;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><font
color="black"face="Times New Roman" size="3"><span style="font-size:12.0pt; 
mso-bidi-font-size:10.0pt;color:black">on how to accomplish this?<span style="mso-spacerun: yes">  </span>I am pretty
surethere are ways because I have</span></font><font color="black"><span style="mso-bidi-font-size:10.0pt; 
color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
mso-bidi-font-size:10.0pt;color:black">seen some different threads on message boards, but no good
instructions.</span></font><fontcolor="black"><span
style="mso-bidi-font-size:10.0pt;color:black;mso-color-alt:windowtext"></span></font><pclass="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
mso-bidi-font-size:10.0pt;color:black">Basically, I will be happy if I can treat one of the tables on SQL server
as</span></font><fontcolor="black"><span
style="mso-bidi-font-size:10.0pt;color:black;mso-color-alt:windowtext"></span></font><pclass="MsoNormal"
style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;
mso-bidi-font-size:10.0pt;color:black">if it were in my PostgreSQL database.<span style="mso-spacerun: yes"> 
</span>Anyand all comments and suggestions</span></font><font color="black"><span style="mso-bidi-font-size: 
10.0pt;color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal"><font color="black" face="Times New
Roman"size="3"><span style="font-size:12.0pt;mso-bidi-font-size:10.0pt;color:black">appreciated!</span></font><font
color="black"face="Courier New" size="2"><span style="font-size:10.0pt;font-family: 
"Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoAutoSig"><font color="black" face="Arial"><span
style="font-family:Arial;color:black">BrianHoppe</span></font><font color="black" face="Arial"><span
style="font-family:Arial;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black"> </span></font><font color="black" face="Arial"><span
style="font-family:Arial;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black">Manager, E-Commerce Development & IT</span></font><font color="black"
face="Arial"><spanstyle="font-family:Arial;color:black;mso-color-alt: 
windowtext"></span></font><p class="MsoAutoSig"><b><i><font color="blue" face="Arial" size="3"><span
style="font-size:12.0pt;font-family:Arial;color:blue;font-weight:bold;
font-style:italic">SMTResource Group, LLC</span></font></i></b><font color="black" face="Arial"><span
style="font-family:Arial;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black"><a href="http://www.smtresource.com/"><font face="Times New Roman"><span
style="font-family:"TimesNew Roman"">http://www.smtresource.com/</span></font></a></span></font><font color="black"
face="Arial"><spanstyle="font-family:Arial;color:black;mso-color-alt: 
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black"><a href="http://www.smtspares.com/"><font face="Times New Roman"><span
style="font-family:"TimesNew Roman"">http://www.smtspares.com/</span></font></a></span></font><font color="black"
face="Arial"><spanstyle="font-family:Arial;color:black;mso-color-alt: 
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black">Phone:(254)771-3508</span></font><font color="black" face="Arial"><span
style="font-family:Arial;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black">Fax:(530)678-5220</span></font><font color="black" face="Arial"><span
style="font-family:Arial;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black">2506 N. General Bruce Dr.</span></font><font color="black" face="Arial"><span
style="font-family:Arial;color:black;mso-color-alt:
windowtext"></span></font><p class="MsoAutoSig"><font color="black" face="Arial" size="3"><span style="font-size:
12.0pt;font-family:Arial;color:black">Temple, TX 76504</span></font><font color="black"><span
style="color:black;mso-color-alt:windowtext"></span></font><pclass="MsoNormal"><font color="black"><span
style="color:black"> </span></font><fontcolor="black"><span
style="color:black;mso-color-alt:windowtext"></span></font></div>