Issue with using Microsoft SQL Server

[byzxc]

Bug Description

I am encountering errors when using an MSSQL database with ODBC Driver 18 for SQL Server.

The errors occur because the length of str fields is not specified in the model.py for each table. As a result, every field of type str in the models triggers an error.

Additionally, I am encountering errors because the id fields cannot be of type str or UUIDstr.

Reproduction

Connect to a MSSQL server database and try to run alembic to initialize database.

Expected behavior

Should initialize database successfully

Who can help?

No response

Operating System

Linux 22.0.4

Langflow Version

1.7.1

Python Version

None

Screenshot

No response

Flow File

No response

[AntonioABLima]

Hi @byzxc, did you need to install any additional driver like pymssql or pyodbc? I'm having some trouble trying to connect Langflow to Microsoft SQL Server.

[byzxc]

hello @AntonioABLima, I added pyodbc and aioodbc drivers to connect to Microsoft SQL Server.

[AntonioABLima]

I am still unable to connect. Could you please help me? Maybe share your connection string structure and a step-by-step of any extra configurations needed to connect?

[byzxc]

I'm using this way for database url.
LANGFLOW_DATABASE_URL=mssql+aioodbc://{mssqluser}:{password}@localhost:{port}/{databaseName}?driver=ODBC+Driver+18+for+SQL+Server&TrustServerCertificate=yes&Encrypt=yes

If you are launching the repository through dev container, you might want to add these commands for ensure it install msodbcsql18.

unixodbc
unixodbc-dev
gnupg2
apt-transport-https
&& curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
&& curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list
> /etc/apt/sources.list.d/mssql-release.list
&& apt-get update && ACCEPT_EULA=Y apt-get install -y msodbcsql18 \

Note: my MSSQL is running in a container which I pulled the image from
mcr.microsoft.com/mssql/server:2022-latest