Oracle Database Express Edition (XE)

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!

Heterogeneous Services ODBC to MS SQLSvr - ORA-00904 error

530693Sep 25 2007 — edited Sep 27 2007

Hello, I have successfully setup a heterogeneous Services ODBC to MS SQLSvr using the steps outlined at http://www.orafusion.com/art_orahs.htm.

My problem is, the only queries that run without errors are SELECT * FROM tablename@xxx. When I try SELECT colname FROM tablename@xxx I get an ORA-00904: "colname": invalid identifier. Any thoughts?

Also, will I be able to update MS SQLSvr tables using this link?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2007

Added on Sep 25 2007

4 comments

636 views