freeTDS not using its config

by

I spent a long time today debugging a similar problem. I had set “TDS version” in freetds.conf but it was not being used in my ODBC connection. After reading the freetds source code (connectparams.c:odbc_parse_connect_string) I discovered that:

  • If your connection string uses “SERVER=” then both freetds.conf and odbc.ini are ignored
  • If your connection string uses “SERVERNAME=” then the settings in the appropriate freetds.conf server are used
  • If your connection string uses “DSN=” then the settings in the appropriate odbc.ini DSN are used

odbcinst.ini is a red herring. FreeTDS never checks that for settings.

The settings you specify in the connection string are always respected. It also always respects the environment variables like TDSVER.

More Related Contents:

  1. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  2. Where clause not working in sql server
  3. Compare the values of column in SQL Server
  4. T-SQL stored procedure that accepts multiple Id values
  5. How do I escape a percentage sign in T-SQL?
  6. Get list of databases from SQL Server
  7. SqlServer: Login failed for user
  8. SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
  9. SQL Update with row_number()
  10. Calendar table for Data Warehouse
  11. SQL Server default character encoding
  12. SQL Server error on update command – “A severe error occurred on the current command”
  13. Recursive sum in tree structure
  14. SQL Server SP – Pass parameter for “IN” array list?
  15. Why the SQL Server ignore the empty space at the end automatically?
  16. Add default value of datetime field in SQL Server to a timestamp
  17. SQL server schema and default schema
  18. SQL to find first non-numeric character in a string
  19. How to decrypt a password from SQL server?
  20. How to get the 1st value before delimiter in sql server
  21. What are the advantages of VistaDB
  22. How to pivot unknown number of columns & no aggregate in SQL Server?
  23. How to wait for 2 seconds?
  24. Can I have a foreign key referencing a column in a view in SQL Server?
  25. 7645 Null or empty full-text predicate
  26. SQL Server backup/restore vs. detach/attach
  27. What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions
  28. Error converting data types when importing from Excel to SQL Server 2008
  29. EAV over SQL Server
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment