I call pymssql, fetchall for table "CDN.Kontrahenci", and where I enter many columns names, as:

"Knt_KntId,Knt_Kod,Knt_Nazwa1,Knt_Nazwa2,Knt_Nazwa3,Knt_Kraj,Knt_Wojewodztwo,Knt_Ulica,Knt_NrDomu,Knt_NrLokalu,Knt_Miasto,Knt_KodPocztowy,Knt_Poczta,Knt_NipE,Knt_Nip,Knt_Regon,Knt_Pesel,Knt_Telefon1,Knt_Telefon2,Knt_Fax,Knt_Email,Knt_URL,Knt_OsKraj,Knt_Opis,Knt_OpeZalID,Knt_OpeModID,Knt_TS_Zal,Knt_TS_Mod"

I have received error:

(20047, b'DB-Lib error message 20047, severity 9:
DBPROCESS is dead or not enabled
')

When I call less amount of columns names, like:

"Knt_KntId,Knt_Kod,Knt_Nazwa1,Knt_Nazwa2,Knt_Nazwa3"

everything is ok.

When I call this table for all column names, like:

sql = "SELECT * FROM CDN.Kontrahenci"

I've received above error as well.
Why is this error. Anyone has an idea?

I was not be able find solution for this problem in the internet and I expected advice about listed error.

0

There are 0 best solutions below