pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
linking from SQL Server
3+ messages / 3 participants
[nested] [flat]

* linking from SQL Server
@ 2002-01-24 21:13  Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 2 replies; 3+ messages in thread

From: Oleg Lebedev @ 2002-01-24 21:13 UTC (permalink / raw)
  To: pgsql-sql

Hi,
I am wondering if anybody tried to link PostgreSQL tables/databases from
SQL Server.
As I understand SQL Server uses OLE DB for this kind of connections. I
wonder if this is possible at all with postgres.
thanks,

Oleg




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: linking from SQL Server
@ 2002-01-25 00:55  Steve Boyle (Roselink) <boylesa@roselink.co.uk>
  parent: Oleg Lebedev <olebedev@waterford.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Steve Boyle \(Roselink\) @ 2002-01-25 00:55 UTC (permalink / raw)
  To: Oleg Lebedev <olebedev@waterford.org>; pgsql-sql

Oleg,

I've just spent the last couple of hours trying to get this to work - with
little success.

I managed to create the linked server using both Enterprise manager and also
Query Analyser using

EXEC sp_dropserver 'Postgresql'
EXEC sp_addlinkedserver 'Postgresql', 'Postgresql', 'MSDASQL',
'DATABASE=[dbname];SERVER=localhost;PORT=5432;A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=
0;A6=;A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;
B9=0;C0=0;C1=0;C2=dd_'

I generated the DSN above from a linked Access table (I've replaced my
actual database name with [dbname] and it works when I test the connection
string in Access.

I tested the connection with:

select * from postgresql...test
select * from postgresql..test
select * from postgresql.test

(The documentation suggests that it wants a fully qualified table name so I
tried all of the above in case there was some mapping taking place in any of
the drivers).

This reports that the linked server has been created but I cannot run SQL
Server queries against it, and cannot find where I can get more details
relating to the OLE DB errors produced.

If anyone can get any further with pls post as I think it would open up some
interesting possibilities.

sb

----- Original Message -----
From: "Oleg Lebedev" <olebedev@waterford.org>
To: "Postgres SQL Mailing List" <pgsql-sql@postgresql.org>
Sent: Thursday, January 24, 2002 9:13 PM
Subject: [SQL] linking from SQL Server


> Hi,
> I am wondering if anybody tried to link PostgreSQL tables/databases from
> SQL Server.
> As I understand SQL Server uses OLE DB for this kind of connections. I
> wonder if this is possible at all with postgres.
> thanks,
>
> Oleg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: linking from SQL Server
@ 2002-01-25 01:19  Josh Berkus <josh@agliodbs.com>
  parent: Oleg Lebedev <olebedev@waterford.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Josh Berkus @ 2002-01-25 01:19 UTC (permalink / raw)
  To: Oleg Lebedev <olebedev@waterford.org>; pgsql-sql

Oleg,

> I am wondering if anybody tried to link PostgreSQL tables/databases
>  from
> SQL Server.
> As I understand SQL Server uses OLE DB for this kind of connections.
>  I
> wonder if this is possible at all with postgres.

In theory, yes.  In practice, no.

According to the documentation, SQL-Server supports any Win32 ODBC
 driver ... which would include PostgresODBC.  However, in practice,
 only Microsoft-supplied drivers actually work; ODBC drivers for
 Postgres and MySQL mysteriously do not function with SQL-Server (even
 though they do work with MS Access).

I think this is incompetence on Microsoft's part rather than malice;
 all of this works through DTS, a utility which is responsible for over
 300 Knowledge Base issues.

Note:  I have not tried any of this with SQL Server 2000, just 7.0 sp3.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco    and non-profit
 organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2002-01-25 01:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-24 21:13 linking from SQL Server Oleg Lebedev <olebedev@waterford.org>
2002-01-25 00:55 ` Steve Boyle (Roselink) <boylesa@roselink.co.uk>
2002-01-25 01:19 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox