If you use odbc you should be able to use
https://msdn.microsoft.com/en-us/library/hh568451%28v=sql.110%29.aspx
Kind regards/met vriendelijke groet,
Serge Fonville
http://www.sergefonville.nl
2015-06-07 1:08 GMT+02:00 Geoff Montee :
> On Mon, May 18, 2015 at 11:24 AM, Geoff Montee
> wrote:
>
On Mon, May 18, 2015 at 11:24 AM, Geoff Montee wrote:
>
> The NOTICE right before the error might provide useful information:
>
> NOTICE: DB-Library notice: Msg #: 40508, Msg state: 1, Msg: USE
> statement is not supported to switch between databases. Use a new
> connection to connect to a differ
On Mon, May 18, 2015 at 10:28 AM, Filip Rembiałkowski
wrote:
> Thank you Geoff.
>
> Actually I have a problem - maybe you can point me in the right direction?
>
> CREATE EXTENSION tds_fdw;
> CREATE EXTENSION
>
> CREATE SERVER ms FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'ms');
> CREATE SERV
Thank you Geoff.
Actually I have a problem - maybe you can point me in the right direction?
CREATE EXTENSION tds_fdw;
CREATE EXTENSION
CREATE SERVER ms FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'ms');
CREATE SERVER
CREATE USER MAPPING FOR postgres SERVER ms
OPTIONS (username 'bzzt', pass
Hi Filip,
On Mon, May 18, 2015 at 7:52 AM, Filip Rembiałkowski
wrote:
> Hi.
>
> I will be happy to hear your opinion which one is better - odbc_fdw or
> tds_fdw?
>
> In terms of performance / stability / convenience.
>
> (Pg on OpenSuse, MS SQL on Win2008 )
>
> Thanks!
>
I'm the developer of td
Hi.
I will be happy to hear your opinion which one is better - odbc_fdw or tds_fdw?
In terms of performance / stability / convenience.
(Pg on OpenSuse, MS SQL on Win2008 )
Thanks!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
