No way to change FreeTDS protocol version

[qgib]

Author Name: Evgeniy Nikulin (Evgeniy Nikulin)
Original Redmine Issue: 6263

Redmine category:data_provider/mssql
Assignee: Tamas Szekeres

---

FreeTDS drive is used by default when create new MSSQL connection under Linux and DSN not using.
But you can not choose the version of the protocol to be used for communication.
May be the connection form under Linux can have an extra field "Protocol version"?

[qgib]

Author Name: Tamas Szekeres (@szekerest)

---

Did you mean the TDS_Version setting?
Custom settings can be specified in the Provider/DSN textbox (separated with semicolons) which is used as part of the ODBC connection string. Wouldn't that be sufficient in this case?

[qgib]

Author Name: Evgeniy Nikulin (Evgeniy Nikulin)

---

Yes, its TDS_Version setting.
If I try to specify in Provider/DSN textbox custom settings, I shoud to specify full connection string:

driver=FreeTDS;TDS_Version=8.0;port=1433;server=192.168.0.1;database=my_db;

In this case, the server and database fields do not work. Imho this is not user-friendly.
I agree with you, the TDS_Version must be specified in Provider/DSN textbox. But why not simply specify:

driver=FreeTDS;TDS_Version=8.0;

?

[qgib]

Author Name: Tamas Szekeres (@szekerest)

---

Fixed in changeset "c322cd52cf82afeb10beefa6efa42da2bdcea46f".

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Tamas Szekeres (@szekerest)

---

Tamas Szekeres wrote:

Fixed in changeset "c322cd52cf82afeb10beefa6efa42da2bdcea46f".

This change should eliminate the requirement to specify the full connection string if the driver setting is present