I'm trying to run a stored procedure on MS SQL Query Analyzer but continue to get the following error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0005 - Error occurred in the OS/400 database server code.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80004005: ].
I can successfully run this stored proc on another server running SQL Server. I've checked to see how the iSeries ODBC is configured and it is the same on both machines.
Any clue as to how to fix this will be a great help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!