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;'))