1、连接sql server:
conn_info = 'DRIVER={SQL Server};DATABASE=%s;SERVER=%s;UID=%s;PWD=%s'%(database, host, user, pwd)
self.mssql_conn = pyodbc.connect(conn_info)
self.mssql_cur = self.mssql_conn.cursor()
2、连接mysql
需要安装mysql odbc:http://dev.mysql.com/downloads/connector/odbc/
conn_info = ('Driver={MySQL ODBC 5.1 Driver};Server=%s;Port=%s;Database=%s;User=%s; Password=%s;Option=3;'%(host, port, database, user, pwd ))
self.mysql_conn = pyodbc.connect(conn_info)
self.mysql_cur = self.mysql_conn.cursor()
3、MysqlDB
不需要安装mysql odbc,http://sourceforge.net/projects/mysql-python/
目前linux版本支持到2.7,windows版本支持到2.5。
4、5、linux下pyodbc的安装
需安装unixODBC,Freetds,mysql-connector-odbc
5、linux下pyodbc的使用
pyodbc 不支持在在lin