when i am running the databse read i am gettng this error

  • 9 December 2022
  • 3 replies


Operation is not allowed when the object is closed

3 replies

Userlevel 7
Badge +13

Hi @shankarsiva222 ,


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?



Userlevel 5
Badge +14

@Phil 6086  can you provide error message ?