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!

Data Source errors with OLE DB for Oracle

527875Aug 11 2006 — edited Jul 10 2008

We tried to install Oracle 10g 10.2.0.1.0 x64 Client for Windows on:

Microsoft Windows Server 2003 Enterprise x64 Edition Service Pack 1 (64 bit)
SqlServer 2000 Enterprise Edition SP4 (32-bit)

When trying to create a Data Source (from a UDL file or Analysis Services) we get the following errors:

"Provider is no longer available. Ensure that the Provider is installed properly"

"Test connection failed because not all properties can be set. Window Handle (BAD VALUE)"

The Oracle Client install completed "Successfully" and ODBC connections work fine. Also, tnsping works fine. Just the OLE DB connections are failing.

Any help greatly appreciated.

Thanks,
J

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2008

Added on Aug 11 2006

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

2 comments

10,693 views