1. ImportError: No module named 'pymssql'
2. pymssql.OperationalError: (20009, 'DB-Lib error message 20009, severity 9:
Unable to connect: Adaptive Server is unavailable or does not exist')
3. pymssql.InterfaceError: Cannot open database requested in login 'database_name'. Login failed.
4. pymssql.ProgrammingError: (102, "Incorrect syntax near 'table_name'.")
python
import pymssql
server = 'database_server_address'
user = 'username'
password = 'password'
database = 'database_name'
conn = pymssql.connect(server=server, user=user, password=password, database=database)
cursor = conn.cursor()
sql = "SELECT * FROM table_name"
cursor.execute(sql)
result = cursor.fetchall()
for row in result:
print(row)
cursor.close()
conn.close()
