Solved

How to connect Linux-PHP to MS-SQL Server?

Posted on 2009-03-28
10
2,565 Views
Last Modified: 2013-12-12
Hi,

I have a Fedora 9 box where apache, php, mysql .. are running okay. I need to connect from this machine using php to a MS-SQL Server that is in same network. To do this we were trying to install free tds as per article - http://www.linuxjournal.com/article/6636

but while configuring:
[root@localhost]# tar xvfz freetds-0.60.tgz
[root@localhost]# cd freetds-0.60
[root@localhost]# ./configure --with-tdsver=7.0 --with-unixodbc
but this will show a error message -
"configure: sql.h file not found"

I have googeled a lot still dont know how to resolve this sql.h issue or how to get the file.

Will highly appreciate any help on this .. or if any alternative way to connect to MS-SQL server is available .

Thanks and regards,
Sabbir
0
Comment
Question by:Sabbir456
10 Comments
 
LVL 12

Expert Comment

by:udayakumarlm
ID: 24012346
you will require the FreeTDS Library from http://www.freetds.org/
you can find the follwoing link contains a step by step of setting up and useing MSSQL in PHP
read the requirements session and more details at http://in.php.net/manual/en/book.mssql.php
0
 

Author Comment

by:Sabbir456
ID: 24016024
To udayakumarlm:

1)  Yes I have downloaded the Freetds .. and while try to configure it on my fedora 9

[root@localhost]# ./configure --with-tdsver=7.0 --with-unixodbcbut this will show a error message - "configure: sql.h file not found"

please refer to my problem details posted earlier.

2) The other link you provided only refer to connecting form windows-php to MSSQL but I need to connect to Linux-php tp MSSQL


0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24053644
you can try:
HOWTO: Connect RubyOnRails on Fedora Linux to SQL2005
http://www.not404.com/Howto_SQL2005_From_RailsOnFedora 
 
Accessing Microsoft SQL Server (mssql) from PHP under Apache on Unix or Linux
http://www.easysoft.com/developer/languages/php/sql_server_unix_tutorial.html
 
---
also see
"configure: sql.h file not found"
http://lists.ibiblio.org/pipermail/freetds/2008q3/023734.html
http://archives.devshed.com/forums/development-94/tdsodbc-h-26-sql-h-no-such-file-or-directory-982422.html 
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 29

Expert Comment

by:Michael W
ID: 24054380
Since your running Fedora 9, have you tried 'yum install freetds'?
0
 
LVL 29

Accepted Solution

by:
Michael W earned 500 total points
ID: 24054406
Or better yet...

The php-mssql package contains a dynamic shared object that will add MSSQL database support to PHP. It uses the TDS (Tabular DataStream) protocol through the freetds library, hence any database server which supports TDS can be accessed.

http://rpmfind.net/linux/rpm2html/search.php?query=php-mssql

Try: yum install php-mssql
0
 

Author Comment

by:Sabbir456
ID: 24066136
Hi,

I am trying your suggested solutions .. will get back with results. Thanks a lot.

regards,
Sabbir

0
 

Author Comment

by:Sabbir456
ID: 24085178
hi mwecomputers,

both yum install freetds and  yum install php-mssql worked fine.


was able to connect to SQL Server 2005 using mssql_connect
Thanks ...... a lot.

Sabbir


0
 
LVL 29

Expert Comment

by:Michael W
ID: 24086032
Glad I could help.

-- Michael
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Tsql query 6 22
SSRS Enable Remote Errors 4 27
Query to capture 5 and 9 digit zip code? 4 22
SQL Server 2015 Restore - doing it right 2 16
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question