Solved
Forum Discussion
AlexKaras
Champion Level 3
Hi,
Does the same error occur if you remove 'multipleactiveresultsets=true;' from the connection string?
whuang
5 years agoRegular Contributor
Yes, I removed 'multipleactiveresultsets=true;' from the connection string, and tried on both machines that have Native Client 11 and doesn't have Native Client 11.
It still returned the same VBScript runtime error "
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." on the machine that has Client 11, and it returned a different runtime error "
Provider cannot be found. It may not be properly installed.
" on the machine that doesn't have client 11.- whuang5 years agoRegular Contributor
Update, looks like the connection string I used was wrong. I take advantage of the wizard to build a connection string, and used it in the script, and it worked.
Related Content
Recent Discussions
- 10 hours agojstaehlin
- 2 days agoAivanitskiy