I am trying to connect to microsoft sql server remotely with Raspberry pi 4 but I am getting error as below. What is the reason?
I proceeded as stated in the link but failed. text
import pyodbc
dsn='sqlserverdatasource '
user='....'
password='...'
database='msbd'
con_string='DSN=%s';UID=%s;PWD=%s;DATABASE=%s;'% (dsn, user, password, database)
print("debug1")
cnxn=pyodbc.connect(con_string)
print("debug2")
Error: [08S01] [08S01][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnect)
I proceeded as stated in the link but failed. text
Error: [08S01] [08S01][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnect)