Langchain NL2SQL Streamlit Chatbot MySQL to MSSQL #7
Description
I've converted this to Microsoft SQL Server database and query. Often times after one to two successful responses, I will eventually get the following message. I am wondering if there may be someone in code that still references MySQL that should be changed to use the Microsoft SQL Server:
The error message indicates that there is an issue with the syntax of the SQL query. Specifically, it mentions an incorrect syntax near the backtick character (`). However, the provided query does not contain any backticks, which suggests that the error might be related to how the query was executed or formatted in the environment.
To resolve this issue, ensure that the query is correctly formatted and executed in the SQL Server environment. Here is the corrected query without any backticks:
SELECT [Promised_Date]
FROM [Delivery]
WHERE [Job] = '447316';
As you can see, it does provide the proper MS SQL syntax, but does not execute it.
The database info from langsmith:
