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!

Oracle Provider not in SSMS but in BIDS

872952Sep 29 2011 — edited Oct 3 2011

Hi all,

When I try to add a linked server in SQL Server Management Studio (SSMS), I can't see the Oracle provider in the drop down. However, it's there in Business Intelligence Development Studio. I can connect to my Data Source just fine and report of our database.

I'm running SQL Server 2008 R2 64 bit on Windows Server 2008 R2 Enterprise 64 bit.

However, SSMS is a 32 bit application so don't know if this has anything to do with it.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2011

Added on Sep 29 2011

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

6 comments

1,205 views