问题描述
我已将经典的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.
- 我假设首先要支持远程数据库
- 连接字符串正确吗?
- 我是否需要设置链接资源
- 如果我最终将其全部移植到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数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！