reprinted
Db-lib error message 20002, severity 9
complete error response: 20002, b ‘db-lib error message 20002, severity 9:\nAdaptive Server connection failed (i0.185.43.12:1433)\n ‘
Problem description:
In Python, using PSMSSQL to connect to a remote database, error reported. It is no problem to connect the remote machine through other machines, and it is also no problem to connect the remote machine with other tools (SQLCMD, Naticat, etc.) on my own machine, and locate the problem in the use of PyMSSQL library on this machine
Solutions:
Specify charset=”CP936″ at each pymssql.connect
conn = pymssql.connect(host='localhost',server='.',user='sa',password='XXXX', database='aaa',charset="CP936")
Read More:
- A PHP Error was encountered Severity: Warning Message: mysqli::real_connect(): Headers and client
- PHP under linux uses pdo-dblib to connect to mssql to report an error solution. Error message: SQLSTATE[01002] Adaptive Server connection failed (severity 9)
- Error: 7884, Severity: 20, State: 1
- There is a solution to the problem: severity = corrected, type = physical layer, id = 00e5 or id = 00e8 (receiver ID) under Ubuntu
- windows live mail error message
- [Solved] ERROR: commit 60acc70: missing Change-Id in message footer
- ‘Conversion failed when converting date and/or time from character string.DB-Lib error message 241,
- Transport (VMDB) error -44: Message.
- VirtualBox problem solving set -[drm:vmw_host_log [vmwgfx]] *ERROR* Failed to send host log message
- The solution of this. $message is not a function
- Springmvc response. Senderror() custom message prompt
- Vue: How to prompt this .$message
- Flume receives an error when a single message is too large
- errorCode: 500, msg: , result: {“Message”:”There was an error processing the request
- Java uses Netease mailbox 163 to send an error message
- [Solved] The error message of the persistent file is not configured
- Installation failed with message Invalid File
- Error message caused by browser plug-in
- Installation failed with message Invalid File:
- !!!! You must write Log Message,at least 5 characters. Commit aborted !!!!