MySQL and Oracle Databases not seen from Visual c# IDE

Question

Hi, I have a couple of projects that I am working on with Oracle and mySQL.  When I try to add the data sources I They are not visible in the datasources window, what's the trick to make these selection options available from the Add Data sources window?

---

MALove

Answer 1

Hi MALove,

Welcome!

You should install the respective provider for MySQL and Oracle.

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Also keep in mind that the Change DS window breaks up data sources into 2 categories: providers and sources.  You need to set the providers properly.  For Oracle you can use .NET Framework Data Provider for SQL Server.  I don't know about MySQL. 

Michael Taylor - 9/5/2011
http://msmvps.com/blogs/p3net

Answer 3

OK, Oracle is installed on the computer, how do I add the provider to the savailable selections in vcsexpress 2010?

---

MALove

Answer 4

Hi MALove,

Thanks for your feedback.

You can run the Add Connection Wizard in Server Explorer.

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 5

Alan it isn't showing up. I installed the ODAC program and oracle server. Also MSSQL server compact 4.0 doesn't appear but that option is available in VS 2010 web developer.

 

IWhen i installed th odac fil for Oracle it was an install.bat run from the cmd line. So I am missing some steps somewhere.

Do any files need to be placed in a specific directory? If so what/where?

---

MALove