Turns out the problem had to do with the SET parameters. I used the code below obtained from Here. To determine which options were set in SQL Server Management Studio (where the insert worked). Then placing each of those in an exec prior to my insert statement caused things to work again. I didn’t need … Read more
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 … Read more
1. See information about the SQL server tsql -LH SERVER_IP_ADDRESS locale is “C” locale charset is “646” ServerName TITAN InstanceName MSSQLSERVER IsClustered No Version 8.00.194 tcp 1433 np \\TITAN\pipe\sql\query 2. Set your freetds.conf tsql -C freetds.conf directory: /usr/local/etc [TITAN] host = SERVER_IP_ADDRESS port = 1433 tds version = 7.2 3 Try tsql -S TITAN -U … Read more
I had a similar problem and tried all settings i could find on the web – in vain. In my case the problem was the configuration of FreeTDS itself. On Linux the file is /etc/freetds/freetds.conf I had to change the Version to 7.0 (maybe other numbers work, too. i just tried 7.0) [global] # TDS … Read more