DB-Library error: DB #: 20009, DB Msg: Unable to connect: Adaptive Server is unavailable or does not exist (hostname), OS #: 0, OS Msg: Success, Level: 9

[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

Rhel8

Version of tds_fdw

Version 2.x

Version of PostgreSQL

Postgresql15 

[juliogonzalez]

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 am using the latest version of tds_fdw I cloned it, and I did user mapping

…

On Wed, 9 Oct 2024, 21:51 Julio González Gil, ***@***.***> wrote: 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. — Reply to this email directly, view it on GitHub <#368 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIOW6G2OJ7ZUUUNUVLGQKV3Z2WJNBAVCNFSM6AAAAABPUJYS46VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMBTGQYDKNRVGM> . You are receiving this because you authored the thread.Message ID: ***@***.***>