Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [freetds]

30 questions
1
vote
2 answers

Problem connecting to SQL Server 2005 via FreeTDS on FreeBSD

I am trying to connect to SQL Server 2005 from a FreeBSD server with the following command: tsql -H DEV -p 1433 -U **** This results in the following error message: locale is "C" locale charset is "US-ASCII" Password: Msg 20004, Level 9, State 0,…
Ben Hoffstein
  • 131
  • 1
  • 6
1
vote
1 answer

Connecting to MS SQL Server from Ubuntu Server

Using Ubuntu 10.04 LTS, I'm trying to connect to an MS SQL Server we have on another box from within a Python script. What are the steps I need to follow to do so? Right now, I'm trying to use the pyodbc module, but whenever I try to connect I get…
Nick
  • 215
  • 5
  • 8
0
votes
0 answers

FreeTDS connecting to Azure MSSQL Server

I've got a working Azure SQL instance running, and I'm trying to connect using FreeTDS over command line with my config as: [azure] host = ********.database.windows.net port = 1433 tds version = 7.2 database = ******** Using 7.2 as…
Tom Wilson
  • 719
  • 1
  • 6
  • 7
0
votes
1 answer

freetds start job at step from linux python script on MSSQL DB

I'm trying to create a python script on a linux box that can execute an agent job. Looking around I found sp_start_job command. But it doesn't seem to exist on python. Does any one know if it does work on python or any other scripting language…
maco1717
  • 131
  • 5
0
votes
2 answers

Unable to install freetds on RHEL7

I'm attempting to set up php-mssql in RHEL7. freetds is not available in the default RHEL repo, so I enabled epel as follows: rpm -Uvh http://mirror.oss.ou.edu/epel/7/x86_64/e/epel-release-7-5.noarch.rpm yum install freetds That yields: Error:…
a coder
  • 789
  • 4
  • 20
  • 38
0
votes
1 answer

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command? I've been trying for a few days now, using many different configurations. Even though I am able to connect to the DB using isql and PostgreSQL odbc driver,…
brunodea
  • 3
  • 2
0
votes
2 answers

Centos, PHP encrypted connection through freeTDS/ODBC to Microsoft SQL Server

I would like to connect from PHP to a Microsoft SQL Server through an encrypted connection. PHP scripts will run from a CentOS release 6.7 (Final) I want to connect to a Microsoft SQL Server 2014 running on a Microsoft Windows Server 2012…
nulll
  • 505
  • 1
  • 5
  • 9
0
votes
1 answer

FreeTDS - sudo uses different protocol version

After a while of fiddling with FreeTDS I got my connection to MSSQL from Sphinx up and running as DSN-less connection. After running indexer index Everything works as expected. But, after running (which I have to run as sudo to use rotate) sudo…
realshadow
  • 121
  • 4
0
votes
0 answers

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly for the past 6 months but today data wasn't…
Pbal
  • 76
  • 7
0
votes
1 answer

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when testing using "tsql". I don't think it is a…
Zamicol
  • 191
  • 1
  • 10
0
votes
1 answer

How to compile FreeTDS on FreeBSD10.0-64 in a right way

When i try compile freetds-stable from source (today is a 0.91 version) with: ./configure --with-iodbc=/usr/local --with-tdsver=7.2 --disable-libiconv make make install i didn't find the libtdsodbc.so library as it was in the previous version from…
dima.h
  • 145
  • 1
  • 6
0
votes
1 answer

Apache httpd + FreeTDS hangs until restarted

Every so often requests to a Linux server (say, linux.example.org) where the web app (Django) pulls in data from a SQL Server database via FreeTDS will hang. Requests on other servers pointing to the database still work, as do requests on…
Jordan Reiter
  • 1,290
  • 4
  • 20
  • 40
0
votes
1 answer

CentOS 6 recompile PHP and Freetds

I got something wrong with the default freetds (v 0.9.2) in my CentOS 6, reading the datetime from sql server is messed up in using mssql (dblib) extension, and it's said recompile php with current freetds would fix datetime problem. My question is,…
tommy-1402
  • 1
  • 2
0
votes
1 answer

Connecting to MS SQL Server 2005 using FreeTDS on Mac OS X 10.6

I built freetds 0.82 from macports using the +mssql variant (which sets up dblib and sets the default tds version to 8.0). I am now trying to connect to my database server (MSSQL Server 2005) using tsql, but it only works when I override the tds…
Matt Campbell
  • 183
  • 5
0
votes
1 answer

php5-mssql / freetds : can connect with tsql, not with php5-mssql

i'm trying to set up an Ubuntu workstation for php development with php5-mssql. First i compiled freetds-nightly 0.8.3 ( with --enable-msdblib ) and installed it to /usr/local/freetds , copying header files from the package to…
user48217
1
2