Как подключиться к базе данных с использованием pyodbc?

1

pip install pyodbc

1
2
3
4
5
6
7
8
9

import pyodbc

conn = pyodbc.connect(
    "Driver={SQL Server Native Client 11.0};"
    "Server=server_name;"
    "Database=database_name;"
    "UID=username;"
    "PWD=password;"
)

1

cursor = conn.cursor()

1
2
3
4
5

cursor.execute("SELECT * FROM table_name")
rows = cursor.fetchall()

for row in rows:
    print(row)

1

conn.close()

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

import pyodbc

conn = pyodbc.connect(
    "Driver={SQL Server Native Client 11.0};"
    "Server=server_name;"
    "Database=database_name;"
    "UID=username;"
    "PWD=password;"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM table_name")
rows = cursor.fetchall()

for row in rows:
    print(row)

conn.close()