-Original Message-
From: owner-freebsd-questi...@freebsd.org
[mailto:owner-freebsd-questi...@freebsd.org] On Behalf Of Peter Vereshagin
Sent: 04 March 2012 17:05
To: freebsd-questions@freebsd.org
Subject: Re: lighttpd + php + external mssql server
Hello.
2012/03/03 00:32:40 + Graeme Dargie a...@tangerine-army.co.uk = To
'freebsd-questions@freebsd.org' :
GD I am just looking for some advice or hints if anyone has a clue how to make
a FreeBSD server running lighttpd + php5 connect to an instance of MS SQL 2008
R2.
GD
GD I have already installed php-extensions for mssql but when I try and
GD run a connection from the FreeBSD server it gives a http 500 The
GD error log has this
GD 2012-03-02 18:20:09: (mod_fastcgi.c.2699) FastCGI-stderr: PHP Fatal
GD error: Call to undefined function mssql_connect() in
GD /usr/local/www/data/
GD
GD Php -m shows mssql as installed.
1) Command-line php and fastcgi php are able to have a different set of
extensions. Look at the phpinfo() output from your fastcgi if it has an mssql
extension.
2) You may want to try an ODBTP extension for mssql connectivity which supports
mssql features like 'go' clause batch runs and scroll cursors with fetching
from them on the contrast to the 'traditional' dblib-based mssql php extension.
--
Peter Vereshagin pe...@vereshagin.org (http://vereshagin.org) pgp: A0E26627
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
You are spot on Peter, phpinfo() shows no mssql extension, so I am guessing the
next question is does it have such an extension and if so how to enable it,
there are no make config options for the fastcgi I can see in ports. I am doing
this so I can do some work at home for a project that will be looked at
elsewhere so portability is a major concern.
Regards
Graeme
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org