# Database Connection
# MSSQL Connection
config=configparser.ConfigParser()
with open (PARAMETER_PATH,"r") as db_conn:
config.readfp(db_conn)
SOURCE_DB_HOST=config.get("SQL Server Connection Setting","host").strip('\r\n\t')
SOURCE_DB_USER=config.get("SQL Server Connection Setting","user").strip('\r\n\t')
SOURCE_DB_PWD=config.get("SQL Server Connection Setting","pwd").strip('\r\n\t')
SOURCE_DB_INSTANCE=config.get("SQL Server Connection Setting","db").strip('\r\n\t')
print(SOURCE_DB_HOST,SOURCE_DB_USER,SOURCE_DB_PWD,SOURCE_DB_INSTANCE)
ms = MSSQL(SOURCE_DB_HOST,SOURCE_DB_USER,SOURCE_DB_PWD,SOURCE_DB_INSTANCE)
print (ms)
ms2 = MSSQL("SHAITUTIL01\\SQLEXPRESS","PCLC0\\etang","^yhn7ujm","Private_DB_Edwin")
print (ms2)
reslist = ms2.ExecQuery("select top 1 * from test_1")
for i in reslist:
print(i)
reslist = ms.ExecQuery("select top 1 * from test_1")
for i in reslist:
print(i)
输出结果是这样的
"SHAITUTIL01\\SQLEXPRESS" "PCLC0\\etang" "^yhn7ujm" "Private_DB_Edwin"
(1000001, 'VIP10001', '??', 'MARGARETA', '?', '??MARGARETA?', 'F', 'Aug 22 2017 5:43PM', 34, datetime.datetime(2014, 4, 15, 17, 27), 'Y ', 1000788, 1000764, datetime.datetime(2014, 4, 15, 17, 34, 29, 67000), datetime.datetime(2014, 4, 15, 17, 34, 29, 67000))
下面就报错了