Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [freetds]

31 questions
7
votes
1 answer

Connecting to MS SQL Server using FreeTDS: Error 20002: "Adaptive Server connection failed"

I am trying to use FreeTDS to connect from a Linux server (RHEL v7) to a separate server running MS SQL Server 2014. However, when attempting to connect with tsql I get the following errors (error message differs depending on whether I include…
KCC
  • 71
  • 1
  • 1
  • 2
7
votes
3 answers

Php pdo_dblib - cannot find/unable to load freetds

Self-hosted box, RHEL 6 PHP 5.3.3 PDO installed freetds installed pdo_dblib - so far no luck installing My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate version php source code. I have tried a variety of…
MaxPowers
  • 171
  • 1
  • 3
7
votes
2 answers

Perl TDS character sets

I'm using the FreeTDS driver with DBD::Sybase, connecting to an MS SQL Server. When I query certain values of certain records, I get this error: DBD::Sybase::st fetchrow_arrayref failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (9)…
skiphoppy
  • 181
  • 2
  • 6
6
votes
3 answers

FreeTDS: Do I need to restart anything after changing the freetds.conf file?

The freetds.log file was overloading the system, so I changed the debug flags in /etc/freetds.conf : ; dump file = /tmp/freetds.log #; debug flags = 0xffff ; debug flags = 0x80 How do I restart freetds or unixodbc?…
bigpotato
  • 343
  • 2
  • 3
  • 10
4
votes
4 answers

Which ports are needed for NTLM (Windows Authentication) to connect to SQL Server?

I've got SQL server running on a machine which is not in a domain, and which is not operating in mixed mode (it's running with "Windows Authentication"). I'm trying to connect to it from a Linux web server running freetds via TCP/IP, using NTLM to…
Adam Bellaire
  • 1,190
  • 1
  • 7
  • 10
3
votes
1 answer

Can't Install freetds php-mssql on Centos7

I am at my wits end... Newbie to Linux... please help me... Goal is to connect to MS SQL Server 2005 using PHP. I have installed PHP and ODBC. I am running CentOS7. PHP Version => 5.4.16 .... (from php -i) .... odbc ODBC Support => enabled I am…
DylanH
  • 135
  • 1
  • 5
3
votes
1 answer

Vertical output from FreeTDS fisql

With the mysql shell, you can get vertical output when executing interactive queries by ending them with \G instead of ;. For example: mysql> select * from foo limit 1\G *************************** 1. row *************************** sid:…
Aaron Brown
  • 1,677
  • 1
  • 12
  • 21
2
votes
1 answer

“Unknown host machine name.” on FreeBSD + unixODBC + FreeTDS

I got some issues connecting to a Microsoft SQL Server 2012 from my FreeBSD 10.1 server. I installed FreeTDS and unixODBC via ports. I compiled FreeTDS with unixODBC support. This ist my freetds.conf: [server1] host = 192.168.100.147 port =…
user281736
1
vote
1 answer

FreeTDS PHP mssql_connect() 503 on refresh

We have recently installed FreeTDS with php56-mssql onto one of our RHEL7 servers. Everything appears to be functioning correctly except for this strange issue. The first time we load a php page that is using mssql_connect() function, the page…
nullReference
  • 263
  • 1
  • 3
  • 10
1
vote
1 answer

"Unable to connect to data source" Debian unixODBC FreeTDS; PHP CLI works, apache/web doesn't

Envoironment: webserver: Debian8 with Apache, PHP, unixODBC, FreeTDS (current versions installed with apt-get last week) dataserver: Windows Server 2008 with MS SQL Server 2008 Opening this in webbrowser: (variables are set and right)
user3665396
  • 21
  • 4
1
vote
1 answer

Connecting to MSSQL db (PDO, FreeTDS, ODBC)

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
  • 11
  • 1
  • 1
  • 3
1
vote
0 answers

Is it possible to create something along the lines of an odbc.d directory?

Many servers such as nginx, Apache httpd, as well as other services and tools like yum, supervisord, cron, etc allow you to place configuration files in a directory and add, remove, and change individual files rather than work on one monolithic…
Jordan Reiter
  • 1,260
  • 4
  • 17
  • 38
1
vote
2 answers

Compiling FreeTDS 0.91 on Ubuntu 11.04 x64

I'm working on a Python project that uses DSN-less connections with SQLAlchemy / pyodbc / unixODBC / FreeTDS to fetch data from a SQL Server database. Now I would like to set client charset directly in the connection string which is not possible in…
jmagnusson
  • 111
  • 5
1
vote
2 answers

Cannot connect from Linux to SQL Server through a firewall

I need to connect from a Debian GNU/Linux webserver to an SQL Server database which is hosted on a Windows machine within an organization's local network. The person in charge of the database server and the person in charge of the firewall both say…
Alex Marandon
  • 115
  • 1
  • 6
1
vote
0 answers

Connecting to a specific database using FreeTDS

I have my freetds.conf set up thusly. Notice that I specifically have set up the database as myawesomedb: [EXAMPLE_CONF] driver = /usr/lib64/libtdsodbc.so host = example.org database = myawesomedb port = 5150 tds version = 8.0 ;client charset =…
Jordan Reiter
  • 1,260
  • 4
  • 17
  • 38
1
2 3