?
Solved

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

Posted on 2010-09-11
5
Medium Priority
?
799 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?
0
Comment
Question by:mnnoon
[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
  • 3
5 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 33656980
I don't understand what you mean by "mapping"...
0
 
LVL 5

Expert Comment

by:milindsaraswala
ID: 33658425
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
 
LVL 1

Author Comment

by:mnnoon
ID: 33659117
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
 
LVL 1

Author Comment

by:mnnoon
ID: 33659205
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
 
LVL 1

Accepted Solution

by:
mnnoon earned 0 total points
ID: 33710876
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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