26 lines
491 B
Markdown
26 lines
491 B
Markdown
# README
|
|
|
|
## requirements
|
|
|
|
python 3.13 or something
|
|
mssql server
|
|
install pip install pyodbc
|
|
|
|
|
|
|
|
check if odbc 17 (or other version)
|
|
on windows search for odbc data sources.
|
|
go to the menu point drivers.
|
|
There should odbc driver 17 for mssql server or something like that
|
|
|
|
## common pitfalls
|
|
always close connections
|
|
use with statement (preferred) or try -> finally
|
|
sql injections
|
|
use parameterized queries
|
|
poor exception handling
|
|
log errors, use finally blocks, use tx, use AD
|
|
|
|
|
|
|