(1) 配置FreeTDS。 /etc/freetds/freetds.conf
Description = Odbc connection via FreeTDS Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so Description = FreeTDS ODBC driver for MSSQL Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so strconn= 'DRIVER={SQL Server};SERVER=.;DATABASE=test;UID=sa;PWD=sa'
db = pyodbc.connect(strconn)
sql = '.....................'
存储过程调用：c.execute("{call sp_MemberAdrInsert_py (?,?,?,?,?,?,?,?,?,?)}", ('a','b','c','d','e','f','g','h','100086',0))
1、存储过程可以直接返回值，如果返回一个值，那么存储过程里必须有：SET NOCOUNT ON
Welcome to Python world! I have a contract in this world! How about you?