Advertisement
Guest User

Untitled

a guest
Oct 4th, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.60 KB | None | 0 0
  1. from sqlalchemy import create_engine
  2. from sqlalchemy.engine.url import URL
  3. from sqlalchemy.ext.declarative import declarative_base
  4. from sqlalchemy.orm import sessionmaker
  5.  
  6.  
  7. # pymssql can be installed via pip.
  8. conn_url = URL(drivername='mssql+pymssql',
  9.             username='divinems',
  10.             password='Divine2017',
  11.             host='182.48.72.70',
  12.             port=1433,
  13.             database='accounting',
  14.             query=None)
  15. engine = create_engine(conn_url, echo=True, pool_pre_ping=True)
  16.  
  17. try:
  18.     engine.connect()
  19.     print("Connected successfully.")
  20. except Exception as e:
  21.     print(e)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement