We help IT Professionals succeed at work.

MySQL Data Adapter Mapping in Visual Studio DataSets when on godaddy.com

833 Views
Last Modified: 2012-05-10
How do I get mysql's "data adapter mapping" to map correctly (or at all)  if I pull tables or sprocs from a mysql database that is hosted on goddady.com?  Or is it even possible?
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2008

Commented:
I don't understand what you mean by "mapping"...
Do you have permission to use that database ?? Do you have username and password to that database ??
If the answer of both the question is yes than it is possible to connect to the mysql.

Kindly give more explanation of your requirement so I can help you.

Author

Commented:
Hi, thanks for your query.
 I'm talking about database mappings.  When I have the mysql database on the local machine, I can place the tables into the dataset and view the connections. However, if I move the database to godaddy's mysql repository, and then try and place the tables into the dataset there are no mappings.  It's like the mysql connection is not smart enough to tell the dataset how it's related to the other tables, queries, and sprocs.'
I think the data adapter that I created with my local mysql db, will still work with the db that is on the godaddy or hosted account, but I'm also not sure how to change the connection string for the dataset or data adapter - I've had limited success.   Also Entity framework also has problems with these mappings when pulling from a godaddy mysql db...  ie. the foreign key relationship lines from one table to another don't show up when I attempt to add tables, views, queries, sprocs etc. from a connection object in the server explorer.
Not sure if that helps you.
If you want to emulate it, just open a connection in server explorer, select one or more tables in your server explorer and plop them into a database dataset.

Author

Commented:
Thanks for your comment milindsaraswala,
Yes I do have the username and password.  The databas connects fine which means the user name and password work, and I can insert, delete, update, or select data from either the local or remote db.  I think I know what you are getting at that in order for the db mappings to come across cleanly, it will need to properly authenticate.  But there seems to be reduced functionality between a goddady.com mysql db that is hosted as compared to the one that is on my local machine w/ regards to mappings functionality.  What I'm trying to do is 1. confirm this, 2. determine whether or not I can fix it somehow.  Maybe even an elastic server somewhere thats as cheap or cheaper than godaddy.com acct.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.