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

ODBC Driver / FreeTDS

I am migrating a PHP website that connects to an external MSSQL database. The new server is a Linux server. I know to get this to work I will need an ODBC driver for Linux, like these: FreeTDS Microsoft's ODBC driver for Linux. My question is,…
Web4Fun
  • 11
  • 5
0
votes
2 answers

TDSVersion keeps defaulting to 7.1 pymssql

IMPORTANT CHANGE: The following command also works and gets me the correct prompt. There must then be an issue with pymssql. sudo TDSVER=7.1 tsql -H asdf.database.windows.net -p 1433 -U adf@ad -P adsf#adf -D adf So I'm fighting with my pymssql and…
David Crook
  • 2,722
  • 3
  • 23
  • 49
0
votes
1 answer

Missing dependences sybase

i need to compile a project who requires tdspp(who uses a sybase), when i compile and install the source of tdspp(downloaded via git), it's ok, but the main project requires this library, and when i try to compile, get the next…
APRocha
  • 280
  • 6
  • 24
0
votes
0 answers

Python: Connecting to ms sql server from linux

I'm trying to connect to ms sql server hosted on a windows pc from a linux box. I'm trying to follow these instructions: http://www.freetds.org/userguide/serverthere.htm Now, I verified that I can ping and telnet into the PC running the server. And…
ChaoticTwist
  • 544
  • 7
  • 25
0
votes
1 answer

Django adds square Brackets in querying sql server

I am trying to connect to azure sql service from my django on mac osx. When I do following from photo_mapper.models import Restaurant rest_query = Restaurant.objects.all().query print rest_query SELECT [ate_it.restaurant].[id],…
Anubhav Agarwal
  • 1,982
  • 5
  • 28
  • 40
0
votes
1 answer

Stop Zend_Db from quoting Sybase BIT datatype field values

I'm using Pdo_Mssql adapter against a Sybase database and working around issues encountered. One pesky issue remaining is Zend_Db's instance on quoting BIT field values. When running the following for an insert: $row =…
Chad Kieffer
  • 491
  • 4
  • 8
0
votes
1 answer

FreeTDS: How to set charset of parameters running stored procedure

I have a C program connecting to a MSSQL database through FreeTDS. I'm trying to execute a stored procedure with a varchar parameter set to something like "Saída Liberada", but it's being stored with weird characters in MS SQL, as the screenshot…
natenho
  • 5,231
  • 4
  • 27
  • 52
0
votes
1 answer

FreeTDS on Mac fails from lack of GSS support?

I'm trying to use FreeTDS on Mac, but I can't connect to my Sql Server. Here's the error: ~ chris$ brew install freetds ==> Downloading https://homebrew.bintray.com/bottles/freetds-0.95.80.el_capitan.bottle.tar.gz Already downloaded:…
Chris B.
  • 85,731
  • 25
  • 98
  • 139
0
votes
1 answer

FreeTDS MSSQL nvarchar(max) issue

I'm pulling out data from an MSSQL server via PDO on a Unix system. Having tried the Easysoft ODBC Driver, which works as intended (but expensive!) I'm just trying out FreeTDS before we commit to buying a license. Trying to pull out data from the…
spirie
  • 21
  • 5
0
votes
1 answer

FreeTDS error connecting to SQL Server 2014

I have tried all the version available from 4.2 until 7.2, it seems to me all the versions I've tried are invalid. Looking at the errors logs and based on the Choosing TDS protocol, is SQL server 2014 supported? Brief error: Error 20017 (severity…
SteD
  • 13,909
  • 12
  • 65
  • 76
0
votes
0 answers

SQLSTATE[08S01] SQLDriverConnect: 20009 [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist

First of all I know there are many questions posted for the same issue. I have tried every thing but couldn't get it to work. I am trying to connect to SQL Server using PHP. I've configured FreeTDS and unixODBC correctly. I tried tsql, isql and…
Muzammil Versiani
  • 181
  • 2
  • 12
0
votes
2 answers

Unable to insert unicode characters through freetds unixODBC in MS SQL 2008

I have a c++ application built on RHEL 5 that connects to MS SQL 2008 through freeTDS and unixODBC situated on a windows machine. This is the query the application sends to the database. INSERT INTO mytable (SAMPLE) VALUES(N'乕乭乺丕') Um@D@Iz is…
D3XT3R
  • 181
  • 2
  • 15
0
votes
0 answers

Adaptive Server connection timed out with FreeTDS

I have a bash script that reads from a remote MSSQL server 2008 using FreeTDS. Using tsql, I am able to make individual queries and all of them run perfectly separately. However, when I run the bash script that contains multiple queries, I get the…
Gabriel Ilharco
  • 1,649
  • 1
  • 21
  • 34
0
votes
1 answer

Remote connection to SQL Server with FreeTDS and IPv6

I am trying to connect to a remote SQL Server 2008 from a bash file in a Ubuntu 14.04. I am using FreeTDS and the tsql command to do so. When I am in the same network as the SQL Server, I can access it using its local ip 192.168.0.2, using the…
Gabriel Ilharco
  • 1,649
  • 1
  • 21
  • 34
0
votes
3 answers

Can't create a database link for CMS WebGUI

I've updated the whole scenario (last one was a conflict between i686 and x64 libraries) Now I have an VPS with a fresh CentOS 6.6 32 bit with unixODBC, FreeTDS and WebGUI installed I can connect perfectly with SQL Server 2008 through isql and perl…
Flacid_Snake
  • 391
  • 2
  • 5
  • 16
1 2 3
…
43 44