Creating a Dataset - by dragging table from MYSQL database

With Oracle database, I used to be able to create a dataset by making a database connection in the server explorer and dropping the table onto the dataset designer view.
Can you advise if the same would work for MySql database and how.

I get the foll error :
Mouse drag opertaion failed.
The table, view or table-valued function named ''parts'..'PO_mast'' could not be found.

Foll. is the error if I try to add a Table Adapter using the wizard, when I hit Finish.
An unexpected error has occured.
Error Message: Object reference not set to an instance of an object.

thanks..

Answer this question

Creating a Dataset - by dragging table from MYSQL database

BareFootinBoy
I am using VS Beta 2 version.
Yes I am able to access the database from out of Visual Studio.
Infact within the VS also when I go to Server explorer, I am being able to make the dataConnection and I can see al the tables. even the show Data also works.
But when I try to drag and drop it onto the dataset design view,
I get the error :
Mouse drag Opertaion failed.
The table, view, or table-valued function named ''parts'..'ar_offsets'' could not be found.

I even tried with a MS-Access database and it gave me an error :
Some updating commands could not be generated automatically. The error message was:
ERROR[HYc00][Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented.

In my earlier job I was doing this all with Oracle database and with VS 2003, and the only time I used to get a GENERATE error was when the no. of columns are more than 100 but still it used to create the dataset without any UpdateSql.
Here it fails all togethar. Nothing gets created.

thanks for all your time and help.
JR Lyon
thanks anyways.
Steve_J
Hi,
I am still not able to repro this on VS2005 Beta2 as well as on our post beta2 internal builds. Everything works perfectly fine for me for J# and C#. I tried at least 3 databases for both the languages but couldn't hit the issue.

Can you please answer few more queries...
1. Are you able to repro this for languages other than J#.
2. Are you facing this issue with one particular SQL server DB or all the DBs.

Thanks.
Stefan Krueger

Hi,
I was trying it for J# only. I tried for vb also but failed again :(.

Can you please post this query on following forum. This is VB IDE forum and they are the best to answer VB related issues.
http://forums.microsoft.com/msdn/ShowForum.aspx ForumID=65

Thanks for your patience.
Frank Cazabon
I am working on VB .net. And we have only 2 databases here - mySql and MS-Access and as mentioned above I am getting problems with both of them.

thanks.
irrdev
Hi,
I tried with Northwind and Pubs database (both SQL server DBs, not Oracle). I am able to drag and drop the tables on designer without any problem. Everything works fine for me.

Can you please answer following queries to get us the scenario better...

1. Which version of Visual Studio are you working on
2. Are you able to access the database from out of Visual Studio, say SQL manager or any other utility/application

Thanks.
Creating a Dataset - by dragging table from MYSQL database

Answer this question