Advertisement
Guest User

Untitled

a guest
May 15th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. #!/usr/bin/python3
  2. def sqlServerConnect(driverType,pip, pdbname, pusername="", ppwd=""):
  3. from pyodbc import connect
  4. try:
  5. #trying to create a cnnection
  6. connection = connect(driver=driverType, host=pip, database=pdbname, user=pusername,password=ppwd)
  7. print("Connection successful : "+driverType+" "+pip+" "+" "+pdbname+" "+pusername)
  8. return connection
  9. except Exception as e:
  10. #connection creation failed
  11. print(e)
  12. return None
  13.  
  14. sqlServerConnect('{ODBC Driver 13 for SQL Server}','server_name/ip','databse_name','username','password')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement