Azure网站上的经典ASP网站，远程mysql数据库 [英] Classic ASP site on Azure web site, remote mysql database

问题描述

我已将经典的ASP网站复制到新的Azure网站，并试图使其连接到远程MySQL数据库(远程未托管在Azure上).我收到内部服务器错误消息，并且详细的日志似乎指向我的连接字符串有问题.

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

当前字符串设置如下:

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 am having a hard time seeing the specific error, but a couple questions if anyone could provide some guidance.

1. 我假设首先要支持远程数据库
2. 连接字符串正确吗?
3. 我是否需要设置链接资源
4. 如果我最终将其全部移植到SQL Azure，那么使用ADODB索引集是否有任何问题?

非常感谢您的帮助，我已经为此苦苦挣扎了一段时间.

Thank you much for any help, I have struggled with this for a while.

推荐答案

它们不支持与不是由他们或ClearDB托管的外部数据库的连接.

They don't support connection to external database which is not hosted by them or ClearDB.

在VM中设置自己的MYSQL或使用ClearDB.

Setup your own MYSQL in VM or use ClearDB.

这篇关于Azure网站上的经典ASP网站，远程mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！