Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSIS MySQL .NET provider not listed

Posted on 2013-10-30
4
Medium Priority
?
422 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 1000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

610 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