470,561 Members | 2,307 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,561 developers. It's quick & easy.

Linked 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.
Jul 23 '05 #1
2 2732
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
Jul 23 '05 #2
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.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Raghuraman | last post: by
8 posts views Thread by Ootyguy | last post: by
3 posts views Thread by RandyMartin | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.