title: Using Oracle Heterogenous services to access sql server database table via ODBC
body: <p>I have created a dblink 'POC_HS' from oracle to sql (implemented heterogeneous services) and I am able to successfully pull out data from the default database that the DSN(for sql server) is connected to.</p>
  
  <p>So this 'select * from Test@POC_HS' is working perfectly fine on the Oracle database as 'Test' table resides in the default database (which the System DSN is connected to).</p>
  
  <p>But when I do 'select * Abc.Test@POC_HS' where Test table resides in 'ABC' database which is not the default database throws an error as follows:</p>
  
  <p>ORA-00942: table or view does not exist
  [Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Abc.Test'.[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL State: S0002; SQL Code: 208)</p>
  
  <p>The dblink user and System DSN account has access to the 'Abc' database.</p>
  
  <p>Thoughts?</p>