Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2651C476058 for ; Tue, 10 Dec 2002 15:55:50 -0500 (EST) Received: from fuerte.smtresource.com (fuerte.smtresource.com [66.196.19.250]) by postgresql.org (Postfix) with SMTP id 533E6475D87 for ; Tue, 10 Dec 2002 15:55:49 -0500 (EST) Received: (qmail 27671 invoked from network); 10 Dec 2002 20:52:50 -0000 Received: from unknown (HELO taqueria) (192.168.0.33) by t with SMTP; 10 Dec 2002 20:52:50 -0000 Reply-To: From: "Brian J. Hoppe" To: Subject: Linking to SQL server Date: Tue, 10 Dec 2002 14:55:53 -0600 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005A_01C2A05C.3CCA1FF0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/31 X-Sequence-Number: 3444 This is a multi-part message in MIME format. ------=_NextPart_000_005A_01C2A05C.3CCA1FF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Hello List, I don’t know if such a thing exists, and I have been looking in the archives and haven’t found what I’m looking for. Here’s my question: I am trying to find a way to link a table in a remote SQL Server database to my pgsql database. Is there a way to do this without a middleman such as Access? I am able to link the tables from both databases in access, but I want to be able to control it all from the Linux machine. Any suggestions on how to accomplish this? I am pretty sure there are ways because I have seen some different threads on message boards, but no good instructions. Basically, I will be happy if I can treat one of the tables on SQL server as if it were in my PostgreSQL database. Any and all comments and suggestions appreciated! Brian Hoppe Manager, E-Commerce Development & IT SMTResource Group, LLC http://www.smtresource.com/ http://www.smtspares.com/ Phone:(254)771-3508 Fax:(530)678-5220 2506 N. General Bruce Dr. Temple, TX 76504 ------=_NextPart_000_005A_01C2A05C.3CCA1FF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

= Hello List,

=  

= I don’t know if such a thing e= xists, and I have been looking in the archives and haven’t found what I’m lo= oking for.  Here’s my question: =

=  

= I am tryin= g to find a way to link a table in a remote SQL Server database to=

my pgsql database.  Is there a way to do this without= a middleman such as

Access?  I am able to link the tables from both databases in acce= ss, but I

want to be able to control it all fr= om the Linux machine.  Any sugge= stions

on how to accomplish this?  I am pretty sure there are ways b= ecause I have

seen some different threads on messa= ge boards, but no good instructions.

Basically, I will be happy if I can treat one of the tables on SQL server as<= span style=3D'mso-bidi-font-size:10.0pt;color:black;mso-color-alt:windowtext'>

if it were in my PostgreSQL database.  Any and all commen= ts and suggestions

= appreciate= d!

 <= /span>

Br= ian Hoppe

 

Manager, E-Commerce Development &= IT

SMTResource Group, LLC

http= ://www.smtresource.com/

http= ://www.smtspares.com/

Phone:(254)771-3508

Fax:(530)678-5220

2506 N. General Bruce Dr.

Temple, TX 76504

 <= ![endif]>

------=_NextPart_000_005A_01C2A05C.3CCA1FF0--