xxxxxxxxxx
import pyodbc
# Some other example server values are
# server = 'localhost\sqlexpress' # for a named instance
# server = 'myserver,port' # to specify an alternate port
server = 'tcp:myserver.database.windows.net'
database = 'mydb'
username = 'myusername'
password = 'mypassword'
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()
xxxxxxxxxx
import pyodbc
conn = pyodbc.connect('Driver={SQL Server};'
'Server=server_name;'
'Database=database_name;'
'Trusted_Connection=yes;')
cursor = conn.cursor()
cursor.execute('SELECT * FROM table_name')
for i in cursor:
print(i)
xxxxxxxxxx
conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=test;DATABASE=test;UID=user;PWD=password')
xxxxxxxxxx
with pyodbc.connect(conx_string) as conx:
cursor = conx.cursor()
cursor.execute(query)
data = cursor.fetchall()
xxxxxxxxxx
# Create connection. To find driver name on Windows search 'ODBC Data Source' and under Drivers tab \
# there should be 'ODBC Driver 17 for SQL Server' or 'SQL Server'
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=name;DATABASE=name;UID=username;PWD=password')
# Create cursor for further manipulations with SQL
cur = conn.cursor()
# Execute SQL statement. Better use double quotes on all statement and inside single quotes
for rows in cur.execute("SELECT title,score FROM mapondriverbehavior"):
print(rows.column_name, rows.column_name)
# Commit changes if You do changes in database like CREATE, INSERT, ALTER etc. \
# If You use only SELECT statement then dont use commit()
cur.commit()
# Close connection with database
conn.close()