juliogonzalez
commented
1 month ago There's not much information to provide support and unfortunately the error from TDS is not very descriptive
- You say tds_fdw is version 2.x... but what version exactly?
- Did you miss creating the user mapping? It's not on your list.
- Did you check the MSSQL server is reachable from the machine where PostgreSQL is running? There can be a lot of things failing between your PostgreSQL and MSSQL. I'd assume you did, because of what I see on the error. But if not, check just in case.
- If MSSQL is reachable, then maybe you need to set the TDS version as specified at https://github.com/tds-fdw/tds_fdw/blob/master/ForeignServerCreation.md or other parameter such as languages... It could be the specifics on your MSSQL server.
whalay
I created a mssql_server from MSSQL, I created a foreign table and I want to query from it
postgres=# CREATE FOREIGN TABLE orders(price INT, discount INT) SERVER mssql_server OPTIONS (query 'SELECT PRICE, DISCOUNT FROM apps.odd.orders'); CREATE FOREIGN TABLE
I tried to query the foreign table select price from orders;
But I got this error: DB-Library error: DB #: 20009, DB Msg: Unable to connect: Adaptive Server is unavailable or does not exist (VSIS-PMSDB), OS #: 0, OS Msg: Success, Level: 9
Operating system
Version of tds_fdw
Version of PostgreSQL