Link to MySQL Database

Posted on 2006-05-08
Last Modified: 2010-04-23

Really looking for guidence rather than a solution

Want to link into a MySQL database that we have with our host.

Can anybody guide me into where to start first.

I have VS.NET 2003. Is there a DataAdapter that allows this?
Question by:KBanner
    LVL 52

    Accepted Solution

    You would need to use either the Odbc or OleDb database objects located in the System.Data.Odbc and System.Data.Oledb namespaces respectively. Conenction strings for MySQL can be found here:

    If you need a code sample just say.

    Author Comment

    Some code would be good thanks carl.

    If you were to set it up via the dataAdapter wizard, is there anything I should know regarding host addresses etc.
    LVL 52

    Expert Comment

    by:Carl Tawn
    There are some samples here:

    Only used MySQL a few times on Linux, but i'm not aware of any specific problems connecting to it. Haven't really used the DataAdapterWizard either so can't really comment, but I would guess it's fairly straight forward.

    The usual things to look out for are firewalls and port numbers, but as long as you're using the defaults you should be ok.

    If you run into any problems just post them here and we'll be happy to help you troubleshoot.
    LVL 96

    Assisted Solution

    by:Bob Learned
    You can use the MySQL .NET data provider with .NET 2003:


    Author Comment

    Guys, thanks very much.

    That'll give us a good foundation to get our feet wet.

    Author Comment

    I will issue points straight after, however, if I have further 'quick' questions, may I post at a later time?

    Thanks again

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
    Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    734 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

    22 Experts available now in Live!

    Get 1:1 Help Now