• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2616
  • Last Modified:

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

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
Sabbir456
Asked:
Sabbir456
1 Solution
 
udaya kumar laligondlaTechnical LeadCommented:
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
 
Sabbir456Author Commented:
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
 
Eugene ZCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
Since your running Fedora 9, have you tried 'yum install freetds'?
0
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
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
 
Sabbir456Author Commented:
Hi,

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

regards,
Sabbir

0
 
Sabbir456Author Commented:
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
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
Glad I could help.

-- Michael
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now