I have the DB link and I was able to access data on two database on MSSQL via the link fine; however, I wasn't able to access to the third datbaase via the same link and all three databases in MSSQL are sitting on the same server.
I should have the full privilge on the three database.
The errors I got is "table or view does not exist"
: (Error): ORA-00942: table or view does not exist [Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'VENDOR'.[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL State: 00000; SQL Code: 8180) ORA-02063: preceding 2 lines from MSQL
table does exists and I was able to query in MSSQL and I did try double quote.
I am not sure if this is a problem, when I set up the ODBC, Microsoft will ask you the default database so let say I have three daabase in MSSQL I want to get to and I chosee the first database A. I was able to query database and database B but the C database is the one I have problem with. I am not sure this default database have any thing to do with my problem.