DevOps, CI/CD and Automation

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!

Linked server failing with SQLServer error 7303 and ORA-12154

778638Jun 10 2010

Hi,
We had a SQLServer linked server connecting to an Oracle XE (10g) instance through a linked server.
I installed Oracle SE1 on the same platform as my XE database (Windoes Server sp3) with a different SID - I tried to create a new linked server on the SQLServer platform but the connection results in the above errors.

I can connect to the Oracle SE1 database from a cmd session/sqlplus on the SQLServer platform (9i client).

The client on the SQLServer platform is Oracle 9i - will installing/upgrading the client to 11g on the SQLServer platform fix my problem?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2010

Added on Jun 10 2010

#oracle-provider-for-ole-db, #windows-and-net

0 comments

1,907 views