Python 3.x: Error on pyodbc sql server connection "no attribute 'execute"

Question

I keep getting the error: "'builtin_function_or_method' object has no attribute 'execute'" I originally thought the complaint was on the table value function in SQL Server, however, I see that the message points to "execute", so I don't think refcur has execute defined. Here's what my connection string looks like:

    conn = pyodbc.connect("Driver={SQL Server};"
                      "Server=myserver;"
                      "Database=mydatabase;"
                      "Trusted_Connection=yes;"
                      "autocommit=True;")

    refcur = conn.cursor
    sql = "exec myschema.mystoredproc @TVPobject=?"
    refcur.execute(sql,this_object)

I've attached the image to show what I see in intellisense for what's available. Does anyone know why this is happening?

Mureinik · Accepted Answer · 2017-10-12 15:35:39Z

4

you aren't calling cursor, you're just returning a reference to that member function and storing it in refcur. In order to call it (and actually create a cursor), you need to add parenthesis:

refcur = conn.cursor()
# Here -------------^

answered Oct 12, 2017 at 15:35

Mureinik

316k54 gold badges400 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

plditallo Over a year ago

Now this has to be the DUMBEST thing I've ever posted--but I was spending way too much time on it. I didn't even notice the missing parenthesis. I'll leave this posted. I'm sure I am not the only one that has spent (or will spend) time chasing this error for this very reason! :) @Mureinik, thanks so much!

Collectives™ on Stack Overflow

Python 3.x: Error on pyodbc sql server connection "no attribute 'execute"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related