cursor.execute in python for SQL

Question

I need the script to monitor the sql server expiration from linux by python code and

In SQL output is coming but in linux, it gives the following error:

>>> cursor.execute("select loginproperty('tibbr_db','DaysUntilExpiration')") Traceback (most recent call last): File "<stdin>", line 1, in <module> pyodbc.Error: ('ODBC data type -150 is not supported. Cannot read column .', 'HY000')

Bryan · Accepted Answer · 2014-11-18 14:23:36Z

Explicitly cast the LOGINPROPERTY return value to an integer to work around the data type mapping problem by changing the query from this:

"select loginproperty('tibbr_db','DaysUntilExpiration')"

to this:

"select cast(loginproperty('tibbr_db','DaysUntilExpiration') as integer)"

The DaysUntilExpiration property in SQL Server should always return an integer, so you won't see any type errors with the explicit conversion.

ODBC type -150 looks like a SQL Server variant type, which pyodbc doesn't map to a python type.

@user3311501 it is polite to mark this as the correct answer if indeed it fixed the problem. :)
If you're using FreeTDS, I'd recommend having a look at this driver instead if you're using SQL Server; it is much more feature complete and performant: microsoft.com/en-us/download/details.aspx?id=36437

Collectives™ on Stack Overflow

cursor.execute in python for SQL

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related