import pyodbc

# Configuración de conexión
server = '172.18.242.153'
database = 'geclisa'
username = 'sa'
password = 'Adams259'

# Cadena de conexión para SQL Server usando FreeTDS
conn_str = (
    'DRIVER={FreeTDS};'
    f'SERVER={server};'
    f'DATABASE={database};'
    f'UID={username};'
    f'PWD={password};'
    'TDS_Version=7.0;'
    'Port=1433;'
)

try:
    conn = pyodbc.connect(conn_str, timeout=5)
    cursor = conn.cursor()
    cursor.execute('SELECT TOP 10 * FROM turnos')
    rows = cursor.fetchall()
    # Mostrar los resultados
    for row in rows:
        print(row)
    cursor.close()
    conn.close()
except Exception as e:
    print(f'Error al conectar o consultar: {e}')