I try to access MSSQL database from a PostgreSQL database by using FreeTDS and tds_fdw, if I am executing below query however always getting error like this.
Query : select * from cm_user where is_active = 't';
ERROR: DB-Library error: DB #: 20018, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 15
When I execute same query for table scan it's working properly.
Query : select * from cm_user;
Operating system : "Ubuntu 20.04.1 LTS"
Version of tds_fdw : 2.0.2
PostgreSQL Version : PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
Version of FreeTDS :
dpkg -l|grep freetds
ii freetds-common 1.1.6-1.1 all configuration files for FreeTDS SQL client libraries
ii freetds-dev 1.1.6-1.1 amd64 MS SQL and Sybase client library (static libs and headers)
There is no any logs on the SQL server related this. Hope this helps.
I try to access MSSQL database from a PostgreSQL database by using FreeTDS and tds_fdw, if I am executing below query however always getting error like this.
Query : select * from cm_user where is_active = 't'; ERROR: DB-Library error: DB #: 20018, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 15
When I execute same query for table scan it's working properly. Query : select * from cm_user;
Operating system : "Ubuntu 20.04.1 LTS"
Version of tds_fdw : 2.0.2
PostgreSQL Version : PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
Version of FreeTDS : dpkg -l|grep freetds ii freetds-common 1.1.6-1.1 all configuration files for FreeTDS SQL client libraries ii freetds-dev 1.1.6-1.1 amd64 MS SQL and Sybase client library (static libs and headers)
There is no any logs on the SQL server related this. Hope this helps.