Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • Last Modified:

ODBC connection to Linux Apache

I'm trying to learn PHP and need to connect SQL Server 7 with ODBC to a Linux Apache server. Any ideas?  
0
gsoldado
Asked:
gsoldado
1 Solution
 
vsamtaniCommented:
From the PHP FAQ:

http://www.php.net/FAQ.php#4.1

"On Unix machines, you can use the Sybase-CT driver to access Microsoft SQL Servers because they are (at least mostly) protocol-compatible. Sybase has made a free version of the necessary libraries for Linux systems. For other Unix operating systems, you need to contact Sybase for the correct libraries."

They supply a link to http://www.php.net/extra/ctlib-linux-elf.tar.gz

You would then compile php with the --with-sybase-ct option.

Vijay
0
 
jlevieCommented:
FreeTDS would be one way to connect PHP on Linux to an mssql (yuk!) database (see http://www.freetds.org/). But if the goal is simply to learn PHP you'd be served just as well by installing MySQL or Postgres on the Linux system and using native PHP connections to the database.
0
 
vsamtaniCommented:
If you really need to connect to your MS-SQL database via ODBC, then you need to get Linux ODBC drivers for MS-SQL from http://www.openlinksw.com/ - they have free downloads for 2-user versions of the drivers. You may also need the ODBC driver manager for Linux, from www.iodbc.org . Then you'd be compiling php with the --with-iodbc option, and connecting to your MS-SQL database via the odbc_* functions.

Vijay
0
 
CleanupPingCommented:
gsoldado:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
majorwooCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: vsamtani {http:#6149058}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

majorwoo
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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