Hi Sashi,
Thanks for your reply.
I have checked the connection and it is working fine. All my other procedures, views and queries are running perfectly....
User Profile
Collapse
-
After spliting , try using the right function for the year right(string,2) .then concatenate the string. this should work.Leave a comment:
-
Stored Procedure Problem
I have been working on a program where a stored procedure is executed and the results are displayed.
The code works perfectly on my local server and gives the desired output. But when I upload the same on a live server it gives me an error:
Operation is not allowed when the object is closed.
Can somone help? this is how I am executing the procedure:
set rsNew = Con.Execute("Co ntract_EMail...
No activity results to display
Show More
Leave a comment: