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
59
votes
10 answers

"Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP

I'm attempting to connect to a SQL Server 2005 DB from my Mac using unixODBC and FreeTDS as I have outlined here. However, when I try to connect in to a different DB using the same setup, I get: Connection Failed:[FreeTDS][SQL Server]Unable to…
wonder95
  • 3,825
  • 8
  • 45
  • 74
32
votes
2 answers

Cross compiling FreeTDS to iPhone

Since this question is unanswered and I spent the majority of a semester figuring it I thought I would post how to Cross compiling FreeTDS 0.91 to iPhone ARMv6, ARMv7 architecture. This was done using Xcode 4.2 and iOS 5 SDK. The reason this…
Tristan
  • 661
  • 9
  • 15
28
votes
5 answers

SqlAlchemy equivalent of pyodbc connect string using FreeTDS

The following works: import pyodbc pyodbc.connect('DRIVER={FreeTDS};Server=my.db.server;Database=mydb;UID=myuser;PWD=mypwd;TDS_Version=8.0;Port=1433;') The following fails: import…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
25
votes
3 answers

How to install freetds in Linux?

I am trying to connect to MSSQL server from Ubuntu. I have installed freetds like suggested here. However, when I try to configure /etc/odbc.ini and enter a driver path I have no driver at location /usr/local/freetds/lib/libtdsodbc.so. Can someone…
Hrvoje T
  • 3,365
  • 4
  • 28
  • 41
23
votes
2 answers

Pypyodbc: Can't open lib 'FreeTDS' : file not found") error when trying to connect to SQL server

I'm trying to connect to a SQL Server using Pypyodbc on Mac and I'm getting the following error: pypyodbc.DatabaseError: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'FreeTDS' : file not found") I have installed freeTDS and…
Mo.
  • 40,243
  • 37
  • 86
  • 131
22
votes
2 answers

PDO with MSSQL driver how to get output parameters?

When you are using PDO with MSSQL driver you actually use FreeTDS as low level driver. There is some different ways to execute stored procedures - language queries and RPC call. FreeTDS also supports TDS protocol version 4.2 and 7.x. The one of main…
Nick Bondarenko
  • 6,211
  • 4
  • 35
  • 56
22
votes
3 answers

FreeTDS working, but ODBC cannot connect

I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC. Using tsql i can connect to the server with ~$ tsql -S dbs3 -U -P No problem there. When I try to connect with isql…
AndMim
  • 550
  • 1
  • 3
  • 11
21
votes
5 answers

freeTDS not using its config

I've decided to use FreeTDS driver and unixODBC to manage the PDO connection between my LAMP-based app with a remote MsSQL database. unfortunately it appears that the driver doesn't read the freetds.conf file, nor the environmental variables set…
khartvin
  • 551
  • 1
  • 7
  • 20
19
votes
8 answers

Getting data with UTF-8 charset from MSSQL server using PHP FreeTDS extension

I can't seem to get data from MSSQL encoded as UTF-8 using FreeTDS extension. Connecting: ini_set('mssql.charset', 'UTF-8'); $this->_resource = mssql_connect($config['servername'], $config['username'], $config['password']); I have no ability to use…
Marius Grigaitis
  • 2,520
  • 3
  • 23
  • 30
18
votes
4 answers

"Invalid parameter type" (numpy.int64) when inserting rows with executemany()

I try to insert bunch of data to database insert_list = [(1,1,1,1,1,1),(2,2,2,2,2,2),(3,3,3,3,3,3),....] #up to 10000 tuples in this list conn = pyodbc.connect('DRIVER={FreeTDS};SERVER=xxxxx;DATABASE=xxxx;UID=xx;PWD=xx;TDS_Version=7.0') cursor =…
YONG BAGJNS
  • 501
  • 2
  • 8
  • 21
17
votes
0 answers

PDO dblib date format different than tsql

I've got a CentOS 7 machine running PHP with webtatic PHP 5.6 and the php56w-mssql package installed. My application is in the Laravel framework connecting to an MSSQL 2012 database. I've modified the locales.conf file so that all it has in it…
Adam
  • 772
  • 3
  • 10
16
votes
3 answers

pyodbc/FreeTDS/unixODBC on Debian Linux: issues with TDS Version

I'm having a bit of trouble successfully using pyodbc on Debian Lenny (5.0.7). Specifically, I appear to be having trouble fetching NVARCHAR values (not a SQL Server expert, so go easy on me :) ). Most traditional queries work OK. For instance, a…
tcdyl
  • 325
  • 2
  • 13
16
votes
5 answers

PDO DBLIB multibyte (chinese) character encoding - SQL server

On a Linux machine, I am using PDO DBLIB to connect to an MSSQL database and insert data in a SQL_Latin1_General_CP1_CI_AS table. The problem is that when I am trying to insert chinese characters (multibyte) they are inserted as…
Manolis
  • 893
  • 1
  • 14
  • 33
16
votes
4 answers

Cannot connect to SQL Server database using pymssql but can connect using underlying freetds tsql

I have no idea why I am getting this error and cannot find any solutions for it. I can connect to a SQL Server database using freetds tsql but I keep getting an error when connecting using pymssql.connect. The specific error…
chewynougat
  • 1,099
  • 2
  • 11
  • 19
15
votes
4 answers

pymssql and Adaptive Server connection failed

When I try to connect into Azure database by Pymssql in python I face this error: pymssql.OperationalError: (20002, 'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (iprice-bi.database.windows.net:1433)\n') I connect to…
Moohebat
  • 455
  • 1
  • 6
  • 15
1
2 3
…
43 44