Question 103836 in Azure Question posted in
The official documentation to get you started can be found here.

How to connect to Azure sql database through python anaconda jupyter

I am trying to connect to azure sql database through Jupyter notebook and later to load the data into excel/csv .I have the details of server and database only .Username & password i think by default its taking my desktop credentials(unsure).

Here is tried code

import pyodbc 
cnxn = pyodbc.connect(Server=myserver;Database=mydatabase)
Tags:

2

Answers


  1. 0

    In order to connect to your Azure SQL database with your jupyter notebook use the following:

    import pyodbc

server = 'tcp:SQLSERVER.database.windows.net' # Server example
database = '<INSERT DATABASE NAME>' 
username = '<INSERT USERNAME>' 
password = '<INSER PASSWORD>' 
driver= '{ODBC Driver 17 for SQL Server}' # Driver example
connection= pyodbc.connect('DRIVER=' + driver + ';SERVER=' +server + ';PORT=1433;DATABASE=' + database +';UID=' + username + ';PWD=' + password)

cursor = connection.cursor() # Just something you can do
print(connection)
connection.close()

    For more details you can refer to the following links:

    1. Connect to Azure SQL Database using Python and Jupyter Notebook
    2. Connect to Azure SQL Database in a Jupyter Notebook using Python
    3. Quickstart: Use Python to query a database
    Login or Signup to reply.
  2. 0

    You need to give username, password of the Azure SQL database in connextion. Below is the code to establish connection of Azure SQl database using python in Jupyter Notebook.

    import pyodbc
# Establish the connection
server =  'xxxxx.database.windows.net'
database =  'xxx'
username =  'xxxx'
password =  'xxxx'
driver=  '{ODBC Driver 17 for SQL Server}'
conn = pyodbc.connect('DRIVER='  + driver +  ';SERVER='  +
server +  ';PORT=1433;DATABASE='  + database +
';UID='  + username +  ';PWD='  + password)
print(conn)
conn.close()

    enter image description here

    Reference: Use Python to query a database – Azure SQL Database & SQL Managed Instance | Microsoft Learn

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search