The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
16 views

“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 ...
0
votes
1answer
23 views

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 ...
0
votes
0answers
29 views

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 ...
1
vote
1answer
105 views

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 .... ...
1
vote
0answers
22 views

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 ...
2
votes
1answer
1k views

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 ...
1
vote
1answer
1k views

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 ...
0
votes
1answer
315 views

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 ...
0
votes
1answer
258 views

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 ...
0
votes
1answer
194 views

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 ...
7
votes
2answers
3k views

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 ...
2
votes
1answer
572 views

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
vote
2answers
1k views

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 ...
1
vote
2answers
609 views

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 ...
1
vote
0answers
694 views

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 ...
1
vote
2answers
4k views

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 ...
0
votes
1answer
1k views

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 ...
0
votes
1answer
2k views

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 ...
1
vote
1answer
3k views

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 ...
6
votes
2answers
3k views

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 ...
3
votes
4answers
19k views

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 ...