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

SQL server client benchmark / low performance issue

We experiment low performance with SQL-server 2008 when performing massive INSERT queries. These queries are enclosed into transactions by batches of 25, 50, 100, or 200 rows. Different factors influences the DB performance: the number of…
user2335044
  • 41
  • 4
0
votes
1 answer

PHP/MSSQL/SQL Profiler: not executing incoming SQL

I have a very simple INSERT statement that I can run using SSMS. When I run the same INSERT statement using PHP mssql_execute or mssql_query SQL profiler shows me that the 'TextData' is identical when sent in by PHP as it is when sent in by SSMS.…
downatone
  • 1,936
  • 2
  • 23
  • 30
0
votes
2 answers

Install sqsh for freetds (Sql Server)

Duplicate: I can't make SQSH 2.1.7 with freetds 0.91 I am trying to install sqsh for freetds (SQL Server) as per this answer. I installed freetds under /opt/freetds. However, I am getting the following error building sqsh: [noahlz:sqsh-2.4]$ sudo…
noahlz
  • 10,202
  • 7
  • 56
  • 75
0
votes
1 answer

unixODBC/FreeTDS results truncated to 255 character

UPDATE 2 I turned on tracing and ran my sample query. Here is the trace. I do see the statement Strlen Or Ind = 0x7fff9c84ee88 -> 255. The indicator variable is defined as SQLLEN indicator; Is this not initialized…
dseiple
  • 598
  • 2
  • 6
  • 17
0
votes
1 answer

Zend Framework 2, PDO dblib driver, how to change SQL Platform Decorator

It seems that ZF2 with the PDO:dblib driver defaults to using the SQL92 SQL decorator. How do I use the DI system to tell it to use the SqlServer decorator instead? Just can't get my head around it. The issue is that the paginator attempts to use…
Chris KL
  • 4,882
  • 3
  • 27
  • 35
0
votes
1 answer

How to query in a specific database on Azure?

I'm trying to execute a (very) simple query on Azure MSSql Server using PHP, but it does not work and prints the follow message: Warning: mssql_query(): message: Invalid object name 'MyTable'. (severity 16) I believe that the underlying driver…
Miguel Pragier
  • 135
  • 2
  • 13
0
votes
2 answers

Backslashes removed from query response string with Perl DBD:ODBC module

I am querying a MSSQL DB with Perl using the DBD:ODBC module and FreeTDS. The query response is returning successfully but backslash characters \ are removed from the response. So for example Windows directories in the text of one of the fields…
user2683552
  • 1
  • 1
0
votes
3 answers

Will I need to recompile/install php to add the mssql extension?

I have a system that is running php, and I recently needed to add connectivity to an MSSQL database. I have FreeTDS and UnixODBC installed/configured correctly, and I can make successful queries in python, and via utilities like tsql and isql. After…
EGr
  • 2,072
  • 10
  • 41
  • 61
0
votes
2 answers

Can't connect to SQL Server using isql on Mac OS X

I have installed freetds using Homebrew. My configuration is as follows: odbcinst -j: unixODBC 2.3.1 DRIVERS............: /usr/local/Cellar/unixodbc/2.3.1/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/Cellar/unixodbc/2.3.1/etc/odbc.ini FILE DATA…
Mark Richman
  • 28,948
  • 25
  • 99
  • 159
0
votes
3 answers

FreeTDS Bad token from the server (SQL Server)

Today we had a lot more activity than normal between our Ruby on Rails application and our remote legacy SQL Server 2005 database, and we started getting the error below intermittently. What is is? How can I prevent it (besides avoiding the…
ryw
  • 9,375
  • 5
  • 27
  • 34
0
votes
3 answers

mysql communicate with mssql on different server via php

I have mysql on a linux server which I own having CentOS installed in it. I want to fetch data from another windows server having mssql database. I need to create a php script that can get the values from mssql server and insert it into mysql…
user1325759
0
votes
2 answers

How to run Django on Windows and cope with Apache not having a daemon mode?

Evolution of this question This started as an attempt to find other recommendations for running Django on Linux, accessing SQL Server via Django-PyODBC, and supporting Unicode as competently as in installations running Django on Windows. After…
cethegeek
  • 6,286
  • 35
  • 42
0
votes
2 answers

Retrieve image data from mssql with php (utf-8)

From a php script (PHP 5.3.10-1 on Ubuntu3.6) I connect to an MSSQL Server and I would like to retrive image data from image field type. And I want to print it. I can get the data from MSSQL but I can't print/echo it as a valid image. How can I…
borazslo
  • 103
  • 1
  • 13
0
votes
4 answers

How to run a SQL script in tsql

I'm using tsql (installed with FreeTDS) and I'm wondering if there's a way to run a SQL script in tsql from the command line and get the result in a text file. For example, in psql I can do: psql -U username -C "COPY 'SELECT * FROM some_table' to…
Topo
  • 4,783
  • 9
  • 48
  • 70
0
votes
0 answers

Getting mssql_connect to work on MAMP Pro

Followed this tutorial http://thinkinkless.com/node/88 3 times now in an attempt to get mssql_connect to work on my mac (Mountain Lion) and no luck. I get the same error every time. PHP Fatal error: Call to undefined function mssql_connect() in…
brunam
  • 825
  • 2
  • 14
  • 26
1 2 3
…
43 44