How do I increase the timeout when running a query using TDS?

Questions / Help
,
1

I am using the TDS driver (GitHub - livehelpnow/tds: TDS Driver for Elixir) to make database calls to a legacy MsSql server. Everything works fine for a small set, but as soon as the tables get bigger (there is 20 years of data in here), I get time outs like:

[error] Tds.Protocol (#PID<0.722.0>) disconnected: ** (DBConnection.ConnectionError) client #PID<0.702.0> timed out because it queued and checked out the connection for longer than 15000ms

is there somewhere I can adjust that timeout?

Thanks!

2

Should work with config parameters see source here : tds/tds.ex at 36f228275c2bfde2baa45fe70d29d1eb1d44379b · livehelpnow/tds · GitHub

3

hmm… i tried that… but it didn’t seem to have an effect. i am wondering if it’s on the server side.

Thanks!