-
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 10: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|