Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Floffy 26 posts 33 karma points
    Dec 26, 2009 @ 17:38
    Floffy
    0

    Problem connecting to MySQL database

    Problem connecting to MySQL database

    Hi, I got a problem connecting to the MySQL database.

    During install I type in the database info but I get this: Database connection initialisation failed. The installer cannot connect to the database.

    Tryed verifying the database info by this classic asp:

     

    <%
    user = "*"
    pass = "*"
    db = "*"
    response.write "<p><b>Result:</b><br>"
    set conn = server.createobject("ADODB.connection")
    conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & db & "; DATABASE=*; UID=" & user & "; PWD=" & pass & ";"
    response.write "OK!</p>"
    %>

    Connection info seems to be OK, any ideas?

    Is there a way to get more info on the error?

    I am running umbraco 4.0.3, on a host using  Windows Server 2003, IIS 6.0, MySQL 5.0.51a-log

     

    Trying to use VistaDB I'll get this error: Could not save the web.config file. Please modify the connection string manually. An error occurred loading a configuration file: Access to the path '*\s4vtymtc.tmp' is denied. 

    Could there be a connection?

  • Jukka-Pekka Keisala 79 posts 203 karma points
    Dec 27, 2009 @ 08:59
    Jukka-Pekka Keisala
    0

    I think you have issue on .NET connect to MySQL. Not sure what exactly goes wrong as I have no mysql running on my machine atm but I advice to check out connection from .NET data provider.

    Do you have Visual Studio (or Visual Studio Express)? If you do you could try to verify connection from: View -> Server Explorer. Then choose Connect Database and choose your dataprovider.

     

Please Sign in or register to post replies

Write your reply to:

Draft