Operation is not allowed when the object is closed
Hi
I hope you meant the Excel as DB here. From the error, it is clear that the file which you are trying to read is not in open state. Please check and make sure that you have mentioned the correct file path for the DB connection, and you are using the same session names for connecting and reading from the file.
I am getting this message when calling a Stored Procedure in one of our DB’s
I am using the same DB connection I used to call other SP for other processes. All SP’s l live in the same DB and I have access. I can run the SP in SQL Manager without issue.
Any Ideas?
Philip
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.