• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 807
  • Last Modified:

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?
0
mnnoon
Asked:
mnnoon
  • 3
1 Solution
 
Bob LearnedCommented:
I don't understand what you mean by "mapping"...
0
 
milindsaraswalaCommented:
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.
0
 
mnnoonAuthor 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.
0
 
mnnoonAuthor 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.
0
 
mnnoonAuthor Commented:
The answer appears to be this:
When you  have a mysql db on your localhost, its much easier to retrieve the necessary mappings or linkages between tables.   So when you port over the database to a hosted provider such as godaddy, which may not have robust support for telling a data connection how certain tables are linked up.  So the solution, is just change the connection string to the hosted provider after properly testing the mysql on the local machine.  If you need to add a table, make sure you switch the connection string back over to the localhost if you want to see the proper mappings such as foreign key relations from one table to another.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now