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

<p>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 :(</p>

<p>I'm getting this message when it tries to connect to my local database:</p>

<p><strong>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.</strong></p>

<pre><code>Line 38:    MasterConn = New ADODB.Connection()
Line 39:    MasterConn.connectiontimeout = 10000
Line 40:        MasterConn.Open(strDB)
</code></pre>

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

<pre><code>PROVIDER=MSDASQL;DRIVER={SQL Server};Server=JONATHAN-PC\SQLEXPRESS\;DATABASE=NetTraining;Integrated Security=true
</code></pre>

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

<p><strong>UPDATE:</strong></p>

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

[{'answer_id': 24744, 'author': 'Dale Ragan', 'author_id': 1117, 'author_profile': 'https://Stackoverflow.com/users/1117', 'pm_score': 3, 'selected': True, 'text': '<p>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.</p>\n\n<p><a href="http://support.microsoft.com/kb/269495" rel="nofollow noreferrer">http://support.microsoft.com/kb/269495</a></p>\n\n<p>If this doesn\'t work and everything checks out, then it is probably your connection string.  I would try these steps next:</p>\n\n<p>Remove:</p>\n\n<pre><code>DRIVER={SQL Server};\n</code></pre>\n\n<p>Edit the Provider to this:</p>\n\n<pre><code>Provider=SQLOLEDB;\n</code></pre>\n'}, {'answer_id': 54809, 'author': 'Michael Pryor', 'author_id': 245, 'author_profile': 'https://Stackoverflow.com/users/245', 'pm_score': 0, 'selected': False, 'text': '<p>As a side note, <a href="http://connectionstrings.com" rel="nofollow noreferrer">connectionstrings.com</a> is a great site so you don\'t have to remember all that connection string syntax.</p>\n'}, {'answer_id': 887833, 'author': 'Amadiere', 'author_id': 7828, 'author_profile': 'https://Stackoverflow.com/users/7828', 'pm_score': 0, 'selected': False, 'text': "<p>I came across this problem when trying to connect to an MySQL database via the wonderful Classic ASP. The solutions above didn't fix it directly, but I resolved it in the end by updating the ODBC Driver (from the long standing 3.51) to the latest version. I was then able to leave the driver line in (and not add the Provider bit), but I did have to update   the connection string accordingly to:</p>\n\n<pre><code>Driver={MySQL ODBC 5.1 Driver};\n</code></pre>\n\n<p>That worked fine. Happy chappy.</p>\n"}]
['https://Stackoverflow.com/questions/24730', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1965/']