servers - Postgres 8.0.2

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.Maniek (nospam@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||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.