Classic ASP site on Azure website, mysql remote database

Question

I copied the classic asp website to the new Azure websites and tried to connect it to a remote MySQL database (the remote was not hosted on Azure). I am getting an internal server error message, and detailed logs seem to indicate a problem with my connection string.

The current line is configured as follows:

database_string = "Driver={mySQL ODBC 5.1 Driver}; Server=server.com; Port=3306; Option=0; Socket=; Stmt=; Database=mydb; Uid=user; Pwd=password;" and the ADODB connection is setup like such; Set area_rec = Server.CreateObject("ADODB.Recordset") area_rec.ActiveConnection = MM_database_STRING 

I find it difficult to see a specific error, but a couple of questions if anyone can give some recommendations.

• I assume that remote databases are supported first
• Is the connection string correct?
• Do I need to configure a related resource
• If I finally ported everything to SQL Azure, any problem with using ADODB resources?

Thanks so much for any help, I struggled with this for a while.

Answer 1

They do not support connecting to an external database that is not hosted by them or ClearDB.

Set up your own MYSQL in VM or use ClearDB.

Answer 2

There is no support for this in the classic asp on the azure website - even for db cleaning, the MYSQL ODBC driver will not be installed. The only way on Azure is in a virtual machine.