#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    2
    Rep Power
    0
    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....
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    43
    Rep Power
    15
    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).]
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    2
    Rep Power
    0
    Great! Thank you so much for your detailed explaination.. I'll give it a try right now...

Similar Threads

  1. Envisage Windows 14.99 a Year: Envisage Linux 24.99 a Year:
    By smillward in forum Web Hosting Offers
    Replies: 3
    Last Post: February 17th, 2004, 01:19 PM
  2. Replies: 0
    Last Post: February 17th, 2004, 06:41 AM
  3. SQL Server -> AS/400
    By Fisherman in forum MS SQL Development
    Replies: 1
    Last Post: February 9th, 2004, 08:03 PM
  4. SQL Server Problem
    By Haekel in forum MS SQL Development
    Replies: 2
    Last Post: February 3rd, 2004, 05:42 AM

IMN logo majestic logo threadwatch logo seochat tools logo