"Invalid object name" error on INSERT to SQL Server from pyodbc

Question

I am trying to insert some data into a SQL Server database using the pyodbc module.

I have the connection string working.

The following code lists the two columns in the table.

 for row in cursor.columns(table='InvUtil'):
     print (row.column_name)

I see the following two columns that are in the InvUtil table:

server

termss

I then try to insert data with the following command:

 cursor.execute("INSERT INTO InvUtil(server, termss) values (?, ?)", 'ten', 'eleven')

I get the following error. Seems like it's having issues with the InvUtil table name.

Traceback (most recent call last):
  File "SQLpydobc.py", line 61, in <module>
    cursor.execute("INSERT INTO InvUtil(server, termss) values (?, ?)", 'ten', 'eleven')
pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]**Invalid object name 'InvUtil'**. (208) (SQLExecDirectW)")

I expect the script to run without errors. I have a commit command later in the script so should see data in the columns.

Have you tried this

Tech at The Sparks Foundation
– Tech at The Sparks Foundation

2019-06-05 18:31:02 +00:00
Commented Jun 5, 2019 at 18:31 — Tech at The Sparks Foundation
– Tech at The Sparks Foundation, Commented Jun 5, 2019 at 18:31

jspcal · Accepted Answer · 2019-06-05 18:26:52Z

3

Perhaps specify the full table name with schema/db as in dbo.InvUtil?

Or perhaps specify the default database name in the connection string (Database=dbo or InitialCatalog=dbo).

answered Jun 5, 2019 at 18:26

jspcal

52k7 gold badges76 silver badges79 bronze badges

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

1 Comment

Az Cactus Jack Over a year ago

You were correct. The system was defaulting to a different schema. When the table was recreated with the "dbo" schema my python script worked.

Collectives™ on Stack Overflow

"Invalid object name" error on INSERT to SQL Server from pyodbc

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related