OLEDB Connect 在 Windows Server 2008 上无法一致工作
我的任务是让一个经典的 ASP 页面与我们新的服务器体系结构上的一些 ASP.NET 页面一起工作。我已经设法让经典的 ASP 页面在我的开发盒（运行 Windows Server 2008 SP2，64 位）上运行，但是当它们被推送到服务器（或我同事的开发盒）时，页面就会停止运行在 Connect 语句末尾：
Const DB_CONN = "Provider=MSDAORA.1;User ID=joeblow;Password=connectme;Data Source=MyDB;Persist Security Info=False"
Dim mcnnsws
Set mcnnsws = Server.CreateObject("ADODB.Connection")
mcnnsws.Connect DB_CONN
如果我删除上述内容并仅放入 Response.Write("blah") 它在所有计算机上都可以正常工作，所以我确信我有 ASP 设置IIS7.5足够设置了。我认为这是一个设置或我的数据库连接的设置方式，因为我在服务器上的代码库不起作用，但我机器上的服务器代码库可以工作。
我试图让系统吐出错误消息（调试，IE 设置，仍然死机），并且我尝试使用 SQLPLUS 连接到数据库实例（工作正常）。
有没有办法让连接尝试吐出更多错误？或者还有其他人遇到过类似的事情吗？
提前致谢。
I'm tasked with getting a classic ASP page working in conjunction with some ASP.NET pages on our new server architecture. I've managed to get the classic ASP pages to work on my dev box (running Windows Server 2008 SP2, 64 bit), but when they're pushed to the server (or my co-worker's devbox) the page grinds to a halt at the Connect statement at the end of:
Const DB_CONN = "Provider=MSDAORA.1;User ID=joeblow;Password=connectme;Data Source=MyDB;Persist Security Info=False"
Dim mcnnsws
Set mcnnsws = Server.CreateObject("ADODB.Connection")
mcnnsws.Connect DB_CONN
If I remove the above content and just put in a Response.Write("blah") it works fine on all machines, so I'm sure I have the ASP settings in IIS7.5 adequately set. I think it's a setting or how my db connection is set up because my code base on the server doesn't work, but the server's codebase on my machine does work.
I've tried to get the system to spit out an error message (debugging, IE settings, still just dies) and I've tried connecting to the DB instance using SQLPLUS (works fine).
Is there anyway to get the connection attempt to spit out more of an error? Or has anyone else encountered something like this?
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
确认您的SQL Server、ASP是否运行在相同的位架构上，即它们是否都是64位。您可以将 ASP 与具有类似代码的独立 VBS 进行比较，并针对 VBScript Windows 脚本宿主（C:\Windows\System32\WScript.exe 和 C:\Windows\SysWoW64\WScript.exe）进行尝试。
可以配置 IIS 来控制 ASP 是运行 32 位还是 64 位。
Confirm whether, your SQL Server, ASP is running at the same bit architecture, i.e. whether they're all 64 bit. You can compare your ASP with a standalone VBS that has similar code and try it against both VBScript Windows Script Host (C:\Windows\System32\WScript.exe and C:\Windows\SysWoW64\WScript.exe).
IIS can be configured to control whether your ASP are run 32 bit or 64 bit.