Linking to SQL server - Mailing list pgsql-interfaces

From Brian J. Hoppe
Subject Linking to SQL server
Date
Msg-id FFEIKGEAKLLMIHKANBJAGEOECCAA.brian@smtresource.com
Whole thread
List pgsql-interfaces

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

 

pgsql-interfaces by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FATAL 1: Password authentication failed
Next
From: Bruce Momjian
Date:
Subject: Re: Borland makefile for libpq...