| 12345678910111213 |
- from sqlalchemy import create_engine
- from pyodbc import *
- import urllib.parse
- import configparser
- #Read Config file
- config = configparser.ConfigParser()
- config.read('merData_db.conf')
- db_string = 'mssql+pyodbc:///?odbc_connect=' + urllib.parse.quote('DRIVER=FreeTDS;SERVER=%s;PORT=1433;DATABASE=%s;UID=%s;PWD=%s;TDS_Version=7.3;'.format(config.get('DB','SERVER'), config.get('DB', 'DATABASE'), config.get('DB','UID'), config.get('DB','PWD')))
- e = create_engine('mssql+pyodbc:///?odbc_connect=' + urllib.parse.quote('DRIVER=FreeTDS;SERVER=192.168.98.45;PORT=1433;DATABASE=CAP_TABLEAU_TEST;UID=test;PWD=test;TDS_Version=7.3;'))
|
