Re: PHP on Linux connecting to MS SQL
| From: | Brian Neal | Date: | Fri, 09 Jun 2000 08:26:20 +0000 |
| Subject: | Re: PHP on Linux connecting to MS SQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-282@lists.php.net to get a copy of this message | ||
$dbserver should not be the actual network hostname, but the database server
name listed in your Sybase interfaces file (look in the $SYBASE directory).
-Brian
>Date: Thu, 08 Jun 2000 18:21:58 -0400
>From: Sarah Kerr <skerr@bellanet.org>
>MIME-Version: 1.0
>To: "Ulrich, Eric J" <eric.j.ulrich@intel.com>
>CC: php-db@lists.php.net
>Content-Transfer-Encoding: 7bit
>Subject: [PHP-DB] PHP on Linux connecting to MS SQL
>
>Eric,
>Thanks for the tip!
>I installed Sybase's ASE, and recompiled php3 & 4 with the sybase
>option.
>If you could spare the time, I was wondering if there were any further
>configurations you could give me the heads up on, however, since when I
>run the following:
>
><?php
>
>$dbserver = '198.62.158.146';
>$dbuser = 'sa';
>$dbpass = 'my_pass';
>
>$link = mssql_connect($dbserver, $dbuser, $dbpass)
> or die("error");
>?>
>
>"error" will be printed.
>
>I've also tried with other values for $dbserver such as the name of the
>machine (local & external names). Any suggestions?
>
>Thanks!
>Sarah
>
>
>"Ulrich, Eric J" wrote:
>>
>> Sarah, I use the same setup you describe. I downloaded the Sybase DB server
>> for Linux and compile PHP4 or PHP3 with the Sybase option. The nice thing is
>> that almost all the sybase_ and mssql_ functions are interchangeable meaning
>> between Windows OS and Linux. It works great.
>> Eric Ulrich
>>
>> -----Original Message-----
>> From: Sarah Kerr [mailto:skerr@bellanet.org]
>> Sent: Thursday, June 08, 2000 8:00 AM
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] PHP on Linux connecting to MS SQL
>>
>> Hi,
>>
>> I've been having a lot of trouble finding appropriate documention on
>> connecting to databases in MS SQL from Linux, so that i'm able to use
>> the mssql set of functions in PHP.
>> I'm using RH Linux 6.2, PHP 4, and MS SQL 7.
>> If anyone has done this, or can point me to clear documentation on how
>> to do it, i'd be very greatful!
>>
>> Thanks,
>> Sarah
>>
>> --
>> Sarah Kerr
>> Bellanet International Secretariat
>> http://www.bellanet.org
>> 613-236-6163 ext. 2192