Breaking News: Grepper is joining You.com. Read the official announcement!

connect with pyodbc with statement

Add Answer

Real Rhinoceros answered on June 5, 2020 Popularity 9/10 Helpfulness 4/10

answer connect with pyodbc with statement

related pyodbc connect to sql server

related pyodbc connect

related Pyodbc connect

connect with pyodbc with statement

Comment

with pyodbc.connect(conx_string) as conx:
    cursor = conx.cursor()
    cursor.execute(query)
    data = cursor.fetchall()

Popularity 9/10 Helpfulness 4/10 Language python

Source: nbviewer.jupyter.org

Tags: connect pyodbc python with-statement

Link to this answer
Share Copy Link

Contributed on Apr 21 2021

Real Rhinoceros

0 Answers Avg Quality 2/10

Closely Related Answers

pyodbc connect to sql server

Comment

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()

Popularity 10/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on Jun 05 2020

Poised Penguin

0 Answers Avg Quality 2/10

pyodbc connect

Comment

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)

Popularity 9/10 Helpfulness 7/10 Language python

Source: datatofish.com

Tags: connect

Link to this answer
Share Copy Link

Contributed on Mar 28 2022

Active Programmer

0 Answers Avg Quality 2/10

Pyodbc connect

Comment

# 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()

Popularity 8/10 Helpfulness 4/10 Language python

Source: github.com

Tags: connect pyodbc p

Link to this answer
Share Copy Link

Contributed on Feb 14 2023

Bright Baboon

0 Answers Avg Quality 2/10

connect with pyodbc with statement

Contents

More Related Answers

connect with pyodbc with statement

Closely Related Answers

pyodbc connect to sql server

pyodbc connect

Pyodbc connect

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.