| 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: | Whole Thread | Raw Message | 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 |