Connecting to localhost MySQL Database

  • Ok .... Just recently installed the latest MySQL. Downloaded the drivers for it as well .... and as I'm practicing in the MySQL workbench I'm again going to use excel and web pages to insert information into the database.


    My first foray will be using excel as I have some experience with Msft SQL server and Access and PostGre databases. Trying to remember everything I did or had to do. But I'm having trouble connecting to the MySQL and I don't know where to look.



    I've posted here at ConnectionStrings.com haven't got a response yet.



    Here is the connection string that I believe should work. But it's giving me an error.


    Code
    1. Private Sub ConnectDB()
    2. Set oConn = New ADODB.Connection oConn.Open
    3. "Provider=MSDASQL;DRIVER={MySQL ODBC 5.3 ANSI Driver};" & _
    4. "SERVER=localhost;" & _
    5. "DATABASE=randomnames;" & _
    6. "USER=root;" & _ "PASSWORD=xxxxxxxx.2010;" & _
    7. "Option=3"
    8. End Sub


    This is the error that I get:

    Quote

    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified