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, 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 connect to a different database., Server: ms, Process: > > ,Line: 1, Level: 16 > > > > tds_fdw doesn't explicitly call the "USE" statement. It calls the > > dbuse() DB-Library function: > > > > https://github.com/GeoffMontee/tds_fdw/blob/master/src/tds_fdw.c#L703 > > > > > http://www.freetds.org/reference/a00341.html#ga66ea891910f0a357cc78107d6ab7d962 > > > > This function does seem to call USE behind the scenes: > > > > https://github.com/FreeTDS/freetds/blob/master/src/dblib/dblib.c#L1414 > > > > This seems to be a limitation specific to Azure. Are you using that?: > > > > http://stackoverflow.com/a/14167073/1732980 > > > > I'll try to come up with a permanent fix for this at some point. I > > added this bug to GitHub. Feel free to subscribe to it: > > > > https://github.com/GeoffMontee/tds_fdw/issues/23 > > > > If anyone else is having issues using tds_fdw with Microsoft Azure, > the latest commit adds a foreign server-level "database" option which > fixes the dbuse() issue with Azure. See the GitHub issue for details: > > https://github.com/GeoffMontee/tds_fdw/issues/23#issuecomment-109655082 > > I'll probably package up a tds_fdw 1.0.2 release relatively soon. > > Thanks, > > Geoff Montee > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
