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

pyodbc.connect to FreeTDS connection requires explicit PORT=1433;

I have a python script running on python 2.7 in CentOS 2.6 that connects to a Sql erver database: pyodbc.connect("DRIVER=FreeTDS;SERVER=someServer;DATABASE=someDb;UID=myUser;PWD=superSecret;CHARSET=UTF8;TDS_Version=7.2") That call will fail with…
Justin Dearing
  • 14,270
  • 22
  • 88
  • 161
0
votes
2 answers

Segmentation Fault from PHP PDO FreeTDS ODBC execution

I am currently migrating a PHP project from using PHP's mssql library to using the PDO library with FreeTDS. I have modified all of my database calls, but have run into a very strange problem executing the prepared statements on the SQL Server…
BLenau
  • 95
  • 1
  • 4
  • 12
0
votes
3 answers

How to execute multiple queries using PDO for Sql Server

I'd like to execute some queries that doesn't return result set, and then execute a real query, and fetch its result. Here is an exemple that doesn't work :
Emmanuel Averty
  • 11
  • 2
0
votes
0 answers

SQL UPDATE does not affect any row via django-pyodbc

I have django-pyodbc installed for Python 2.7 (Ubuntu 14.04, unixODBC, FreeTDS) and I am attempting to update a SQL Server database that I created as a test. Everything works well except one particular UPDATE statement that does not affect any row.…
Patrick
  • 2,577
  • 6
  • 30
  • 53
0
votes
1 answer

How to get password hash to create a principal from query?

I use this query to create server login. I want to pass password like hash: PASSWORD = hashed_password HASHED How can I get the hash? I use freetds to connect to server.
kaa
  • 1,265
  • 5
  • 22
  • 39
0
votes
1 answer

SSL over TDS, SQL Server 2005 Express

I capture packets sent/received by Win Xp machine when connecting to SQL Server 2005 Express using TLS encryption. Server and Client exchange Hello messages Server and Client send ChangeCipherSpec message Then Server and Client server send strange…
Reuven Abliyev
  • 135
  • 2
  • 11
0
votes
0 answers

How to access unix odbc in apache server

I am using ubuntu server 14 .I already installed freetds,unixodbc and pyodbc,if I run python program in my home folder means I can access mssql database ,same coding not working in apache server ,php file also can't connect access to database .So…
Nandha Kumar
  • 413
  • 8
  • 18
0
votes
1 answer

"Computed" key from Sql server scalar functions

I have a project that uses MSSQL over pdo_dblib and freetds. MS scalar functions always returned their data in this format: array(1) { [0]=> array(1) { ["computed"]=> string(3) "922" } }. But now, on one of the servers the format suddenly…
sg2002
  • 121
  • 3
0
votes
0 answers

Linux Centos issue with MS SQL Using FreeTDS

I have gone though all of the steps in the following link: http://forums.cpanel.net/f5/definitive-freetds-installation-instructions-88561.html Everything seems to install properly (I don't recieve any errors), but yet when I attempt to use…
Ifking
  • 1
  • 1
0
votes
1 answer

Connecting Laravel 4 (on OSX) to MSSQL

As above - trying to hook up a Laravel 4 app to an MSSQL DB. Currently I'm getting the Laravel 'Could not find driver' error page. I've found, compiled an installed an MSSQL.so extension using freeTDS and Homebrew for PHP as per this tutorial -…
liamstuff
  • 15
  • 4
0
votes
2 answers

trouble accessing mssql db using perl and freetds on unix

I'm trying to connect to a MS-SQL Database using perl and freetds. I have tested the installation of freetds using the unix commandline `/usr/local/exec/bin/tsql -S myDB -I freetds.conf -U userName -P passw0rd -D DataBase1 -o q < query.sql` where…
MattO
  • 13
  • 8
0
votes
1 answer

PHP PDO unixODBC FreeTDS SQL Server 'converting data type varchar(max) to datetime' in stored procedure

I have been banging my head against this for a while. I have Ubuntu 14.04 64bit with PHP 5.5.9-1ubuntu4.4 (cli) and have installed php5-odbc via apt-get, I have also installed freeTDS and unixODBC. I am attempting to call a stored procedure by…
Matt
  • 364
  • 4
  • 10
0
votes
1 answer

Reading from a big table

I want to read data from a table (or view) on SQL server 2008R2 using PHP 5.4.24 and freetds 0.91. In PHP, I write: $ret = mssql_query( 'SELECT * FROM mytable', $Conn ) ; Then I read rows one at a time, process them, all is ok. Except, when the…
carlo.borreo
  • 1,344
  • 2
  • 18
  • 35
0
votes
1 answer

RODBC ERROR: Could not SQLExecDirect 'CREATE TABLE ... when doing sqlSave

Here is the short story, and it is important to talk about the setup, I’m using RODBC and FreeTDS to connect to the SQL Azure database. Remember it is SQL Azure database (also happen to be issue for on premise SQL Server, that alarm me to post it…
Mike
  • 27
  • 1
  • 3
0
votes
1 answer

How to connect my Rails App to SQL Server from Ubuntu Guest to Windows 8.1 Host?

I'm having issues setting up my rails app on a Windows 8.1 machine with Ubuntu through VirtualBox. I've done the following in attempts to try and connect my Ubuntu Guest Rails app to my Windows 8.1 SQL Server Express database. Setup a Bridged…
daveomcd
  • 6,367
  • 14
  • 83
  • 137
1 2 3
…
43 44