Dec-06-2023, 08:26 AM
Thanks for helping to add the tag.
I tried with and without f also same.
I assume f is formatting only and yes, username/password/etc are all string
I tried with and without f also same.
I assume f is formatting only and yes, username/password/etc are all string
(Dec-06-2023, 08:09 AM)buran Wrote: Shouldn't be an f-string?
engine = create_engine(f'mssql+pyodbc://{username}:{password}@{server}/{database}?driver=ODBC+Driver+17+for+SQL+Server&connect_timeout=30')That is assumingusername
,password
,server
anddatabase
used are actually names