Discussion:
[freetds] Unable to connect to server- cron job
Atul Dhanorker
2013-02-06 15:42:38 UTC
Permalink
Dear All,

I have recently installed FreeTDS to connect to sql server 2008. The php script works fine when I am running it through browser but using cron to run the same php file produces the following error:

PHP Warning: mssql_connect(): Unable to connect to server: BS in /var/www/report/inventory.php on line 29

Any advice would be helpful.

Atul Dhanorker


________________________________
THIS MESSAGE AND ANY INFORMATION OR ATTACHMENTS INCLUDED IS FOR THE SOLE USE OF THE INTENDED RECIPIENT(S) AND MAY CONTAIN CONFIDENTIAL OR PRIVILEGED INFORMATION. ANY UNAUTHORIZED REVIEW, USE, COPY, DISCLOSURE OR DISTRIBUTION OF THIS MESSAGE OR ATTACHMENTS IS STRICTLY PROHIBITED AND MAY BE SUBJECT TO PENALTY ACCORDING TO FEDERAL LAW 22 U.S.C. 2778 OF THE ARMS EXPORT CONTROL ACT. IF YOU ARE NOT AN INTENDED RECIPIENT, PLEASE NOTIFY THE SENDER BY RETURN E-MAIL AND DESTROY ALL COPIES OF THE MESSAGE AND ANY ATTACHEMENTS.

TECHNICAL INFORMATION IDENTIFIED AS ITAR OR EXPORT CONTROLED IS REGULATED BY U.S. EXPORT LAW AS CONTAINED IN THE INTERNATIONAL TRAFFIC IN ARMS REGULATIONS (ITAR). THIS TECHNICAL INFORMATION IS NOT TO BE PLACED IN THE PUBLIC DOMAIN, EXPORTED FROM THE U.S., OR GIVEN TO ANY FOREIGN PERSON IN THE U.S., WITHOUT THE PRIOR, SPECIFIC WRITTEN AUTHORIZATION FROM THE ORIGINATING SOURCE AND THE U.S. DEPARTMENT OF STATE OR THE U.S. DEPARTMENT OF COMMERCE AS APPLICABLE.
Frediano Ziglio
2013-02-06 16:19:51 UTC
Permalink
Post by Atul Dhanorker
Dear All,
PHP Warning: mssql_connect(): Unable to connect to server: BS in /var/www/report/inventory.php on line 29
Any advice would be helpful.
Atul Dhanorker
Hi,
usually this is due to some misconfiguration. PHP under web usually
use another user and different environment options. Probably it does
not pick up your freetds.conf.

Frediano
James K. Lowden
2013-02-06 21:15:48 UTC
Permalink
On Wed, 6 Feb 2013 09:42:38 -0600
Post by Atul Dhanorker
PHP Warning: mssql_connect(): Unable to connect to server: BS
in /var/www/report/inventory.php on line 29
Please see the faq http://www.freetds.org/faq.html#php.

Any suggestions you have for how to make that answer clearer would be
welcome.

--jkl

Continue reading on narkive:
Loading...