Can i include MySql to the IDE?

Hey folks

I tried the whole week to get my MySql Database going with the VS Express 2005. Is there a way to Connect via Data -> Add Data Source, where i can select Database, and then some kind of MySQL Driver I only have MS Access Files, and MS SQL Server Connection, there's no other Data Provider.
Where's the Point to tell the IDE of a new DataProvider

I have the MySql .NET Driver installed... I can add "MySqlConnection", "MySqlCommand" and "MySqlDataAdapter" to the Toolbox... but then i hang on :(

It's so nice, simple and Fast, all that DataDesigerStuff and so on...can I manage it to have this going with MySql

Please help...


Answer this question

Can i include MySql to the IDE?

  • Fabio Vazquez

    Well, this way I can establish a connection...just fine. But the problem remains: can i use this connection now via IDE For example, create DataSources, DataBindings, TableAdapters and so on, or manipulate the Tables via IDE

  • JHalmans

    sorry, it seems that it's not that easy....

  • Bogdan.B

    hi,

    i'm not sure my friend i'm still learning, but just try to open your form designer.vb the wizard add the code there you can for example add a connection by wizard to access database and then go to your form designer and change the connection for your table adapters ... etc or at least to see what hte wizard did for the access db and to do the same for mysql db all what you gonna change is the connection string that is exist in your app.config

    hope that helps



  • Arshad Paracha

    hi,

    i don't think you can add it to your project since it just give you options for access and sql server but you can write a connection to mysql

    you can learn how to write yoru connection manualy at least overview for that

    http://msdn.microsoft.com/vbasic/reference/data/default.aspx pull=/library/en-us/dnsql90/html/mandataaccess.asp#mandataac_topic5

    and the connection string to mysql you can find it here

    database connections >>> http://www.connectionstrings.com/
    database connections >>> http://www.carlprothman.net/Default.aspx tabid=81

    hope that helps



  • William Lai

    Hallo,

    as I said in mycsharp.de, it is not good to use the wizzard. MySQL doesn't provid a full .net 2.0 provider. So you have to wait. But I don't think, that the DDEX - providor could be used with the Express Edition. Imho it can only be used with a version of vs2005 greater than the standard edition.

    Andre


  • Can i include MySql to the IDE?