Stack Overflow
Stack Overflow

Questions tagged [freetds]

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.

Website: http://freetds.schemamania.org/

658 questions
15
votes
3 answers

Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu

I'm trying to get MSSQL working on Ubuntu 12.04 via ODBC, and I've followed these steps to the letter: http://jamesrossiter.wordpress.com/2011/03/08/connecting-to-microsoft-sql-server-using-odbc-from-ubuntu-server/ However, this omits both of these…
Michael B
  • 1,743
  • 4
  • 21
  • 35
14
votes
3 answers

FreeTDS connection problems

I'm using FreeTDS 0.91 to connect to a remote MSSQL server but all attempts have borne no fruit thus far. Upon doing a tsql command on my Unix, I get the following error: locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset…
Kamran Khan
  • 453
  • 1
  • 5
  • 19
13
votes
1 answer

Ruby connecting to SQL Server

I'm having troubles connecting Ruby to Microsoft SQL Server. I'm running Mac OS X, but the target environment is Ubuntu Linux. Here's what I've tried: Install unixODBC Install FreeTDS used the options --with-unixodbc=/usr/local/etc…
Ben Scheirman
  • 40,531
  • 21
  • 102
  • 137
13
votes
4 answers

freebcp: "Unicode data is odd byte size for column. Should be even byte size"

This file works fine (UTF-8): $ cat ok.txt 291054 Ţawī Rifā This file causes an error (UTF-8): $ cat bad.txt 291054 Ţawī Rifā‘ Here's the message: $ freebcp 'DB.dbo.table' in bad.txt ... -c Starting copy... Msg 20050, Level 4 Attempt to convert…
Neil McGuigan
  • 46,580
  • 12
  • 123
  • 152
13
votes
7 answers

Failing to bundle install tiny_tds on Mac OS X 10.8 with Homebrew FreeTds

MY QUESTION What are some surefire steps I can take to 100% get this working? I would need real instructions, not one liner answers or vague conceptual descriptions of the process. Let's get to the bottom of this. It would appear that there are…
Joshua F. Rountree
  • 1,462
  • 2
  • 14
  • 30
13
votes
1 answer

What is TDS Protocol Version 8.0 and why should I use it?

I've been using FreeTDS with 8.0 protocol for some time to connect to a MSSQL Database, and things have worked great. But, recently, things started to not work so great. I'll spare the details. So we decided we needed to know a bit more, and I am a…
Derek Litz
  • 10,529
  • 7
  • 43
  • 53
12
votes
1 answer

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

I know this question is asked many times and I have tried all but nothing worked. I am trying to connect to a MSSQL database on a different server from Ubuntu 14.04. Content from /etc/odbcinst.in [ODBC] Trace = No TraceFile = /tmp/odbc.log …
Awais Qarni
  • 17,492
  • 24
  • 75
  • 137
12
votes
3 answers

Can't Install FreeTDS via Yum Package Manager

I tried following the instructions in the article below but it says, "No package freetds available." http://www.hosting.com/support/linux/installing-freetds-for-linux/ This is my I/O: [root@mydomain ~]# yum search freetds Loaded plugins:…
user1477388
  • 20,790
  • 32
  • 144
  • 264
11
votes
1 answer

freeTDS: Missing libtdsodbc.so file on OSX?

I am trying to connect to a SQL server from a python script on a Mac OSX and after installing freeTDS using brew install freeTDS I can't seem to find the driver "libtdsodbc.so" anywhere on my machine so that I can place it in the connection…
Mo.
  • 40,243
  • 37
  • 86
  • 131
11
votes
2 answers

PHP PDO_mssql SQLSTATE[01002] Adaptive Server connection failed (severity 9)

I'm connecting to external MSSQL database for exports from PHP55/osx and I have wierd issue. code: new \PDO("dblib:host={$hostname};dbname={$dbname}", $user, $pass); throws: SQLSTATE[01002] Adaptive Server connection failed (severity 9) but…
Jakub Riedl
  • 1,066
  • 2
  • 10
  • 27
11
votes
2 answers

Go/Golang sql.DB reuse in functions

sql.Open() returns a variable of type *sql.DB I have a function that calls 10 other functions that all need to make database calls Is it more correct/efficient to: Send the *sql.DB pointer to every function, or Create a new *sql.DB object in each…
Allison A
  • 5,575
  • 6
  • 28
  • 32
11
votes
2 answers

Unable to connect: Adaptive Server is unavailable or does not exist

While trying to connect remote SQL Server: $tsql -S localhost -U myuser I got error like: locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" Error 20009 (severity 9): Unable to connect: Adaptive Server is…
Elisa
  • 6,865
  • 11
  • 41
  • 56
10
votes
3 answers

Pymssql Install Error

I'm trying to install FreeTDS using binaries from here, on Windows, but I can't figure out how to install binary files; a google search turned up nothing relevant. I'm installing so that the Python module Pymssql can be imported and used. I'm…
Fricative Melon
  • 369
  • 3
  • 13
10
votes
2 answers

Difference between FreeTDS and unixodbc?

I'm trying to work out how these two pieces of the jigsaw interact and fit together when connecting to an MS-SQL server on linux. As I understand it, FreeTDS is protocol (i.e. a set of rules) for talking to MS-SQL and it is the thing that actually…
fpghost
  • 2,834
  • 4
  • 32
  • 61
10
votes
2 answers

FREETDS and UNIXODBC character converting

ive got an error to fix. its: [FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted when i use turkish characters to insert i get this error. my question is how can i disable that…
Ali Demirci
  • 5,302
  • 7
  • 39
  • 66
1
2
3
…
43 44