i just install sql 2005. we were running on 2000. i have several stored procedures that access sql servers and some that access as400 data.
i work great on 2000 but now i get the above message when i try and run the sp on the server from a web application.
i have turned on ole.
i can use server manager and open a sql query window on the server and run the stored procedure. but i can not in my web asp.net application if i execute "spcmd.ExecuteNonQuery()"