MySQL的ODBC问题：数据源名称未找到和指定默认驱动程序 [英] MySQL ODBC Issue: Data source name not found and no default driver specified

问题描述

目前，我正在试图运行，我一直在考虑源$ C ​​$ C为传统的ASP应用程序。我想设置我的64位Windows 7的开发机器时遇到了一个基于ODBC数据连接到MySQL实例麻烦。

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.

我看到错误：

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found 
and no default driver specified

/includes/<File Name>.asp, line 100

我已经试过：

• 的连接是DSN的。


• 申请是根据本地系统权限IIS应用程序池中运行。 w3wp.exe的可以看出在NT AUTHORITY运行/ SYSTEM过程监控。


• 申请是根据IIS应用程序池运行带有可以运行32位应用程序。


• 曾尝试与连接器/ ODBC 5.1.10 64位版本只能从 http://dev.mysql.com （在这一点上没有司机在C列：\\ WINDOWS \\ Syswow64资料\\ odbcad32.exe的但在C：\\ WINDOWS \\ SYSTEM32 \\ odbcad32.exe的）


• 曾尝试与连接器/ ODBC 5.1.10 32位版本只能从 http://dev.mysql.com （在这一点上没有司机在C列：\\ WINDOWS \\ SYSTEM32 \\ odbcad32.exe的但在C：\\ WINDOWS \\ Syswow64资料\\ odbcad32.exe的）


• 曾尝试与5.1.10 32位和64位版本的安装连接器/ ODBC。



• 经过验证的驱动程序名称没有拼写错误。随着从这里 http://support.microsoft.com/kb/306345 其他检查。

• 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 this point no driver was listed under C:\Windows\SysWOW64\odbcad32.exe but was under C:\Windows\system32\odbcad32.exe)
• Have tried with Connector/ODBC 5.1.10 32 bit version only installed from http://dev.mysql.com (At this point no driver was listed under C:\Windows\system32\odbcad32.exe but was under C:\Windows\SysWOW64\odbcad32.exe)
• Have tried with Connector/ODBC 5.1.10 32 bit and 64 bit versions installed.

• Verified driver name is not misspelled. Along with other checks from here http://support.microsoft.com/kb/306345.

驱动= {MySQL的ODBC 5.1驱动};服务器=本地主机;数据库=数据库名;用户=根;密码=密码;选项= 3

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=DBName;User=root;Password=Password;Option=3

其他信息：

我监控过程监控，并且两个结果是：

I'm monitoring in process monitor, and the two results are:

找不到路径（寻找的.asp / web.config中这似乎很奇怪。
缓冲区溢出

PATH NOT FOUND (Looking for .asp/web.config which seems odd. BUFFER OVERFLOW

这两个条目显示：

用户：NT AUTHORITY \\ SYSTEM

User: NT AUTHORITY\SYSTEM

流程：
C：\\ WINDOWS \\ Syswow64资料\\ INETSRV \\程序w3wp.exe
C：\\ WINDOWS \\ Syswow64资料\\ ODBCINT.DLL

Process: C:\Windows\SysWOW64\inetsrv\w3wp.exe C:\Windows\SysWOW64\odbcint.dll

我难倒任何一个可以让我如何在我所描述的背景下得到这个运行有何建议？

I'm stumped can any one make a suggestion on how I get this running in the context I have described?

推荐答案

现在问题解决了。这里记录的情况下，这种利用他人。

Solved the problem now. Recording here in case this of use to others.

问题就简单多了比它第一次出现。问题是，应用程序使用的有名和无名的数据源（DSN / DSN-以下）。混合

The issue was much simpler than it first appeared. The problem was that the application used a mixture of named and unnamed datasources (DSN / DSN-Less).

这不是明显对我来说，任何命名连接使用了，直到我建立了在Visual Studio中调试应用程序。这里是一个粗略的指导，调试Visual Studio中的应用程序（除了我用的基于HTTP的网站，而不是文件系统）：

It was not apparent to me that any named connections were used until I set up the application for debugging in Visual studio. Here is a rough guide to debugging the application in visual studio (Except I used HTTP based website, rather than file system):

的http://www.$c$cproject.com/Articles/28792/Debugging-Classic-ASP-VBScript-in-Visual-Studio-20

继创建所需的DSN，也有一些例外情况进一步对数据库列中的默认值被抛出。这是因为可以在my.ini文件进行更改MySQL的设置。

Following creating the required DSN, there were some further exceptions being thrown regarding default values in database columns. This was due to a MySQL setting that can be changed in the my.ini file.

http://bugs.mysql.com/bug.php?id=14306

C：\\ Program Files文件（x86）的\\的MySQL \\ MySQL服务器5.5 \\ my.ini的

C:\Program Files (x86)\MySQL\MySQL Server 5.5\my.ini

# Set the SQL mode to strict
# sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql-mode=""

这篇关于MySQL的ODBC问题：数据源名称未找到和指定默认驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！