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

    Hi,

    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
    =MS183026_dba;pwd=mypassword;database=domain_net_testdb",wmsvc=farm06.domain.
    com:8172/msdeploy.axd?site=testwin.biz,userName=testuserwin@testwin.biz,password
    =mypassword

    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.

    Regards.

    Massimiliano.