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/
Questions tagged [freetds]
658 questions
6
votes
4 answers
Read from the server failed when trying to connect to sql-azure from tsql
I'm trying to connect to SQL-Azure from Ubuntu 12.04.
I've compiled freeTds-0.91 with openssl and libiconf
tsql -H XXXXXXXX.database.windows.net -U Username -D DatabaseName -p 1433 -P Password
I try connect using the above statement and I get this…
Martinffx
- 2,426
- 4
- 33
- 60
5
votes
2 answers
Connecting Redhat to SQL Server 2008 for Ruby on Rails
I'm trying to connect Redhat Linux to a Microsoft SQL Server 2008. I already had trouble setting it up on windows (my test machine) but now I need to deploy it on the Linux machine where it will be in production.
So I've installed unixODBC and…
omarArroum
- 255
- 1
- 8
- 19
5
votes
2 answers
How to connect to SQL Server using FreeTDS ODBC
I am trying to connect to my company's SQL Server Databases via my MacBook and have followed the steps outlined here: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Mac-OSX but keep getting the following error when I get to…
ny_coder_dude
- 71
- 1
- 2
- 7
5
votes
1 answer
Connecting to Microsoft SQL Server on ODBC using R in Ubuntu
I was able to get it completely working on Windows 7, but I have to move it to a Linux server. I'm running Ubuntu 16.04.1 LTS 64-bit in a VM right now for testing before I replicate the process on the server.
I'm pretty sure the issue is somewhere…
user2990276
- 307
- 1
- 2
- 7
5
votes
1 answer
PDOExeption SQLSTATE[HY001] Unable to allocate sufficient memory
When i run bellow code from php-fpm:
$connect = new PDO("dblib:host=mssql.dev.gm.local;dbname=GeoData","username","password");
try{
$s = $connect->query('[RU].GetTownInfo 4368');
var_dump($s->fetch());
}catch (Exception $e){
…
iusik
- 86
- 7
5
votes
0 answers
linux pyodbc freeTDS mssql server stopped working after some time
I have been successful in connecting to the sql server from and ubuntu machine
using pyodbc/freeTDS
The setup works fine, but for some time after which i am getting the following error
[ERROR] (server)-('IM002', '[IM002] [unixODBC][Driver…
Syed Mohd Mohsin Akhtar
- 451
- 5
- 20
5
votes
4 answers
PHP 7.x connection with MSSQL server with MAMP
I am trying to connect mssql server to PHP 7.0.8 through MAMP. I have tried using freetds. On some blog people are saying to use pdo_dblib.so extension but it's not working.
Please guide me through the process of connection.
Amit Verma
- 749
- 2
- 7
- 17
5
votes
1 answer
Calling SQL Server Stored Procedure using PHP PDO from Lumen for return value gives syntax error
I am trying to get the return value from the SqlServer stored procedure. But it is giving syntax error in my Ubuntu Server which uses FreeTDS.
SQLSTATE[HY000]: General error: 20018 Incorrect syntax near '0'.
[20018] (severity 15) [(null)]
Below…
Beniston
- 542
- 1
- 8
- 17
5
votes
1 answer
Non-Emulated Prepared Statement support from MS SQL Server through PHP on Linux
Summary
I'm attempting to use prepared statements to stop SQL Injections, but am unable to find the support I need to guarantee it is working properly.
Scenario
I am hosting a site on Linux which is connecting to a Microsoft SQL Server with FreeTDS…
Stewart Smith
- 1,396
- 13
- 28
5
votes
2 answers
Freetds could not connect to SQL Azure by server name (-S), but connect by host (-H) works
I have installed freetds and it looks working fine, when I try to connect by host:
tsql -H myhost -U myuser -P mypass -p 1433
locale is "C/UTF-8/C/C/C/C"
locale charset is "UTF-8"
using default charset "UTF-8"
1>
I have configured…
Леонид Николаев
- 159
- 1
- 7
5
votes
1 answer
Cannot install pymssql on windows
i am trying to install pymssql as
pip install pymssql
i have windows 7 and python 3.5 (from anaconda) but i get
Failed building wheel for pymssql
i believe its related to freetds and python-dev. how do i install these on windows?
Which packages…
AbtPst
- 7,778
- 17
- 91
- 172
5
votes
1 answer
Homebrew, FreeTDS, tiny_tds. Why can't I install tiny_tds after successfully installing FreeTDS?
This issue led me to this question.
I expected that to solve my issue, a couple of the answers there detail some config params that can help with the installation. The paths weren't quite right for me so I modified them and ended up with this:
gem…
gdgr
- 1,435
- 2
- 15
- 31
5
votes
2 answers
Best practices for doing accounting in Python
I am writing a web2py application that requires summing dollar amounts without losing precision. I realize I need to use Decimals for this, but I've found myself having to wrap every single number I get from the database…
mwolfe02
- 23,787
- 9
- 91
- 161
5
votes
0 answers
FreeTDS returns strings with null character
I'm using freetds + unixODBC + php pdo_odbc to access MSSQL Server 2012
+ CentOS 7 x86_64
+ freetds version 0.95.19
+ unixODBC version 2.3.4
+ php version 5.6.14
When retreiving results from SQL Server in UTF-8 I get NULL characters (\u0000 in…
Mizax
- 86
- 5
5
votes
2 answers
installing tiny_tds gives error on on mac os 10.10.5
I am using mac os and I want to connect to sql server by using ruby driver. I want to use tiny_tds but it gives error for missing free_tds but it was already installed. How can pass this?
~ brew install freetds
Warning: freetds-0.91.112 already…
Mesut GUNES
- 7,089
- 2
- 32
- 49