I produce reports using stored procs to which I pass x parameters. On my dev box all works well. As soon as I run the exe on my live environment I get the above error. Moreover, with the live environment the reports do not retreive data on the first attempt. I have to re-execute the report to produce data. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CR9/VB6/SQL2005 - error -2147352571 This value is write only
- Thread starter northrd
- Start date
- Thread starter
- #2
I have found the problem. For some unbelieveable reason the parameters that I have for my stored procs, copied directly from my dev PC onto the server, are requested by mssql 2005 in a different order to those on my dev box! What the %^$#?
Is this a documented thang?
Is this a documented thang?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question