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
5
votes
0 answers

Enabling FIPS causes libgcrypt error

I have two CentOS 6.7 machines (server A and B). Same package versions are installed on each system. Last week I enabled the openSSH FIPS 140-2 module on Server A, and that system works flawlessly (including tsql queries to a SQL Server instance).…
a coder
  • 7,530
  • 20
  • 84
  • 131
5
votes
1 answer

Heroku FreeTDS, how to use Rasil SQL Server with TinyTDS with Multi Buildpacks

I have to use the "Tiny TDS" gem with my Rails 4.2.3 and of course on cedar-14 of Heroku I can't because FreeTDS is not anymore on it. How to use FreeTDS on Heroku cedar-14? I'm looking on the web and I found…
user4412054
5
votes
1 answer

Ruby 2.0 on windows connecting to MS SQL varchar(max) truncating to 2048

background: i have written a few ruby transformation scripts they get data from MS SQL transform them and then store it back to the data base i am using tiny tds gem which works over freetds --Problem: for columns in sql that are varchar max and…
Ahmed
  • 1,985
  • 1
  • 13
  • 8
5
votes
3 answers

Django <-> SQL Server 2005, text encoding problem

I'm trying to store Django data on MS SQL Server 2005 using: http://code.google.com/p/django-pyodbc/ (pyodbc + FreeTDS) As long as I'm storing string consist of ASCII characters everything is ok. When I'm using unicode (ex. '\xc5\x82'), django…
gruszczy
  • 40,948
  • 31
  • 128
  • 181
5
votes
1 answer

Execute ms sql server queries from linux terminal

I need to query a MS SQL Server database from a linux terminal. Searching the web and this site I found freetds and then sqsh. I have installed them and seems to connect to the server but I can't get it to execute a query, I'm definitely doing…
Javier Mr
  • 2,130
  • 4
  • 31
  • 39
5
votes
1 answer

Inconsistent results in special characters with Apache/PHP/FreeTDS, but not with PHP/FreeTDS from command line

I have two identical servers (called test and production) with Linux Red Hat Enterprise Linux Server release 6.2 (Santiago), PHP version 5.4.2, Apache Apache 2.4.2, OpenSSL/0.9.8s, freeTDS 0.92-dev (not the best thing but I cannot change that for…
carlo.borreo
  • 1,344
  • 2
  • 18
  • 35
5
votes
2 answers

Flask-SQLAlchemy different record count for .count() and .all()

In SQLAlchemy, ModelName.query.filter_by(field_name=value).count() returns correct record count, but ModelName.query.filter_by(field_name=value).all() only returns a single record. Doing a db.session.execute("SELECT * FROM table_name WHERE…
Mir Nazim
  • 636
  • 1
  • 8
  • 20
5
votes
1 answer

python: Invalid data type (0) (SQLBindParameter)

I am using python 2.7 for a specific job. I am connecting to MSSQL Server (2008) using FreeTDS. I can make some simple select queries but when I try to run a parametrised query I got an error: ('HY004', '[HY004] [FreeTDS][SQL Server]Invalid data…
huzeyfe
  • 3,554
  • 6
  • 39
  • 49
5
votes
1 answer

FreeTDS strange date time format

After moving application to new server with updated software (moved from php 5.2.17 -> 5.3.15, FreeTDS 0.64 -> 0.82) SELECT GETDATE() and any other datetime function / column produces something similar to: 2012-06-219 51:527: // proper time:…
dev-null-dweller
  • 29,274
  • 3
  • 65
  • 85
4
votes
1 answer

Pyodbc utf-8 bind param error With FreeTDS and unixODBC

FreeTDS version 0.82 unixODBC version 2.3.0 pyodbc version 2.1.8 freetds.conf: tds version = 7.0 client charset = UTF-8 using Servername in the odbc.ini (which for some crazed reason made a difference in getting unixODBC to recognize the client…
Michael
  • 41
  • 2
4
votes
2 answers

Alternatives to FreeTDS?

We're running a Linux server with Microsoft SQL Server for the database. Are there any good (preferably open source) c libraries that we could use other than FreeTDS? Thank you
Holtorf
  • 1,451
  • 4
  • 21
  • 41
4
votes
1 answer

Not able to connect to SQL Server instance with FreeTDS ODBC

I try to connect to a microsoft sql server I use pyodbc with FreeTDS. My script: import pyodbc cnxn = pyodbc.connect( 'DRIVER={FreeTDS};SERVER=myServerAdress;INSTANCE…
HrkBrkkl
  • 613
  • 5
  • 22
4
votes
1 answer

Pymssql, How to use it to read unicode data from MSSQL2008

I've used pymssql-1.0.2 and freetds-0.82.7 on ubuntu-10.10. Also, I have a mssql2008 server on windows-7. I can connect with mssql from ubuntu using pymssql and freetds. But I can't get unicode data from mssql database. Database collation is…
Orgil
  • 187
  • 3
  • 13
4
votes
0 answers

Rails MSSQL - TinyTds::Error: Adaptive Server connection timed out

I want to try get Rails and MSSQL talking within our CI tool, CircleCI. I work on a mac, so setting this up was fairly pain free. I installed FreeTDS locally using Homebrew. Then I spawned up a MSSQL docker image and set my config in my rails app to…
legendary_rob
  • 12,792
  • 11
  • 56
  • 102
4
votes
2 answers

freetds connection issue macOS

I am trying to connect to a remote MSSQL DB from a MacOS. I am able to connect to the remote DB using freetds tsql -H servername.database.windows.net -U username -P password -D database_name -p 1433 But as I make an entry in the…
anonR
  • 849
  • 7
  • 26
1 2 3
…
43 44