Dog's Life 2.0

錯誤訊息大約長這樣:

2023-01-13 13:16:51,303  [XXXXX] - ERROR - File "src\pymssql\_pymssql.pyx", line 652, in pymssql._pymssql.connect: [OperationalError] (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (localhost)\nNet-Lib error during Unknown error (10061)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (localhost)\nNet-Lib error during Unknown error (10061)\n')

後來才發現, 原來 SQL Server Express 的 default TCP port 居然不是 1433

程式碼改一下, 加入 port

conn = pymssql.connect("localhost:5618", user="myuser", password="myuser456", database = "XXXXXX")

懶得改成1433. 因為是裝在我筆電上的測試用DB.

以上. 記一下.