from MSSQL to excel

[kat35601]

I need to create some reports in excel using Python from a MSSQL server query. I do get a file in excel format that has the data I ask for but I also get an error and I am trying to work through it.

import pyodbc
import xlsxwriter
import pandas as pd
from os import environ, lseek

CONNECTION_STRING="""Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.9.so.1.1;
                     Server=server;
                     Database=mydata;
                     UID=youknow;
                     PWD=password;"""
connection = pyodbc.connect(CONNECTION_STRING)
with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'strings_to_numbers': True, 'strings_to_formulas': False}) as writer:
      
        try:
            df = pd.read_sql_query("select top 100 * from salesorders where ompclosed!=-1",connection)
            df.to_excel(writer,sheet_name="Sheet1", header=True , index =False)
            print("File saved successfully")

        except:
            print("There is an error")

I get this error message

Error:
FutureWarning: Use of **kwargs is deprecated, use engine_kwargs instead.
  with pd.ExcelWriter("Output.xlsx", engine="xlsxwriter", options = {'strings_to_numbers': True, 'strings_to_formulas': False}) as writer:
/usr/local/lib/python3.8/dist-packages/pandas/io/sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy

what should the connection look like?

[buran]

These are actually 2 separate warnings (not errors).
Check https://stackoverflow.com/a/71144442/4046632
For the second one:
check https://github.com/pandas-dev/pandas/issues/45660 and https://stackoverflow.com/q/71082494/4046632