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
0
votes
2 answers

FreeTDS translating MS SQL money type to python float, not Decimal

I am connecting to an MS SQL Server db from Python in Linux. I am connecting via pyodbc using the FreeTDS driver. When I return a money field from MSSQL it comes through as a float, rather than a Python Decimal. The problem is with FreeTDS. If I…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
0
votes
0 answers

Remote MS ACCESS connection with PHP ODBC on CentOS

I have a management software hosted on a Windows Server 2003 machine, this software using an MS Access (*.mdb) database. On another machine, that work with CentOS 6.7 I installed all the necessary modules relative to php odbc, freetds, etc.. Now I…
fmineo
  • 804
  • 3
  • 11
  • 28
0
votes
1 answer

how to generate 'create table script' using only tsql.I am using freeTDS tool in Linux machine to access sql server located at remote

How to generate 'create table script' using only tsql for all the tables in a database. Format of script should be same as we generate using Microsoft studio 2012 I am using freeTDS tool in Linux machine to access sql server.
user124665
  • 97
  • 1
  • 9
0
votes
1 answer

FreeTDS not respecting freetds.conf and odbc.ini

I have a problem, FreeTDS keep connecting using version 4.2 even if I set to 8.0 in these settings I CAN connect using tsql, and when I use tsql it show me it is using 7.1 (alias from 8.0), but my apache2 application keep using 4.2 Where can it be…
TLPNull
  • 475
  • 4
  • 12
0
votes
1 answer

SQL statement doesn't work for MS SQL 2005

SQL client: Ubuntu 14.04LTS DB Server: MS SQL server 2005, accessing via odbc and Freetds. Works fine for my other MS SQL 2005 server. isql 2.2.14 Freetds 0.91 Text editor: Notepad++ 6.5.5 for windows 7 is editing my .sql file on Ubuntu via a Samba…
Bulrush
  • 548
  • 2
  • 4
  • 19
0
votes
2 answers

Unable to connect to MSSQL from Python

my Python code: import pyodbc cnxn = pyodbc.connect('DRIVER=FreeTDS;DSN=S29;UID=test;PWD=test;TDS_Version=8.0;ClientCharset=UTF8') cursor = cnxn.cursor() cursor.execute("select user_id, user_name from users") rows = cursor.fetchall() for row in…
Ruslan
  • 316
  • 1
  • 3
  • 16
0
votes
2 answers

ODBC with FreeTDS PHP Not working via HTTP

I have got FreeTDS, unixODBC and ODBC enabled on PHP. It all seems to work great. I could connect via iSQL command line. For some reason PHP is not able to work when accessed via HTTP. For example. via command line if I run php index.php (where…
Shoogle
  • 206
  • 1
  • 13
0
votes
1 answer

Handing multiple dbcount from freetds?

I have a few queries which should return multiple 'affected rows' (and do so when running via SQL Server Management Studio), but I cannot seem to figure out how to properly call dbcount more than one time. This is my testing function using the…
Kyle
  • 17,317
  • 32
  • 140
  • 246
0
votes
1 answer

Monitor azure with nagios and odbc-freetds

I want to monitor Azure Paas database with Nagios. I'm using this plugin available at https://github.com/MsOpenTech/WaMo When I try to check database: ./check_azure_sql.py -u -p -d -k top5queries I get this error message: ('08001', '[08001]…
Kevin
  • 1
  • 1
0
votes
0 answers

php_dblib enabled but not in phpinfo (Windows)

I need to connect to a remote Sybase database with PHP 5.4.5 and I therefore enable the driver php_dblib (FreeTDS) for PHP and it shows as is in Wampserver but when I look at the phpinfo() results, there is nothing about dblib. My application (Zend)…
mentinet
  • 744
  • 3
  • 9
  • 23
0
votes
3 answers

sqlalchemy date type in 0.6 migration using mssql

I'm connection to mssql server through pyodbc, via FreeTDS odbc driver, on linux ubuntu 10.04. Sqlalchemy 0.5 uses DATETIME for sqlalchemy.Date() fields. Now Sqlalchemy 0.6 uses DATE, but sql server 2000 doesn't have a DATE type. How can I make…
nosklo
  • 217,122
  • 57
  • 293
  • 297
0
votes
0 answers

FreeTDS for Linux 32 Bit?

Freetds with Linux 32 bit The question matters a problem with Linux 32 bit with the software freetds. On 64 Bit Linux I can install and use Freetds normally to connect with mssql server database. On 32 bit I can't install the aptitude search…
ShbPap
  • 45
  • 4
0
votes
2 answers

Laravel sqlsrv works in tinker mode but not in browser

I have a Laravel 5 project (on a CentOS 7 machine) that connects to an external MSSQL database. I followed the setup outlined here using FreeTDS. When I hit the page using a browser I get the error: SQLSTATE[HY000] Unable to connect: Adaptive Server…
Sandyandi N. dela Cruz
  • 1,345
  • 10
  • 20
0
votes
0 answers

FreeTDS buildpack on Heroku Cedar OpenSSL Error

I have a sinatra rack ruby app that I want to deploy on heroku. The app needs to connect to an SQL Server Database. For that I need the TinyTds gem. Gemfile source 'http://rubygems.org' ruby "1.9.3" gem 'sinatra' gem 'tiny_tds' Gemfile.lock after…
Tasos
  • 1,575
  • 5
  • 18
  • 44
0
votes
0 answers

FreeTDS with SQL Server: multiple connections

I have a RHEL server Linux-Apache-PHP plus some separate Microsoft SQL Server 2008R2, that I access via FreeTDS. I would like to open two separate connections, from inside a PHP script, which may go to the same SQL Server, or to two different…
carlo.borreo
  • 1,344
  • 2
  • 18
  • 35
1 2 3
…
43 44