Re: OLEDB for PostgreSQL

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: OLEDB for PostgreSQL
Date: 2021-04-16 21:42:16
Message-ID: CADUqk8WOyui5pfV6VxOPpPjG_iwj98WEQsqSVKhBYDSMk_2cqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

On Fri, Apr 16, 2021 at 10:25 AM Thomas Kellerer <shammat(at)gmx(dot)net> wrote:

> mustafa(dot)pekgoz(at)forenda(dot)com(dot)tr schrieb am 16.04.2021 um 12:32:
> > We want to start migration to POSTGRESQL13 from MSSQL SERVER but we
> > couldnt find any solution for oledb drivers. Please help us to find a
> > solution or any workaround if possible.
>
> I don't think there is a free OleDB provider, but there seems to be at
> least one commercial: https://www.pgoledb.com/
>
> I don't really know the whole OleDB/.Net/ODBC world (it seems, Microsoft
> changes its strategy around that every other year) - but there is a free
> .Net provider: https://www.npgsql.org/ not sure if that is of any help
>
> And obviously there is an ODBC driver.
>

Back in the day, this was possible via the "Microsoft OLE DB Provider For
ODBC drivers" and using the Postgres ODBC driver. Is the generic
Microsoft-provided OLE DB provider for ODBC not still around?

--
Jonah H. Harris

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kenneth Marshall 2021-04-16 21:52:37 Re: OLEDB for PostgreSQL
Previous Message MichaelDBA 2021-04-16 20:24:39 Re: Reordering the fields in a table

Browse pgsql-performance by date

  From Date Subject
Next Message Kenneth Marshall 2021-04-16 21:52:37 Re: OLEDB for PostgreSQL
Previous Message Eugen Konkov 2021-04-16 19:27:35 Re: BUG #16968: Planner does not recognize optimization