search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
381 stars 102 forks source link

Error 4062 #196

Closed deniscorvaisier closed 5 years ago

deniscorvaisier commented 5 years ago

Hi, we change microsoft sql server and we cant use tds_fdw. we have this error. ERREUR: DB-Library error: DB #: 4062, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 11 i add msg_handler = notice but i havent more information i test connection with telnet and its work. user, view, permission are on the new server. Can you give me more detail on this error. postgres 9.6 mssql 2014 tds_fdw 7.4

deniscorvaisier commented 5 years ago

I create a new user on my new mssql server and all is good.