Solved

SSMA connection

Posted on 2016-09-05
3
23 Views
Last Modified: 2016-10-08
Unable to find specified provider.
Error occurred while establishing connection to Oracle server. You might have 32-bit connectivity components installed on the machine, in order for SSMA to make use of those connectivity libraries, you need to run the 32-bit version of SSMA application whose shortcut can be found under the Programs menu.
SSMA-for-Oracle.png
0
Comment
Question by:pradeep kumar
  • 2
3 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points (awarded by participants)
ID: 41784562
I think the error is self explanatory.
You have SSMA 64bit and Oracle client 32bit installed. You'll need to have same architecture versions installed to have it work properly.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
ID: 41804641
Pradeep, any feedback on this question?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now