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
10
votes
1 answer

Having Troubles with UnixODBC, FreeTDS, and PyODBC

I am having great difficulty getting all three of these to work together in harmony. I guess I'll list all the various configurations, along with the test code to see if a pair of fresh eyes can realize my stupidity. I'm running 12.04 Ubuntu Server…
Anthony Tantillo
  • 300
  • 1
  • 3
  • 12
9
votes
5 answers

Connecting to MS SQL Server using python on linux with 'Windows Credentials'

Is there any way to connect to an MS SQL Server database with python on linux using Windows Domain Credentials? I can connect perfectly fine from my windows machine using Windows Credentials, but attempting to do the same from a linux python with…
Samer Atiani
  • 695
  • 1
  • 6
  • 8
9
votes
2 answers

PDO dblib nextRowset not working

I'm in the process of converting a PHP application from running in a Windows environment to a Linux based environment. It utilises PDO to run Stored Procedures against a Microsoft SQL Server database. So, I've installed and configured PHP 5.6.22,…
Jamesking56
  • 3,683
  • 5
  • 30
  • 61
9
votes
1 answer

Connecting to MS SQL Server with iODBC on Mac

I'm trying to connect to a Microsoft SQL Server from my Mac development machine using iODBC. No matter what I do, I get the error message Unable to connect to data source from the FreeTDS driver. After consulting various manuals, blog posts, and…
josePhoenix
  • 538
  • 1
  • 5
  • 14
8
votes
6 answers

FreeTDS problem connecting to SQL Server on Mac (Unexpected EOF from the server)

I have setup FreeTDS to connect to SQL Server database. When I try to open TSQL in terminal on Mac (lion) I get this error: locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" Error 20017 (severity 9): Unexpected EOF…
gugguson
  • 819
  • 2
  • 13
  • 32
8
votes
1 answer

Docker PHP and FreeTDS -cannot find freetds in know installation directories

I'm trying to create my first image, which I forked from someone else, and I'm running into an issue where the build fails. Looks like the error is here [91mconfigure: error: Cannot find FreeTDS in known installation directories [0m no checking for…
d90
  • 767
  • 2
  • 10
  • 28
8
votes
1 answer

Can't connect to remote SQL Servers outside of network with PYODBC

I for some reason can't seem to connect to any SQL Server that is outside of our network, yet have no problem if I'm within the network via VPN. My code is as such for local connection: sql = pyodbc.connect( 'DRIVER={FreeTDS};' …
crookedleaf
  • 2,118
  • 4
  • 16
  • 38
8
votes
4 answers

FreeTDS - Unable to connect: Adaptive Server is unavailable or does not exist

CENTOS 6.5 x86_64 WHM 11.42.1 unixODBC 2.2.14 freetds v0.91 I'm trying to connect to remote MSSQL server without success - also tried connecting with different tds versions (4.2, 7.0, 7.1, 8.0) but all give the same result. Using the same…
user247497
  • 81
  • 1
  • 1
  • 2
8
votes
1 answer

Proper DSN to connect to Sybase using PDO

I'm trying to connect to a Sybase (SQL Anywhere 12) database using PHP's PDO. I spent hours trying to find the correct driver and DSN to use, with NO success AT ALL. Everytime I try to edit a single parameter I always get errors. I tried tens of…
tobia.zanarella
  • 1,246
  • 1
  • 17
  • 25
8
votes
3 answers

odbc unable to connect to MSSQL data source on OS X Lion

odbc isql was unable to connect to data source: $ isql SMS_GTWY username password -v returns: [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source [01000][unixODBC][FreeTDS][SQL Server]Unknown host machine name. [ISQL]ERROR:…
ohho
  • 50,879
  • 75
  • 256
  • 383
8
votes
3 answers

Microsoft ODBC driver for Linux vs FreeTDS?

I am investigating the possibilities to connect to a MSSQL database from a RHEL6 application server. I have found two ways: FreeTDS Microsoft SQL Server ODBC Driver for Linux + unixODBC Does anyone have experience in using either of these setups?…
Krumelur
  • 31,081
  • 7
  • 77
  • 119
7
votes
4 answers

Homebrew / TinyTDS / FreeTDS bundle error

I used homebrew (linux port) to install freeTDS and am trying to deploy /bundle install my app with gem tinytds. I get this error output when doing bundle install Installing tiny_tds (0.5.1) with native extensions…
wantrapreneur
  • 410
  • 4
  • 13
7
votes
1 answer

Unable to connect to Microsoft SQL Server inside Docker container using FreeTDS

I want to host Shiny applications on my company network using Docker for Windows. How do I set up the Docker, odbc.ini, odbcinst.ini, freetds.conf, or possibly other files so that my Shiny application can query data from an internal Microsoft SQL…
Giovanni Colitti
  • 1,982
  • 11
  • 24
7
votes
1 answer

SQLAlchemy returning strings instead of datetime objects

I'm using SQLAlchemy to connect to a SQL Server database. The table I'm querying has a DATETIME column. On Windows, the resulting attribute on the SQLAlchemy object is a Python datetime object. On Linux, it's a string. My SQLAlchemy class looks like…
Kris Harper
  • 5,672
  • 8
  • 51
  • 96
7
votes
3 answers

How to store and retrieve extended ASCII characters in MSSQL

I was surprised that I was unable to find a straightforward answer to this question by searching. I have a web application in PHP that takes user input. Due to the nature of the application, users may often use extended ASCII characters (a.k.a. "ALT…
Travesty3
  • 14,351
  • 6
  • 61
  • 98
1 2
3
…
43 44