Tuesday, March 23, 2010

Excel VBA - "operation is not allowed when the object is closed"

This is normally caused by the stored procedure called, you will need to place 'set nocount on' on top of the SP to eliminate the extra information returned.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Elevating LLM Deployment with FastAPI and React: A Step-By-Step Guide

  In a   previous exploration , I delved into creating a Retrieval-Augmented-Generation (RAG) demo, utilising Google’s gemma model, Hugging ...

  • 15401 error
    Error 15401: Windows NT user or group '%s' not found. Check the name again. SELECT name FROM syslogins WHERE sid = SUSER_SID ('Y...
  • Change SQL Server Collation in a clustered environment
    start /wait D:\Servers\setup.exe /qn VS=[VIRTUALSERVER] INSTANCENAME=[MSSQLSERVER] REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=[CUR...
  • Epicor E4SE and eBackoffice Go Live
    Finally, it is time. E4SE 811 and eBackoffice 736 will replace our current 810b/735a environment after staying so many years. Just got the n...