Solved
Forum Discussion
whuang
Regular 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.whuang
5 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
- 17 hours agojstaehlin
- 2 days agoAivanitskiy