Linked Servers - Postgres 8.0.2

[Maniek]

Hi,

I have: (WinXP+SP2+MSSQL2k+Postgres 8.0.2)
I'm trying to link the PostgreSQL 8.0.2 server
in Enterprise Manager Tree
and don't know some of the parameters.
Has someone of you a Postgres server linked to MSSQL?
Could you tell me, what data you have, please?

Security / Linked Servers / New Linked Server...

Linked Server:............???
Provider Name: PostgreSQL OLE DB Provider (do you us this one?)
Product name:.............???
Data source:..............???
Provider string:..........???
Location:.................???

Distributed Transaction Coordinator i running.
What else should I do?

Thanks a lot if you could help,
Maniek.

[Erland Sommarskog]

Maniek (no****@nospam.pl) writes:

I have: (WinXP+SP2+MSSQL2k+Postgres 8.0.2)
I'm trying to link the PostgreSQL 8.0.2 server
in Enterprise Manager Tree
and don't know some of the parameters.
Has someone of you a Postgres server linked to MSSQL?
I don't know Postgres, but it's not really that much different
from connecting from a client.
Linked Server:............???
This is just an alias, so you can put any name here.
Provider Name: PostgreSQL OLE DB Provider (do you us this one?)
Product name:.............???
Try Postgres.
Data source:..............???
You can leave this blank, if you include the data source in the
provider srting.
Provider string:..........???
The connect string you would use in an application using the
PostgreSQL OLE DB Provider.
Location:.................???

Odds are good that you can leave this blank, although it depends
on the OLE DB provider.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[student]

Erland Sommarskog wrote:

Linked Server:............???

This is just an alias, so you can put any name here.

[...]
Thank you very much you've tried to help me.
Finally I've solved the problem using ODBC.
With OLE DB it was very difficult - it's not very stable.