I have a program which hits a SQL server 2000 database and was tested in a DEV, Test, and UAT environment all existing as seperate instances on 1 server. Everything tested fine but when we promoted to a different production server the application recieved an error like:
Error #: -2147217904 by Microsoft OLE DB Provider for SQL server
and states that a parameter which a stored proc expected was not supplied.
We have been able to trace to problem to a requery command in ADO but can't figure out why this never showed up on the other server. Anyone have any ideas?