Solved

SSMA connection

Posted on 2016-09-05
3
44 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 47

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 47

Expert Comment

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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL: Episode III - Revenge of The Dude 24 52
T-SQL: "HAVING CASE" Clause 1 23
sql select record as one long string 21 22
T-SQL Default value in Select? 5 25
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

776 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