CODEWITHSUNDEEP
sql-serverartificial-intelligencechatbotlangchainflowise
Buddhika Nelum
Buddhika Nelum

Reputation: 58

SQL Server database connectivity for read data

I have a question regarding database connectivity. I'm attempting to connect my chatbot to a local SQL Server database using "SQL Database Chain" but struggling to establish a successful connection. Despite trying various connection string formats, I haven't had any luck. Could someone guide me on correctly formatting the connection string for this purpose?

I'm using the below connection string for my .NET projects. This is working fine.

Server=BUDDHIKA\\MSSQLSERVER04; Initial Catalog=chatApp; persist security info=True; Integrated Security=SSPI;

Tried below connection strings below with FlowiseAI but had no luck.

mssql+pyodbc://BUDDHIKA\MSSQLSERVER04/ChatApp?driver=ODBC+Driver+17+for+SQL+Server&trusted_connection=yes

mssql+pyodbc://tcp:BUDDHIKA\\MSSQLSERVER04/ChatApp?driver=ODBC+Driver+17+for+SQL+Server&trusted_connection=yes;port=49767

Any help would be greatly appreciated!

enter image description here

Upvotes: 0

Views: 187

Answers (0)

Related Questions