From: | Andreas Tille <tillea(at)rki(dot)de> |
---|---|
To: | Alex Bolenok <abolen(at)chat(dot)ru> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Migrating from MS SQL server |
Date: | 2000-08-10 07:06:14 |
Message-ID: | Pine.LNX.4.21.0008100858570.13485-100000@wr-linux02.rki.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 18 Jul 2000, Alex Bolenok wrote:
> If you fail to set up an ODBC Subscriber, you may still try to set up an OLE
> DB Subsriber. First create a linked server (use OLE DB for ODBC) and insert
> either DSN or provider string into the corresponding field. Then if you
> select this linked server in the Enterprise Manager, you will see the tables
> that reside in the database you selected. It means that the linked server is
> set up properly. Then you should create a new OLE DB Subscriber and when
> asked select the linked server you have created. It must work too.
Back from holidays I did a further try to cope with your suggestion.
I really didn't managed to install the ODBC Subscriber for the
replication mechanism. Fortunately I managed to create a linked server
and finally I could see the tables of the PostgreSQL database.
Unfortunately my stupid German documentation dosn't give me any hint
how to create a OLE DB subscriber. (Does anybody know if I could
get a English one from MS once bought a German for free? - I suppose
not.) Could anybody tell me which damn menu I have to pull to get
such a beast installed. It's a shame to ask such questions here but
I really get upset yesterday when trying to fiddle around with this
beast :-( - sorry.
Kind regards
Andreas.
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Guryanow | 2000-08-10 11:38:47 | problem with plpgsql function |
Previous Message | Joshua Adam Ginsberg | 2000-08-10 06:33:30 | PSQL woes |