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
3 answers

Querying MSSQL server 2012 from a Raspberry Pi 3 using Python, FreeTDS and pyodbc

I am trying to query MSSQL server 2012 using Python as my scripting language on a raspberry Pi3. I have the need to create an application that will query MSSQL server and return some values that need to be displayed on a H.M.I. I chose the Raspberry…
Alfalaval
  • 41
  • 1
  • 1
  • 3
4
votes
2 answers

Connecting to SQL Server 2005 from a ROR application in Ubuntu

I tried to connect to SQL Server from a ROR application in Ubuntu. For that I did the following things. I installed the following libraries in my Ubuntu 10.04 unixodbc unixodbc-dev freetds-dev libdbd-odbc-ruby tdsodbc After installing these, I…
Neo
  • 41
  • 1
4
votes
1 answer

PDOException: SQLSTATE 01002 Adaptive Server connection failed (severity 9)

I have been following some answers over stackoverflow. My odbc. ini (located in /etc/odbc.ini) [MSSQL] Description = MS SQL Server Driver = /usr/local/lib/libtdsodbc.so Server = host.of.the.server UID = myusername PWD = mypassword ReadOnly = No Port…
Vahn Marty Cagalawan
  • 579
  • 2
  • 7
  • 23
4
votes
1 answer

connect to FileMaker Server with pyodbc

I have a FileMaker db running on FileMaker Server 14 on a Mac Mini and I'm trying to get at it with pyodbc. It's not going well. First, what works: telnet 192.169.19.3 2399 ssh Name@192.169.19.3 tsql -H FM-Server -p 2399 -U Name -P pwd One weird…
brnco
  • 83
  • 6
4
votes
1 answer

FreeTDS - TSQL fails when password given in option, but succeeds when typed?

I'm trying to connect to a MS SQL Server trough PHP 5.6 with an Ubuntu 16.04 server. I'm forced to use this version of PHP, in order to assure compatibility with an 'ancient' application. I installed PHP 5.6 and its modules (pdo, pdo_mysql,…
Luc Ettlinger
  • 71
  • 6
4
votes
1 answer

FreeTDS doesn't use configured tds version

freetds v0.91 - tds version mismatched I want to connect to a Windows SQL Server with FreeBSD on Ubuntu 14.04. The FreeTDS is installed using apt-get. I tried different tds version with following commands: $ TDSVER=7.0 tsql -H xxx.xxx.xxx.xxx -U…
Hsu Hau
  • 604
  • 7
  • 16
4
votes
2 answers

Microsoft SQL Server error with Laravel: Why this solves my mistake?

I am creating an application in Laravel, which accesses information stored in a remote database Microsoft SQL Server. And I have encountered an error, which I solved; but I do not quite know why... The Problem I created a "users" table within the…
tomloprod
  • 7,472
  • 6
  • 48
  • 66
4
votes
2 answers

Trouble installing pymssql on Windows

I can't find great support for pymssql installation support on Windows. I'm trying to connect to an enterprise database through another employee's python wrapper. This wrapper requires my installing of pymssql. The RTFM on this doesn't have very…
M. Pierce
  • 41
  • 1
  • 3
4
votes
2 answers

PHP MS SQL Unix Driver - Microsoft or FreeTDS

I am running a LAMP server but now need to connect to MS SQL (client request). I have heard Microsoft has a driver, but can't verify if Does anyone know if the Microsoft driver is available for Unix? If not, should I just stick with FreeTDS? This…
Jason McCreary
  • 71,546
  • 23
  • 135
  • 174
4
votes
2 answers

PHP PDO (MSSQL) can not get OUPUT parameters

I'm trying to get OUTPUT using bindParam (PHP PDO). The PHP PDO library is the FreeTDS for MS SQL driver. Whatever I do, I can't seem to get the "OUTPUT" in the the bound params as suggested on php.net. I've verified I can call the EXEC and return a…
jjwdesign
  • 3,272
  • 8
  • 41
  • 66
4
votes
1 answer

PHP + MS SQL Server character coding

I have a Codeigniter project on my Ubuntu Linux server. I don't use MySQL because I am connecting Microsoft SQL 2014 Express Server. (I am using FreeTDS on my Linux server) The FreeTDS is working, I can connect MS SQL server, but I have a problem…
user3740961
  • 329
  • 1
  • 5
  • 17
4
votes
2 answers

Pyodbc can't find FreeTDS driver

I am on a Centos 7 Linux machine trying to connect to an SQL database through pyodbc. I learned that you need to setup the DSN and you do that by installing the freetds driver and doing something like: import pyodbc cnxn =…
GonGetIt123
  • 51
  • 1
  • 1
  • 3
4
votes
1 answer

Trouble With Connecting to MSSQL DB

I have an Ubuntu 12.04 server and I'm trying to establish a connection to a MSSQL database. I've managed to connect using tsql and isql, but osql doesn't work and connecting with PHP using PDO also isn't working.. I will try to provide as much…
sudo
  • 43
  • 5
4
votes
1 answer

PHP 5.5.6 Random memory leak

after we have migrated to PHP 5.5.6 and Apache 2.4 from PHP 5.3.3 every site that runs on Kohana 3.3 encounters from time to time a Out of memory exception. Full error message PHP Fatal error: Allowed memory size of 268435456 bytes exhausted…
realshadow
  • 2,599
  • 1
  • 20
  • 38
4
votes
2 answers

Django-pyodbc SQL Server/freetds server connection problems on linux

Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnectW)') I'm migrating from developing on a windows development machine to Linux machine in production and I'm…
reconbot
  • 5,138
  • 6
  • 45
  • 63
1 2 3
…
43 44