Sql database in Fabric

If the ODBC GUI is not working to set up a connection then you may have something else going on.

Some key things are:

1. You need the whole server name but should omit any leading characters, like "tcp:". The ",1433" at the end is optional.
2. You need the whole database name, GUID and all. 
3. Many drivers require the az cli to be installed https://learn.microsoft.com/en-us/cli/azure/install-azure-cli-windows?tabs=azure-cli. Make sure to run an 'az login' after installing it.

Here's a basic python sample that will use the logged in users entra id: 

"""
Connects to a SQL database using pyodbc
"""
import pyodbc

connectionString = f'Driver={{ODBC Driver 18 for SQL Server}};Server=<server>;Database=<database>;Encrypt=yes;TrustServerCertificate=no;Authentication=ActiveDirectoryInteractive'
conn = pyodbc.connect(connectionString)

SQL_QUERY = """
select Opportunity_Number, ProductID, Opportunity_Created_On, Quantity, Comments from Opportunity where Opportunity_number = 'OPP-500'
"""

cursor = conn.cursor()
cursor.execute(SQL_QUERY)

records = cursor.fetchall()
for r in records:
    print(f"{r.Opportunity_Number}\t{r.ProductID}\t{r.Comments}")