Solved

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

Posted on 2010-09-11
5
783 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
  • 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now