pyodbc icon indicating copy to clipboard operation
pyodbc copied to clipboard

pyodbc - error in rowIdColumns cursor call - Sql Server ODBC 18 driver

Open Sandman-76 opened this issue 7 months ago • 0 comments

A call to cursor.rowIdColumns('table_name', None, None, False): passes an empty table name string into the stored proc call on sql server, this doesn't change if I explicitly set the catalog and schema columns

See below exert from the stored proc call in Sql Server profiler:

exec [sys].sp_special_columns_100 N'+',NULL,NULL,N'R',N'T',N'O',@ODBCVer=3

I have no issues with other cursor calls

Sandman-76 avatar Apr 18 '25 22:04 Sandman-76