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 geoff.mon...@gmail.com:
On Mon, May 18, 2015 at 11:24 AM,
On Mon, May 18, 2015 at 11:24 AM, Geoff Montee geoff.mon...@gmail.com 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
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:
Hi Filip,
On Mon, May 18, 2015 at 7:52 AM, Filip Rembiałkowski
filip.rembialkow...@gmail.com 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
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',
On Mon, May 18, 2015 at 10:28 AM, Filip Rembiałkowski
filip.rembialkow...@gmail.com 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