RE: [PHP-DB] PHP on Linux connecting to MS SQL

Sarah, from Linux you must use the sybase_ functions because you are using the sybase libs with PHP from a windows machine you can use the same code just search and replace sybase_ with mssql_ and as long as you have the mssql connect to setup right it will work, which is nice. As for your $dbserver normally you setup your interfaces file like this: Server Name: SERVER1_DS Listener services aval: (hostname)server1.local.com (PORT of SQL) (shortname)server1 and you then use the SERVER1_DS for your $dbserver. Good luck, Eric Ulrich -----Original Message----- From: Sarah Kerr [mailto:skerr@bellanet.org] Sent: Thursday, June 08, 2000 3:22 PM To: Ulrich, Eric J Cc: php-db@lists.php.net 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net