sql server (alternate): 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 (nospam@nospam.pl) writes:
[quoted text, click to view]

I don't know Postgres, but it's not really that much different
from connecting from a client.

[quoted text, click to view]

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

[quoted text, click to view]

Try Postgres.

[quoted text, click to view]

You can leave this blank, if you include the data source in the
provider srting.

[quoted text, click to view]

The connect string you would use in an application using the
PostgreSQL OLE DB Provider.

[quoted text, click to view]

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

[quoted text, click to view]
[...]
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.