Solved

SSIS MySQL .NET provider not listed

Posted on 2013-10-30
4
398 Views
Last Modified: 2016-02-11
I have installed the MySQL connector.net 6.7.4 & the odbc 5.2.6 drivers for 32bit on my win 2k8 32bit server

But when I open SSIS and try to choose the MySQL .net provider from the list of .NET connections it is not in the list?

Any ideas?
0
Comment
Question by:BrianFord
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 total points
ID: 39613248
Have you tried using an ODBC connector in SSIS? I've not used MySQL like this, but maybe going through the ODBC system to get to the MySQL part is the way to go.

hth

Mike
0
 

Author Comment

by:BrianFord
ID: 39613756
Yes, that's what I'm currently using but I'm trying to find out why the .NET provider is not available?

I have another BI server and the provider shows up fine on that one and I can see no difference in setup
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 39615603
Well, there must be a difference - it's a matter of discovering just what <grin>

Check your versions of .net. Maybe your connector needs a version that's installed on one machine and not on the other.

Also check the machine.config file, somewhere down there below \Windows\Microsoft.net\Framework and see if playing around with that helps - compare it with the one on the other machine (but make a backup first!!)

hth

Mike
0
 

Author Comment

by:BrianFord
ID: 39628285
Check it all, all looks the same other than the fasct that 1 is 32bt and the other is 64bit

But I have verified that the correct version of the drivers are installed
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

920 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