Re: [PHP] PHP and MSSQL on Linux

2005-11-08 Thread Richard Lynch
On Tue, November 1, 2005 8:03 pm, Robbert van Andel wrote: > A few months back I wrote the list asking for help making a connection > to a > MS SQL database from our linux webserver. At that time I was able to > make a > successfull connection on Fedora Core 1 after installing php-mssql.rpm > and

Re: [PHP] PHP and MSSQL on Linux

2005-11-03 Thread php
Well, I don't know why it didn't work on my test server, but when I installed the RPMs on my live server (I know, not the smartest thing to do, but I was desperate), the connection worked like a charm. Thanks to everyone who gave me some of their time. Robbert [EMAIL PROTECTED] wrote on 11/03/2

Re: Re: [PHP] PHP and MSSQL on Linux

2005-11-03 Thread php
Yes, it was as the apache user. Sorry I failed to mention that. Rick Emery <[EMAIL PROTECTED]> wrote on 11/03/2005, 04:43:03 PM: > Quoting [EMAIL PROTECTED]: > > > > > An interesting development. I found some reference to running my PHP > > script from the command line to take Apache out of th

Re: [PHP] PHP and MSSQL on Linux

2005-11-03 Thread Rick Emery
Quoting [EMAIL PROTECTED]: An interesting development. I found some reference to running my PHP script from the command line to take Apache out of the picture. Lo and behold, the script worked. I was able to connect to the server. So the issue seems to be related with Apache. Any idea what

Re: [PHP] PHP and MSSQL on Linux

2005-11-03 Thread Rick Emery
Quoting [EMAIL PROTECTED]: Thanks for your help. I'd love to hear if you have any success with the RPMs. Unfortunately (?) everything worked for me out-of-the-box. On a fresh FC4 box, I installed httpd and php, then downloaded and installed the freetds and php-mssql rpms. I copied an appli

Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread Ben
[EMAIL PROTECTED] said the following on 11/02/2005 10:30 AM: An interesting development. I found some reference to running my PHP script from the command line to take Apache out of the picture. Lo and behold, the script worked. I was able to connect to the server. So the issue seems to be rel

RE: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread Nathan Tobik
PROTECTED] Sent: Wednesday, November 02, 2005 1:30 PM To: php-general@lists.php.net Subject: Re: [PHP] PHP and MSSQL on Linux An interesting development. I found some reference to running my PHP script from the command line to take Apache out of the picture. Lo and behold, the script worked. I was

Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread php
An interesting development. I found some reference to running my PHP script from the command line to take Apache out of the picture. Lo and behold, the script worked. I was able to connect to the server. So the issue seems to be related with Apache. Any idea what I would need to do there to m

Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread php
Thanks for your help. I'd love to hear if you have any success with the RPMs. Something I've seen over and over again in the documentation is the compilation of php adding "--with-mssql". My PHP info output does not include that marker. The output is as follows './configure' '--build=i386-redh

Re: Re: Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread Rick Emery
Quoting [EMAIL PROTECTED]: Yup, I thought that was the problem too but when I added my server to the conf file, there was no change. When you set up your MSSQL connection in fedora, did you install anything else other than MSSQL and PHP-MSSQL? Or did you have to set anything in your php.ini f

Re: Re: Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread php
Yup, I thought that was the problem too but when I added my server to the conf file, there was no change. When you set up your MSSQL connection in fedora, did you install anything else other than MSSQL and PHP-MSSQL? Or did you have to set anything in your php.ini file to use the new extension?

Re: Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread Rick Emery
Quoting [EMAIL PROTECTED]: I get no output from mssql_get_last_message(). When I use the pear DB class, and use $db->getMessage(), I get "connect failed", very useful like usual with getMessage(). Even doing a print_r of the object reveals nothing. I'm pretty sure that PHP is not even tryin

Re: Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread php
I get no output from mssql_get_last_message(). When I use the pear DB class, and use $db->getMessage(), I get "connect failed", very useful like usual with getMessage(). Even doing a print_r of the object reveals nothing. I'm pretty sure that PHP is not even trying to connect to the database a

Re: [PHP] PHP and MSSQL on Linux

2005-11-02 Thread Rick Emery
Quoting Robbert van Andel <[EMAIL PROTECTED]>: Obvsiously, since I'm posting to the list, you can guess that it's not working. The error message I get back is useless as I'm only told that the connection failed. Does anyone know anything else I need to check to get the connection working? Wh

[PHP] PHP and MSSQL on Linux

2005-11-01 Thread Robbert van Andel
A few months back I wrote the list asking for help making a connection to a MS SQL database from our linux webserver. At that time I was able to make a successfull connection on Fedora Core 1 after installing php-mssql.rpm and a freetds rpm. When I upgradd to FC4, I was unable to continue my proj