Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE to SQl server dblink not working using DG4ODBC

User_3D0HBDec 20 2010 — edited Dec 20 2010

Hi,

Please Help to relsove below issue

oracle version :10.2.0.4.0
AIX :5.3
Gateway:11.2
SQl server 2005

I have installed gateway on SQl server machine.

I am facing below error

ERROR at line 1:
ORA-00942: table or view does not exist
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'TBL_ARL_CRMUSERS'. {42S02,NativeErr = 208}[Microsoft][ODBC SQL Server
Driver][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180}
ORA-02063: preceding 2 lines from ODS

Please help

This post has been answered by Mkirtley-Oracle on Dec 20 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2011

Added on Dec 20 2010

#heterogeneous-connectivity

16 comments

6,107 views