Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python3
- def sqlServerConnect(driverType,pip, pdbname, pusername="", ppwd=""):
- from pyodbc import connect
- try:
- #trying to create a cnnection
- connection = connect(driver=driverType, host=pip, database=pdbname, user=pusername,password=ppwd)
- print("Connection successful : "+driverType+" "+pip+" "+" "+pdbname+" "+pusername)
- return connection
- except Exception as e:
- #connection creation failed
- print(e)
- return None
- sqlServerConnect('{ODBC Driver 13 for SQL Server}','server_name/ip','databse_name','username','password')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement