I'm trying to use FreeTDS's ODBC driver to access a MS SQL Server 2005 instance from a Linux application. When I run tsql on the command line, it will read /etc/freetds.conf and $HOME/.freetds.conf and pull in the options I want to set (confirmed with strace watching open/access calls). However when I use FreeTDS via unixODBC (which is...
I have a setup using Pyodbc, UnixODBC and FreeTDS, but somewhere in there some options are being set and I don't know where. According to SQL Server Management Studio, my program is sending some settings when it opens the connection: set quoted_identifier off set ansi_padding off set ansi_nulls off ... But I need a different set of se...
I have an application that allows the user to enter an SQL string with a placeholder for certain values my application produces. The application will the replace the placeholders with values and execute the SQL string through various database backends. For the ODBC backend, I call SQLExecDirect() on the SQL strin which works nicely on r...
Trying to load ODBC in my Rails app (I'm on Linux, FreeBSD 7.3-STABLE using rb-odbc, unixODBC, and FreeTDS to connect to MSSql) but I'm getting this error: Trace can be found here: http://gist.github.com/547759 Anyone have any glaring ideas? Thanks! ...
Hi, I'm using the following setup to access a MS-SQL database from a PHP application RedHat Enterprise Linux 5 PHP 5.2.14 with PDO and PDO_ODBC unixODBC 2.2.11 FreeTDS 0.82.1.dev.20100810 Unparametrized queries work fine. The only issue is being forced to close cursor on single result statements (with PDOStatment::closeCursor) to av...
I have a question about Django, unixODBC, FreeTDS, Apache2, mod_wsgi, that is somewhat similar to this question asked before on SO. I have a Django website built to run on the latest Django, that is, 1.2.3. It uses managed models for the most part, in that, save for the session information, nothing is written to the DB by Django, only r...