We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • WebMatrix problem with MySql connection

    Dec 20, 2010 08:22 AM|mscalabrino|LINK


    I have a problem with mysql applications in webmatrix. When I try to publish the site, importing a file.publishsettings, where there are the connections string to database "SQL" and "MYSQL", and click on "Validate Connection", I receive an error "Remote server contacted. Cannot access database". Is very strange, because if I publish an application that not needed mysql database work regularly. The connection string is right, because if I use "msdeploy" string below, work ( the C:\Temp\Test.sql contain a simple CREATE TABLE).

    C:\Program Files\IIS\Microsoft Web Deploy V2>msdeploy -verb:sync -source:dbMySql
    =C:\Temp\Test.sql -dest:dbMySql="server=MySql159.domain.com;uid

    If I publish an application that use SQL database, the validate and the publish work.
    The Mysql platform is an external linux environment, but I don't believe that this is a problem, because him should be use connection string information.