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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

cannot create linked server

Mayur RahateJan 8 2015 — edited Jan 13 2015

Hi All,

We are trying to access oracle views from sql server.

Oracle database verion is 11.1.0.7 and oracle client version is 11.2.0.4

When trying to create link server is sql server mode we are getting an error.

Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server.

(Microsoft Sql Error , Error:7302)

However it is running fine in windows authentication mode.

Sql server version - 12

MS windows server 10

Can we use Oracle client 11.2.0.4 with 11.1.0.7 Database. Is is because of this or it is due to some other error,

Please help.

Thanks and Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2015

Added on Jan 8 2015

#general-database-discussions

10 comments

949 views