SQL2016/SQL2017 Enterprise db connections via ODBC driver 2017 issues
I am having the below errors while connecting to SQL Server above versions via a DBlink. I have HS configured to connect to external databases. I have Oracle 19.21 (oct CPU patch) and ODBC driver 2017 on RHEL 8.8. Please let me know any insights?
[Error] Execution (11: 14): ORA-00942: table or view does not exist
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'DBO.xxxxxxxxxxxx'. {42S02,NativeErr = 208}[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180}
ORA-02063: preceding 2 lines from XXXXXXXXXX