Visual Web developer 2005 and MySQL

Posted on 2009-04-29
Last Modified: 2013-11-27
Can we connect to MySQL from visual web developer Express 2005, if we installed the MySQL connector
Question by:Nyana22
    1 Comment
    LVL 1

    Accepted Solution

    You can configure an ODBC connexion to your MySql Database.

    To configure ODBC, go to Administration Tools -> Data Source (ODBC)
    Add a new system datasource.

    After, just make a connection to the ODBC by using Sql datasource object

    You can also directly enter the connection chain in the Sql Datasource object:

    DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Your_Mysql_DB; UID=mysql_username;PASSWORD=mysql_password; OPTION=3

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now