Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center