pyodbc driver 17

AlexGherardelli · AlexGherardelli · commit 144651da2062 · 2026-02-12T14:50:55.000+01:00
diff --git a/datalibrary/load.py b/datalibrary/load.py
@@ -14,7 +14,7 @@
 USERNAME = os.getenv("DB_USERNAME")
 PASSWORD = os.getenv("DB_PASSWORD")
 
-conn_str = f'mssql+pyodbc://{USERNAME}:{PASSWORD}@{SERVER}/{DATABASE}?driver=ODBC+Driver+17+for+SQL+Server'
+conn_str = f'mssql+pyodbc://{USERNAME}:{PASSWORD}@{SERVER}/{DATABASE}?driver=ODBC+Driver+18+for+SQL+Server&Encrypt=yes&TrustServerCertificate=yes'
 engine = create_engine(conn_str)
 
 class ExcelExportError(Exception):
