python sqlserver2014_问下牛人们，python使用pymysql连接sqlserver2014异常？试过很多办法?...

你搞错了吧,不是pymysql，应该是用pymssql, pymysql 是支持mysql的第三方库。

pip install pymssql

from os import getenv

import pymssql

server = getenv("PYMSSQL_TEST_SERVER")

user = getenv("PYMSSQL_TEST_USERNAME")

password = getenv("PYMSSQL_TEST_PASSWORD")

conn = pymssql.connect(server, user, password, "tempdb")

cursor = conn.cursor()

cursor.execute("""

IF OBJECT_ID('persons', 'U') IS NOT NULL

DROP TABLE persons

CREATE TABLE persons (

id INT NOT NULL,

name VARCHAR(100),

salesrep VARCHAR(100),

PRIMARY KEY(id)

)

""")

cursor.executemany(

"INSERT INTO persons VALUES (%d, %s, %s)",

[(1, 'John Smith', 'John Doe'),

(2, 'Jane Doe', 'Joe Dog'),

(3, 'Mike T.', 'Sarah H.')])

# you must call commit() to persist your data if you don't set autocommit to True

conn.commit()

cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')

row = cursor.fetchone()

while row:

print("ID=%d, Name=%s" % (row[0], row[1]))

row = cursor.fetchone()

conn.close()