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
0
votes
1 answer
php sybase Allowed memory size exhausted?
I'm getting this problem while trying to run any query against Sybase from php:
PHP 5.4.3 (cgi-fcgi) (built: May 9 2013 17:03:23)
built --with-sybase-ct=/path/to/freetds
code:
Dmitry z
- 4,533
- 4
- 15
- 15
0
votes
0 answers
PDO issue in Laravel 4 when using an artisan command
I am trying to build a artisan command that will connect to a remote MSSQL server, retrieve some records and store them in the local MySQL db.
The query I am performing is DB::connection('sqlsrv')->select('SELECT * FROM Users')
If I use the above in…
darronz
- 903
- 9
- 17
0
votes
1 answer
Only able to issue one sql statement from isql
I'm running Debian opening up an ODBC connection to an MSSQL database on the network. When I run isql I can issue one sql statement fine. If I issue the same request a second time it returns 0 rows. If I run the same command a third time the…
ThrowsException
- 2,586
- 20
- 37
0
votes
1 answer
PHP using mssql_fetch_array returning NULL Values
Okay this is weird to me, but I'm hoping this is an issue that's happened and I have just not found the solution online yet.
Help is very much appreciated.
I am doing a call to a stored procedure on a MS 2008 SQL server. Using SQL Server Management…
user1399840
- 53
- 1
- 8
0
votes
1 answer
the cursor was not declared error with php odbc driver(query works in sql management studio)
I have this query that is executed in my php code:
SELECT ((SUM(CASE WHEN I.InCompliance=1 AND FI.Status='C' THEN 1 ELSE 0 END)*100) / (SUM(CASE WHEN FI.Status='C' THEN 1 ELSE 0 END))) as result
FROM tbl_Inspection I,tbl_Facility…
dsauerbrun
- 13
- 1
- 5
0
votes
1 answer
Yii + PDO_DBLIB + SQL Server
My website based on yii framework and I work with SQL Server (on Windows) under linux using pdo_dblib + freetds.
My FreeTDS config:
[egServer70]
host = my server ip address
port = 1433
tds version = 8.0
client…
smokeelow
- 85
- 1
- 10
0
votes
1 answer
Query timing out in php with sybase
I am puzzled about a recent problem I'm getting, there's a query that has always work before and started acting up recently. It is timing out after 60 seconds. It is a very heavy query, however worked before and I have copy pasted the query into…
Rayfloyd
- 273
- 3
- 17
0
votes
1 answer
How to connect MSQL via unixodbc and freetds using PHP?
As described in a previous question, freetds and unixodbc are installed on Lion and tested with isql, I tried to connect to MSSQL using PHP:
$connection = odbc_connect('SMS_GTWY', 'username', 'password');
However, it returns:
PHP Warning: …
ohho
- 50,879
- 75
- 256
- 383
0
votes
1 answer
Rails - tinytds crashing ruby
When querying MSSQL 2008 database using freetds and tinytds gem with syntax below:
db = TinyTds::Client.new(:username => ...)
select = db.execute("EXEC dbo.__stored_procedure__")
db.close
Then this line is causing ruby to crash on…
igy
- 1
- 1
0
votes
2 answers
Syntax error when running FreeTDS Configure file
I'm attempting to run Ruby on Rails and connect to a MS SQL DB. I have RoR installed and I have created the database to which I'll be connecting. I created and Test Model and when attempting $ rake db:migrate I got a rake aborted error (no such file…
Was-a-golfer
- 11
- 1
- 2
0
votes
2 answers
What are configs for Drupal7 + SQL Server using FreeTDS?
we already have a Moodle installation working in this scenario: linux + php5 + freetds + sql server.
but we just can't figure out how to link drupal 7 to sql server in the same manner.
what configs should we use? anyone ever tried this?
drupal…
marquito
- 885
- 11
- 29
0
votes
1 answer
Slow query on remote database
I have:
A linux server with PHP 5.3.2 and Apache 2.0
A windows Server with SQL SERVER
I connect my linux server with database with unixODBC 2.3.1 and FREETDS 0.9.1
The connection is okay but the queries are slow.
Here is my code that generate the…
user1418446
- 29
- 4
0
votes
1 answer
Unable to find freeTDS version
I am trying to find freeTDS version 0.82 specifically but havent been successful in that.I go to this site and it gives me this link .But when I download the file and unzip it - that shows version 0.91.I am specifically looking for version .82.Does…
Manish
- 1,729
- 5
- 32
- 47
0
votes
1 answer
Can't compile ruby-dbi
For a legacy project I have to install ruby-dbi (dbi-0.1.1). When I try to run sudo ruby setup.rb setup, I have the following installation error:
eianni@ianni-desktop:~/Desktop/ruby-dbi$ sudo ruby setup.rb setup
entering setup phase...
setting #!…
dierre
- 7,140
- 12
- 75
- 120
-1
votes
1 answer
How compile the FreeTDS with OpenSSL for Win32?
Please explain in detail (step by step) how to compile FreeTDS with OpenSSL for Win32?
I tried it like this:
Download and extract freetds-1.3.18.tar.gz from https://www.freetds.org/
Run CMake => Configure, Generate, Open Project.
In Visual Studio…
CuriousMax
- 26
- 6