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
7
votes
5 answers

FreeTDS fails to connect to SQL Server after recent Windows patches and TLS1 being disabled

I'm having a weird problem with FreeTDS (MacOS 10.11.5) not connecting to SQL Server 2014 running on Windows Server 2012 r2 which I had been able to connect to previously (about a week or so ago). The server in the last week has been going through…
Peter Hanley
  • 1,254
  • 1
  • 11
  • 19
7
votes
2 answers

Character set mismatch on Linux with ODBC to SQL Server

I've got a funny issue trying to insert non-ASCII characters into a SQL Server database, using the Microsoft ODBC driver for Linux. The problem is it seems to be assuming different character sets when sending and receiving data. For info, the…
asc99c
  • 3,815
  • 3
  • 31
  • 54
7
votes
1 answer

How to use windows authentication to connect to MS SQL server from windows workstation in another domain with Python

I'm trying to connect to SQL server 2000 installed on Windows server 2003 from Windows Server 2008 R2 using Python 3.4 and pyodbc module. Those servers are in different AD domains. Windows only authentication is enabled on SQL server and I can't…
Andrey Grachev
  • 1,259
  • 1
  • 14
  • 22
7
votes
1 answer

sql server function native parameter bind error

I'm using the following software stack on Ubuntu 10.04 Lucid LTS to connect to a database: python 2.6.5 (ubuntu package) pyodbc git trunk commit eb545758079a743b2e809e2e219c8848bc6256b2 unixodbc 2.2.11 (ubuntu package) freetds 0.82 (ubuntu…
nosklo
  • 217,122
  • 57
  • 293
  • 297
7
votes
2 answers

php dblib, Error: SQLSTATE[HY000] Unknown host machine name (severity 2)

I am using mac computer OSX 10.9. Freetds and unixODBC are already installed on my computer and added as extension to php , trying to connect to a remote MSSQL server. Below is my connection testing:
na83
  • 111
  • 2
  • 8
7
votes
3 answers

Laravel connect to a SQL Server 2008 named instance

I am trying to connect an SQL server from an Ubuntu machine, everythings works great except for named instances: this works 'data' => array( 'driver' => 'sqlsrv', 'host' => 'xxxx', 'port' => 1433, …
kitensei
  • 2,510
  • 2
  • 42
  • 68
7
votes
1 answer

Restart of anything needed after changes to freetds.conf?

After changing the freetds.conf file, do I need to restart anything to see the changes in running ODBC queries from PHP?
weotch
  • 5,788
  • 6
  • 35
  • 42
7
votes
2 answers

One of the SELECT fails using unixOdbc - SQLSTATE[24000]: Invalid cursor state

I am running Ubuntu 13.10 with FreeTDS and ODBC (package: php5-odbc) installed. I use tds version = 8.0, but also tried tds version = 7.2. I am using PDO and this is my DSN: $dsn = sprintf('odbc:Driver=FreeTDS;Server=%s;Port=1433;Database=%s',…
Tom Raganowicz
  • 2,169
  • 5
  • 27
  • 41
7
votes
3 answers

SQL Server error 1934 occurs on INSERT to table with computed column PHP/PDO

After adding a computed column to a table in SQL Server 2005 I am getting the following message on INSERT, only via PHP (using PDO) it's working fine in SQL Server Managment Studio. To ensure I had everything correct I setup a trace with SQL…
kackleyjm
  • 595
  • 1
  • 5
  • 12
7
votes
4 answers

Error installing TinyTDS on OSX 10.6 via gem install tiny_tds

I have been trying to install the TinyTDS gem on a Macbook with OSX 10.6. I was successful in installing Free TDS -- confirmed that it works via: tsql -H SERVER -p 1433 -U username. The error I'm getting from gem install tiny_tds is: Building…
Jaypoc
  • 73
  • 1
  • 6
7
votes
3 answers

using pyodbc on ubuntu to insert a image field on SQL Server

I am using Ubuntu 9.04 I have installed the following package versions: unixodbc and unixodbc-dev: 2.2.11-16build3 tdsodbc: 0.82-4 libsybdb5: 0.82-4 freetds-common and freetds-dev: 0.82-4 python2.6-dev I have configured /etc/unixodbc.ini like…
nosklo
  • 217,122
  • 57
  • 293
  • 297
6
votes
1 answer

FreeTDS - tsql connects, isql fails

I'm trying to connect to a database on my host machine (windows xp, sql server 05). My guest machine is Ubuntu 10.04. I can connect and execute commands with tsql, but isql fails. Below are my config files and error messages. freetds.conf text…
recursive_acronym
  • 2,981
  • 6
  • 40
  • 59
6
votes
1 answer

Python - Can't open lib 'libtdsodbc.so' : file not found

Any help with this issue is much appreciated. Goal: Connect Django to MSSQL server using FreeTDS. I'm using a Debian x64 box. Problem: When trying to make a connection I get the following. ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib…
Dan Walters
  • 1,218
  • 1
  • 18
  • 30
6
votes
1 answer

General error: 20003 Adaptive Server connection timed out [20003] (severity 6)

Hi Following is error what I am getting:- PDOException: SQLSTATE[HY000]: General error: 20003 Adaptive Server connection timed out [20003] (severity 6) [(null)] in…
vishal-mote
  • 362
  • 2
  • 6
  • 22
6
votes
3 answers

TinyTDS: Server name not found in configuration files

I keep seeing this error, and I am unable to connect to the database on the remote server. I am given a connection string to the database, that looks like the following: data source=qsss.gar.de\SQL2012,3000;initial catalog=City;persist security…
zwiebl
  • 685
  • 2
  • 11
  • 24
1 2 3
…
43 44