Link to home
Start Free TrialLog in
Avatar of mnnoon
mnnoonFlag for United States of America

asked on

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

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?
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

I don't understand what you mean by "mapping"...
Avatar of milindsaraswala
milindsaraswala

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.
Avatar of mnnoon

ASKER

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.
Avatar of mnnoon

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of mnnoon
mnnoon
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial