在尝试在64位Windows 7环境中运行经典ASP应用程序时，遇到ODBC数据源连接到MySQL实例的问题。错误提示为'数据源名称未找到和指定默认驱动程序'。已尝试使用不同版本的MySQL Connector/ODBC，并调整了IIS应用池设置，但问题依旧。最终发现应用中混合使用了命名和未命名的数据源（DSN/DSN-Less），通过在Visual Studio中设置调试并创建所需的DSN，解决了问题。此外，还需要修改my.ini文件中的SQL模式设置。
I'm currently trying to run a classic ASP application which I've been given source code for. I want to set up on my 64bit Windows 7 dev machine and am having trouble with an ODBC based data connection to a MySQL instance.
I'm seeing the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
/includes/.asp, line 100
What I've tried:
The connection is DSN-less.
The application is running under IIS app pool with local system permissions. w3wp.exe can be seen running under NT AUTHORITY/SYSTEM in process monitor.
The application is running under IIS app pool with 32 bit applications allowed to run.
Have tried with Connector/ODBC 5.1.10 64 bit version only installed from http://dev.mysql.com (At th
最低0.47元/天 解锁文章
扫一扫
1103
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
