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
4
votes
1 answer

Error: "Cannot perform a backup or restore operation within a transaction." when trying to backup MSSQL database using pyodbc and freetds

I'm currently running into some problems when I'm trying to backup a MSSQL database from a Linux host using pyodbc and freetds. The versions are as follows: Python 2.7.6, pyodbc 3.0.7, freetds 0.91-2, Centos 6.5 The code I'm running are as follows…
Swedish Mike
  • 583
  • 1
  • 8
  • 23
4
votes
0 answers

Apache 2.4.7 on Ubuntu 14.04 will not connect to MSSQL through PHP 5.5

I am trying to connect to a remote MSSQL server using the platforms listed in the title. I have FreeTDS and all the relevant ODBC packages installed. Here is my freetds.conf: # $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $ # # This…
CanadaGoose
  • 41
  • 3
4
votes
1 answer

Data quantity issues when querying data from SQL Server using a PostgreSQL foreign data wrapper

Someone set up a server at my workplace that allows our Postgres servers to pull data from our MS SQL servers using a foreign data wrapper, with something like this: https://github.com/GeoffMontee/tds_fdw It's working pretty cool, until we try to…
Hunter Beast
  • 782
  • 7
  • 17
4
votes
0 answers

ubuntu php with freetds connecting to mssql on another system

I am using Ubuntu 14.04 and i have installed freetds and odbc taking guidance from this link : http://www.bictor.com/2014/05/13/configure-unixodbc-for-ubuntu-14-04-using-freetds/ The database i am trying to connect to is on another system (mssql…
user3790233
  • 151
  • 1
  • 7
4
votes
2 answers

pdo dblib on centos 6.x

I am trying to install dblib on CentOS release 6.5 (Final) 64bit. centos 6 does not have freetds so I had to get freetds from elsewhere. freetds-devel-0.91-2.1.x86_64.rpm. using pecl to download and instal PDO DBLIB but i get stuck at make. the…
shorif2000
  • 2,582
  • 12
  • 65
  • 137
4
votes
1 answer

configuring iodbc to use FreeTDS for MS SQL Server under cygwin

I'm trying to use RODBC to make a connection to a SQL Server database from R under cygwin. I've installed libiobbc and libiodbc-devel, which I understand provide the driver manager that the RODBC package needs. I installed freetds, which I…
mac
  • 3,137
  • 1
  • 28
  • 42
4
votes
1 answer

How to connect to MS SQL in Rails

I am attempting to migrate legacy data from a MS SQL database into my Rails Application. I have added configuration in freetds which is connecting properly. In my Gemfile, I have added the tiny_tds and activerecord-sqlserver-adapter, respectively. I…
Drew
  • 2,601
  • 6
  • 42
  • 65
4
votes
0 answers

mssql_bind in PHP truncates string

I'm using FreeTDS to connect and work with a SQL Server 2008 database from PHP 5.3.15 on Linux. I have a column in this database that has a datatype of VARCHAR(MAX). Unfortunately, I'm having trouble setting the value of the column via mssql_bind()…
tptcat
  • 3,894
  • 2
  • 32
  • 51
4
votes
1 answer

"USE statement is not supported to switch between databases" when running query

I get the following error when trying to select a database with php's standard mssql_select_db function: USE statement is not supported to switch between databases. Use a new connection to connect to a different Database. (severity 16). So i'm…
camelCaseD
  • 2,483
  • 5
  • 29
  • 44
4
votes
1 answer

FreeTDS error in PHP: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect

I have to connect to a MSSQL server from Arch Linux with ODBC. I use FreeTDS, and with isql, it's working: isql sqlexpress dev Dev But not in PHP. I use PHP in interactive mode: PHP > $conn = odbc_connect("sqlexpress", 'dev', 'Dev'); PHP >…
LMate
  • 55
  • 1
  • 6
4
votes
1 answer

Perl/DBI/FreeTDS/SQLAzure Some inserts ignored

I've got an intermittent problem with Perl using DBI and FreeTDS (on Ubuntu) to insert some data into SQL Azure. The problem may occur and some rows ignored and then I can just run it again without a problem. Script: print "Importing File $file: to…
Cade Roux
  • 88,164
  • 40
  • 182
  • 265
4
votes
3 answers

Issue with returning Cyrillic symbols from MSSQL via unixODBC and FreeTDS

I'm using django-pyodbc as database backend on Ubuntu 12.04 LTS and MSSQL 2008 on remote host. It works good except of returning Cyrillic symbols. Instead of them I see question marks - '?'. I have begin investigation what could cause this…
sunprophit
  • 1,639
  • 4
  • 16
  • 39
4
votes
1 answer

connection to ms sql 2005 from php using freetds on centos

I am having a problem connecting to MS SQL 2005 from PHP. I am able to connect from the shell, using... tsql -S 10.0.0.134 -p 1433 -U gareth Entering a simple query works as expected... 1> SELECT @@VERSION AS MSSQL_VERSION 2> go MSSQL_VERSION …
garethcl
  • 275
  • 3
  • 8
4
votes
1 answer

UnicodeDecodeError when using pymssql with freetds

I want to get a field in SQL server 2008 from python 2.6. Here is my freeTDS .conf file: [ARGSERVER03] host = 192.168.1.3 port = 1433 tds version = 7.0 Here is the code: conn = pymssql.connect(host='192.168.1.3', user='****',…
Majid Azimi
  • 5,575
  • 13
  • 64
  • 113
3
votes
3 answers

Using alternate unixODBC installation

I'm working in an environment that has unixODBC installed on a org-wide centrally mounted drive, but we (the actual developers) aren't allowed to install drivers or datasources in it. It's all backwards but I have to live with it. Right now I'm…
matrix10657
  • 503
  • 4
  • 10
1 2 3
…
43 44