Connect to SQL server with TCP protocol

Questions / Help
, , ,
1

Hello,

I want to connect to SQL server using TCP protocol.
I tried Tds, it does not seem to be supporting properly.
mssqlex is not compatible with my current dependencies.

Please let me know, if anybody have connected to SQL over TCP protocol using Tds.

Thanks,
Santosh

2

Can you please share the error, tds version, and your dbms name and version?

1 Like
3

Hi,

Error is

** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 10044ms. This means requests are coming in and your connection pool cannot serve them fast enough. You can address this by:

  1. Ensuring your database is available and that you can connect to it
  2. Tracking down slow queries and making sure they are running fast enough
  3. Increasing the pool_size (although this increases resource consumption)
  4. Allowing requests to wait longer by increasing :queue_target and :queue_interval

See DBConnection.start_link/2 for more information

Tds I am using GitHub - elixir-ecto/tds: TDS Driver for Elixir
Dbms: Remote Microsoft SQL server

The same connection is working via pymssql in Python.
Also, if I execute python script in Elixir using “erlport”, it is working fine.

Thanks