Solved

SSIS MySQL .NET provider not listed

Posted on 2013-10-30
4
400 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Creating and Managing Databases with phpMyAdmin in cPanel.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

803 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