weird issue connecting from Oracle to MSSQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: weird issue connecting from Oracle to MSSQL

Threaded View

  1. #1
    Join Date
    Jan 2005
    Posts
    221

    weird issue connecting from Oracle to MSSQL

    Hi all,

    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"
    [1]: (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

    any thoughts on how to troubleshoot the issue???

    thanks,
    Last edited by hannah00; 04-18-2005 at 11:40 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width