这是什么'多步OLE DB“的错误？ [英] What is this 'Multiple-step OLE DB' error?

问题描述

我做的工作一点点由上最好的Bangalores建立了一个可怕的软件。

I'm doing a little bit of work on a horrid piece of software built by Bangalores best.

这是写大多在传统的ASP / VBScript中，而是移植到ASP.NET，虽然大部分的code是传统的ASP风格的ASPX页面：（

It's written in mostly classic ASP/VbScript, but "ported" to ASP.NET, though most of the code is classic ASP style in the ASPX pages :(

当它试图连接到我的本地数据库，我得到这个消息：

I'm getting this message when it tries to connect to my local database:

生成的多步OLE DB操作错误。检查每个OLE DB状态值，如果可用。没有工作已完成。

Line 38:    MasterConn = New ADODB.Connection()
Line 39:    MasterConn.connectiontimeout = 10000
Line 40:        MasterConn.Open(strDB)

任何人有什么线索这个错误意味着什么？使用此连接字符串，它连接到我的本地机器（运行SQLEX preSS）：

Anybody have a clue what this error means? Its connecting to my local machine (running SQLEXPRESS) using this connection string:

PROVIDER=MSDASQL;DRIVER={SQL Server};Server=JONATHAN-PC\SQLEXPRESS\;DATABASE=NetTraining;Integrated Security=true

这也是它最初使用的连接字符串，我只是重新瞄准它在我的数据库。

Which is the connection string that it was initially using, I just repointed it at my database.

更新：

问题采用综合安全与ADO了。我改变了使用用户帐户并将其连接就好了。

The issue was using "Integrated Security" with ADO. I changed to using a user account and it connected just fine.

推荐答案

我在ASP工作遇到了这个很久以前。我发现这个知识库文章，它帮了我。我希望它可以解决你的问题。

I ran into this a long time ago with working in ASP. I found this knowledge base article and it helped me out. I hope it solves your problem.

的 http://support.microsoft.com/kb/269495

如果这不工作，一切正常，那么它可能是您的连接字符串。我会尝试这些步骤下一：

If this doesn't work and everything checks out, then it is probably your connection string. I would try these steps next:

删除：

DRIVER={SQL Server};

编辑提供这样：

Provider=SQLOLEDB;

这篇关于这是什么'多步OLE DB“的错误？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！