MSSQL2008 – Pyodbc – Previous SQL was not a query

by

Just in case some lonely net nomad comes across this issue, the solution by Torxed didn’t work for me. But the following worked for me.

I was calling an SP which inserts some values into a table and then returns some data back. Just add the following to the SP : 

SET NOCOUNT ON

It’ll work just fine 🙂

The Python code :

    query = "exec dbo.get_process_id " + str(provider_id) + ", 0"
    cursor.execute(query)

    row = cursor.fetchone()
    process_id = row[0]

The SP :

USE [DBNAME]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[GET_PROCESS_ID](
    @PROVIDER_ID INT,
    @PROCESS_ID INT OUTPUT
)
AS
BEGIN
    SET NOCOUNT ON
    INSERT INTO processes(provider_id) values(@PROVIDER_ID)
    SET @PROCESS_ID= SCOPE_IDENTITY()
    SELECT @PROCESS_ID AS PROCESS_ID
END

More Related Contents:

  1. Pyodbc error Data source name not found and no default driver specified paradox
  2. How do I copy a string to the clipboard?
  3. Python Ctypes – loading dll throws OSError: [WinError 193] %1 is not a valid Win32 application
  4. How to execute Python scripts in Windows?
  5. Windows is not passing command line arguments to Python programs executed from the shell
  6. Python pysftp get_r from Linux works fine on Linux but not on Windows
  7. fcntl substitute on Windows
  8. Python command not working in command prompt
  9. python pip specify a library directory and an include directory
  10. Popen with conflicting executable/path
  11. Detecting Mouse clicks in windows using python
  12. Accessing CPU temperature in python
  13. Python running as Windows Service: OSError: [WinError 6] The handle is invalid
  14. How do I install SciPy on 64 bit Windows?
  15. pyclipper installation error: “tp_print is not a member of _typeobject”
  16. Get the title of a window of another program using the process name
  17. Microsoft Visual C++ Compiler for Python 3.4
  18. How to connect to a remote Windows machine to execute commands using python?
  19. Tensorflow r1.0 : could not a find a version that satisfies the requirement tensorflow
  20. IOError: [Errno 13] Permission denied when trying to open hidden file in “w” mode
  21. How do I eliminate Windows consoles from spawned processes in Python (2.7)? [duplicate]
  22. Pyodbc – “Data source name not found, and no default driver specified”
  23. How to get the text cursor position in Windows?
  24. Making Python scripts run on Windows without specifying “.py” extension
  25. How to change the location of the pointer in python?
  26. Why python executable opens new window instance when function by multiprocessing module is called on windows
  27. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  28. multiprocessing: How can I ʀᴇʟɪᴀʙʟʏ redirect stdout from a child process?
  29. Python long filename support broken in Windows
  30. Detecting computer/program shutdown in Python?

Leave a Comment