Skip to main content
Question

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

  • December 9, 2022
  • 3 replies
  • 362 views

Forum|alt.badge.img

Operation is not allowed when the object is closed

3 replies

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Premier Pathfinder | Tier 7
  • December 9, 2022

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.


Forum|alt.badge.img
  • Cadet | Tier 2
  • January 10, 2023

@Padmakumar 

 

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


rbkadiyam
Premier Pathfinder | Tier 7
Forum|alt.badge.img+17
  • Premier Pathfinder | Tier 7
  • January 10, 2023

@Phil 6086  can you provide error message ?