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

View Complete Thread
  • Re: Classic ASP + IIS + remotemysql.com

    May 10, 2021 02:47 PM|ertuio|LINK


    I posed the solution for anyone in my situation: I had selected the wrong drivers.

    I went to the windows control panel, looking for "ODBC data source administrator (64bit)" and I realized that the drivers installed for mysql are MySQL ODBC 8.0 ANSI Driver

    Therefore the correct string is:

    conn.Open "DRIVER={MySQL ODBC 8.0 ANSI Driver};Server=remotemysql.com;Database=H8HCs8jWdg;user=H8HCs8jWdg;PWD=********;"