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

votes

2 answers

Mac, Rails 4: install `tiny_tds` gem with `freetds`

We're using activerecord-sqlserver-adapter adapter for Rails 4 to talk to a SQL Server DB. This adapter requires the tiny_tds gem. In order to install tiny_tds, you need freetds installed on your system because it's used during the compiling for…

asked Aug 28 '14 at 17:29

Dan L

4,319
5
41
74

votes

1 answer

Reading MS Access database on Debian using FreeTDS

I tried to read ms access data base over the network using this code - cnxn = pyodbc.connect('DRIVER={FreeTDS};DBQ=\\http:\\10.0.0.2\NetworkSharedFolder\Misure.mdb;') cursor = cnxn.cursor() cursor.execute('SELECT Id,Data, Ora, Esito, Res_Esito,…

python linux ms-access freetds unixodbc

asked Aug 18 '14 at 13:49

Inderpal Singh

votes

1 answer

Python-Data truncated and spaces are added between data while inserting into MsSQL

Upon inserting the data into the MS SQL Server DB, my values are getting truncated and single extra space is added in between. For eg:- HomeShop18 is saved as H o m e s. It is truncated as well and space is also included. But when I do select * from…

python sql sql-server freetds

asked Aug 14 '14 at 12:43

Praful Bagai

16,684
50
136
267

votes

1 answer

Cannot install tiny_tds on os.x 10.9.4

I'm trying to install tiny_tds on a mac running OS.X Mavericks but I receive the following error: ERROR: Error installing tiny_tds: ERROR: Failed to build gem native extension. /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/bin/ruby…

ruby macos freetds tiny-tds

asked Jul 24 '14 at 10:49

Marius

3,253
5
25
29

votes

2 answers

Execute sql query using php

I have connected the sql database server using FreeTDS in php. I am trying to execute sql select query in php. I can't able to execute query. I mentioned the program below

php sql freetds ubuntu-14.04

asked Jun 25 '14 at 10:02

Python Team

1,143
4
21
50

votes

1 answer

PHP warning odbc_connect() SQL Error

I just installed an iSeriesODBC-5.1.0-0.16.i386.rpm on my ubuntu linux 12.04 32bit OS. What im trying to do is connect to a DB2 AS400. When I run this code below:

php odbc freetds unixodbc

asked Apr 23 '14 at 12:40

user2720708

votes

0 answers

How to use xampp with MSSQL

I am using xampp on a Linux server. My phpinfo() function says that I have FreeTDS Now when I connect with Yii, its gives me the error: CDbConnection failed to open the DB connection: could not find driver The only thing I installed is xampp…

php sql-server yii xampp freetds

asked Apr 21 '14 at 13:44

Ayman

1,387
4
20
35

votes

1 answer

Connect PHP ( Mac OS ) to MsSQL Server 2008 RC2 connection string format

I am able to connect to MsSQL (Remote PC) with the following command via terminal: TDSVER=8.0 tsql -H 192.168.1.10 -p 1433 -U Derrick -P Friday I need to know how to translate that successful string to a PHP/PDO connection string, Ive…

php sql-server freetds

asked Apr 14 '14 at 16:36

CodeChap

4,132
6
30
40

votes

1 answer

TinyTDS Undefined symbol dbsetluser

I've been struggling for the last couple of days with this issue and I'm out of ideas. I am working on a somewhat out of date application, in which I now need to add support for SQL Server. I have managed to get it to work locally (Ubuntu 12.04),…

ruby ubuntu freetds tiny-tds ruby-enterprise-edition

asked Apr 13 '14 at 05:55

Ruy Diaz

3,084
24
36

votes

1 answer

Binary OID is fetched incorrectly on Linux, FreeTDS and PHP

I'm trying to get linux, php and MSSQL to play well with together. I was able to get it to work for the most part - except that any OID (binary) data types are returned as gibberish UTF-8. For example: string '�"Ή�%�' (length=8) What I want to be…

php sql-server linux pdo freetds

asked Feb 27 '14 at 00:15

hank12323

votes

1 answer

Unable to locate package tsodbc

I'm trying to install FreeTDS as explained in the django-pyodbc wiki. But the last package fails to install: $ sudo apt-get install tsodbc ... E: Unable to locate package tsodbc

ubuntu freetds tdsodbc

asked Jan 24 '14 at 05:34

dan-klasson

13,734
14
63
101

votes

2 answers

Java - connecting to a SQL Server database on Linux

I've downloaded and imported into my project this JDBC driver that supposedly supports Linux (albeit tested only on SUSE Linux). What I want is to be able to use a .mdf database through Java on Linux. The queries obviously need something to run on,…

java sql-server linux jdbc freetds

asked Jan 07 '14 at 01:17

Venom

1,107
4
21
46

votes

1 answer

SQLSTATE[HY000] - PDOException - Laravel 4

I'm using Laravel 4 with CentOS 5 and PHP 5.4. When i try to run a query, i got this: PDOException SQLSTATE[HY000] Attempt to set unknown LOGINREC field (severity 7) Just a simple query like : User::find(1); (with Eloquent ORM). My FreeTDS…

php sql-server freetds unixodbc

asked Dec 26 '13 at 20:21

Eduardo Stuart

2,869
18
22

votes

1 answer

Connecting OSX + Python + MSSQL

I'm new to Python development and I am trying to set up a Python/Flask project on my Mac (Mavericks) to connect with an MSSQL server via pyodbc + freetds + unixodbc. I can connect and query the server using isql and osql, but I can't get pyodbc to…

python osx-mavericks pyodbc freetds

asked Dec 23 '13 at 18:51

minboost

2,555
1
15
15

votes

2 answers

Unix FreeTDS Isolation Level Sybase

According to the Sybase Documentation (http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbusage/udtisol.html) there is one paragraph: [...] The default isolation level is 0, except for [...] and TDS connections,…

sybase isolation-level freetds unixodbc rowlocking

asked Nov 07 '13 at 10:34

Max

Prev 1 2 3

…

43 44 Next