linux php -> nt sql server

Hello,

How can I connect from a Linux Apache server with PHP 4.0 to a Windows NT SQL Server?

On NT this is easy (load the module), but on Linux I didn't see such an option. Also I didn't see anything like --with-mssql in configure. Is it even possible?

Thanks....

We found that using the Sybase Libs for MS-SQL server 6.5 and below works really well.
1. Download the Sybase database version that is free for development and deployment (11.0.3 I believe). Install it. You dont need to configure the database though.

2. Setup the interfaces file to point to your SQL Server. Look at the examples that might be in there.

3. Login into your Linux box as the sybase user, and test the connection by using isql:

isql -U<sql-server username> -P<password> -S<interfaces file server name>

run a query and this should be done in 10 minutes or less (not counting the download).

4. Compile apache/php as instructed, adding the -with-sybase=/path/to/sybase

This is my sample interfaces file:

------------------------------------
nt
master tcp ether 192.168.0.5 1433
query tcp ether 192.168.0.5 1433
----------------------------------------

192.168.0.5 is my SQL server.

Get more information here: http://www.mentalobjects.com/snippets.php?option=3&id=2


------------------
PHP, Perl, SQL Programming at http://www.mentalobjects.com



[This message has been edited by esconsult (edited May 24, 2000).]

Great! Thank you so much for your detailed explaination.. I'll give it a try right now...