How to Connect Langchain Database Agent with SqlServer

kernel_kate

I need to connect my langchain database agent with my sqlserver database so that my agent can access the data, yet in the documention it does not explain how to do so, it only shows how to connect to sqlite like the following code: from langchain.agents import create_sql_agent from langchain.agents.agent_toolkits import SQLDatabaseToolkit from langchain.sql_database import SQLDatabase from langchain.llms.openai import OpenAI from...

Originally asked by Mutasim Al-Mualimi on Stack Exchange (stackoverflow) (CC BY-SA 4.0).

uphilltech

Great question — answering as the UphillTech team:

I've tested this and it seems to be working. uri = 'mssql+pyodbc://DBUsername:DBPassword@ServerName:Port/DBName?driver=ODBC+Driver+17+for+SQL+Server' db = SQLDatabase.from_uri(uri) Ref : https://github.com/langchain-ai/langchain/issues/9804

Full answer by Blu: https://stackoverflow.stackexchange.com/a/77285328 (CC BY-SA 4.0).

Need it done for your business? UphillTech.