#import pyodbc

# Connection parameters
server_name = 'aglistener'
database_name = 'AdventureWorksLT2022'
username = 'HA'
password = 'pass@123'
# Windows authentication connection string
connection_string = f'DRIVER={{ODBC Driver 17 for SQL Server}};SERVER={server_name};DATABASE={database_name};UID={username};PWD={password};TrustServerCertificate=yes;MultiSubnetFailover=yes'

try:
    # Establishing the connection
    connection = pyodbc.connect(connection_string)

    # Creating a cursor
    cursor = connection.cursor()

    # Example query
    query = "SELECT @@servername"

    # Executing the query
    cursor.execute(query)

    # Fetching the result
    row = cursor.fetchone()

    # Printing the result
    print(f"Server Name: {row[0]}")

except pyodbc.Error as e:
    print(f"Error: {e}")

finally:
    # Closing the connection
    if 'connection' in locals():
        connection.close()