RE: [PHP] MSSQL, PHP and Linux
[snip] On Thursday 02 September 2004 08:30, blackwater dev wrote: the date is a very good question? Here is the info from my system -rwxr-xr-x1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. But that's probably your php-cli version. Are you using the Apache module version of PHP? I didn't see it in the configure command you posted previously. [/snip] Make sure that you do a 'make clean'. I have found that phpinfo() does not get updated properly but the functions may still work. Doing a 'make clean' will insure that the info is updated properly. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MSSQL, PHP and Linux
I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to undefined function mssql_pconnect()...what can I try next? Is there anything that needs to be changed in the linux php ini file? It looked like most things where uncommented. here is the info page... http://mwvre.ht-tech.net/info.php This is something we have to get fixed today. Thanks!! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
Hi, You should compile php with this option --with-mssql or --with-mssql=/path/to/freetds. This will enable the mssql extension. Enabling the DBX extension is not enough. DBX is just a wrapper arround other extensions. You still need to compile each of these extensions. - Frank I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to undefined function mssql_pconnect()...what can I try next? Is there anything that needs to be changed in the linux php ini file? It looked like most things where uncommented. here is the info page... http://mwvre.ht-tech.net/info.php This is something we have to get fixed today. Thanks!! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
blackwater dev wrote: I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to undefined function mssql_pconnect()...what can I try next? Is there anything that needs to be changed in the linux php ini file? It looked like most things where uncommented. here is the info page... http://mwvre.ht-tech.net/info.php This is something we have to get fixed today. Thanks!! dbx is not mssql. dbx functions start with dbx_* http://sk.php.net/dbx -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
-- Original message from blackwater dev : -- I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to undefined function mssql_pconnect()...what can I try next? The dbx extension is compiled in, not the mssql extension. You need to either use the functions in the dbx extension to do what you want, or if you would rather use the mssql functions you need to compile in the mssql extension. http://us3.php.net/manual/en/ref.dbx.php http://us3.php.net/manual/en/ref.mssql.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
From: blackwater dev [EMAIL PROTECTED] I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to undefined function mssql_pconnect()...what can I try next? Are you using the dbx functions and not mssql_connect/pconnect()?? http://www.php.net/manual/en/ref.dbx.php ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] MSSQL, PHP and Linux
Hmm, I do see the MS SQL listed under DBX, but I don't see the --with=mssql in the configure line. Only psql and mysql. Does that need to be in there also? -Dan Joseph -Original Message- From: blackwater dev [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:19 PM To: [EMAIL PROTECTED] Subject: [PHP] MSSQL, PHP and Linux I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to undefined function mssql_pconnect()...what can I try next? Is there anything that needs to be changed in the linux php ini file? It looked like most things where uncommented. here is the info page... http://mwvre.ht-tech.net/info.php This is something we have to get fixed today. Thanks!! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
No, I was using the mssql functions which I want to use.
I tried the dbx functions example:
$link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass);
but go the error that the mssql module isn't loaded.
On Wed, 1 Sep 2004 14:06:55 -0400, John Holmes [EMAIL PROTECTED] wrote:
From: blackwater dev [EMAIL PROTECTED]
I need some help...I am helping a local business with a site which
needs to connect to a mssql db, my webhost uses linux and compiled php
with the freetds library and when I go to the info page..it does show
Microsoft SQL Server under dbx yet I still get the errors called to
undefined function mssql_pconnect()...what can I try next?
Are you using the dbx functions and not mssql_connect/pconnect()??
http://www.php.net/manual/en/ref.dbx.php
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
Like I and others have said, you need to compile PHP --with-mssql
Blackwater Dev wrote:
No, I was using the mssql functions which I want to use.
I tried the dbx functions example:
$link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass);
but go the error that the mssql module isn't loaded.
On Wed, 1 Sep 2004 14:06:55 -0400, John Holmes [EMAIL PROTECTED] wrote:
From: blackwater dev [EMAIL PROTECTED]
I need some help...I am helping a local business with a site which
needs to connect to a mssql db, my webhost uses linux and compiled php
with the freetds library and when I go to the info page..it does show
Microsoft SQL Server under dbx yet I still get the errors called to
undefined function mssql_pconnect()...what can I try next?
Are you using the dbx functions and not mssql_connect/pconnect()??
http://www.php.net/manual/en/ref.dbx.php
---John Holmes...
--
Regards,
Ben Ramsey
http://benramsey.com
---
http://www.phpcommunity.org/
Open Source, Open Community
Visit for more information or to join the movement.
---
PGP Key ID: 0x3968B5EE
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
We just tried again with the -mssql switch but it still doesn't seem
to be therethe -mssql isn't on the info page...I don't have a
clue...
http://mwvre.ht-tech.net/info.php
On Wed, 01 Sep 2004 15:08:41 -0400, Ben Ramsey [EMAIL PROTECTED] wrote:
Like I and others have said, you need to compile PHP --with-mssql
Blackwater Dev wrote:
No, I was using the mssql functions which I want to use.
I tried the dbx functions example:
$link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass);
but go the error that the mssql module isn't loaded.
On Wed, 1 Sep 2004 14:06:55 -0400, John Holmes [EMAIL PROTECTED] wrote:
From: blackwater dev [EMAIL PROTECTED]
I need some help...I am helping a local business with a site which
needs to connect to a mssql db, my webhost uses linux and compiled php
with the freetds library and when I go to the info page..it does show
Microsoft SQL Server under dbx yet I still get the errors called to
undefined function mssql_pconnect()...what can I try next?
Are you using the dbx functions and not mssql_connect/pconnect()??
http://www.php.net/manual/en/ref.dbx.php
---John Holmes...
--
Regards,
Ben Ramsey
http://benramsey.com
---
http://www.phpcommunity.org/
Open Source, Open Community
Visit for more information or to join the movement.
---
PGP Key ID: 0x3968B5EE
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds
It all appears to compile correctly, except the info page does not
reflect the config was done with mssql at all. below is a snippet of
the config switches that were used.
--enable-ftp \
--enable-magic-quotes \
--enable-safe-mode \
--enable-sockets \
--enable-sysvsem \
--enable-sysvshm \
--enable-discard-path \
--enable-track-vars \
--enable-trans-sid \
--enable-yp \
--enable-wddx \
--without-oci8 \
--with-pear=/usr/share/pear \
--with-imap=shared \
--with-imap-ssl \
--with-kerberos=/usr/kerberos \
--with-ldap=shared \
--with-mysql=shared,%{_prefix} \
--with-sybase=/usr/include/freetds \
--with-mssql=/usr/include/freetds \
Any help would be appreciated.
thanks,
On Wed, 1 Sep 2004 08:29:55 -1200, blackwater dev
[EMAIL PROTECTED] wrote:
We just tried again with the -mssql switch but it still doesn't seem
to be therethe -mssql isn't on the info page...I don't have a
clue...
http://mwvre.ht-tech.net/info.php
On Wed, 01 Sep 2004 15:08:41 -0400, Ben Ramsey [EMAIL PROTECTED] wrote:
Like I and others have said, you need to compile PHP --with-mssql
Blackwater Dev wrote:
No, I was using the mssql functions which I want to use.
I tried the dbx functions example:
$link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass);
but go the error that the mssql module isn't loaded.
On Wed, 1 Sep 2004 14:06:55 -0400, John Holmes [EMAIL PROTECTED] wrote:
From: blackwater dev [EMAIL PROTECTED]
I need some help...I am helping a local business with a site which
needs to connect to a mssql db, my webhost uses linux and compiled php
with the freetds library and when I go to the info page..it does show
Microsoft SQL Server under dbx yet I still get the errors called to
undefined function mssql_pconnect()...what can I try next?
Are you using the dbx functions and not mssql_connect/pconnect()??
http://www.php.net/manual/en/ref.dbx.php
---John Holmes...
--
Regards,
Ben Ramsey
http://benramsey.com
---
http://www.phpcommunity.org/
Open Source, Open Community
Visit for more information or to join the movement.
---
PGP Key ID: 0x3968B5EE
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
Just try --with-mssql=/usr/include instead. Is that where freetds is
installed for you? I think it's in /usr/local for me, so I use
--with-mssql=/usr/local.
Blackwater Dev wrote:
I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds
It all appears to compile correctly, except the info page does not
reflect the config was done with mssql at all. below is a snippet of
the config switches that were used.
--enable-ftp \
--enable-magic-quotes \
--enable-safe-mode \
--enable-sockets \
--enable-sysvsem \
--enable-sysvshm \
--enable-discard-path \
--enable-track-vars \
--enable-trans-sid \
--enable-yp \
--enable-wddx \
--without-oci8 \
--with-pear=/usr/share/pear \
--with-imap=shared \
--with-imap-ssl \
--with-kerberos=/usr/kerberos \
--with-ldap=shared \
--with-mysql=shared,%{_prefix} \
--with-sybase=/usr/include/freetds \
--with-mssql=/usr/include/freetds \
Any help would be appreciated.
thanks,
On Wed, 1 Sep 2004 08:29:55 -1200, blackwater dev
[EMAIL PROTECTED] wrote:
We just tried again with the -mssql switch but it still doesn't seem
to be therethe -mssql isn't on the info page...I don't have a
clue...
http://mwvre.ht-tech.net/info.php
On Wed, 01 Sep 2004 15:08:41 -0400, Ben Ramsey [EMAIL PROTECTED] wrote:
Like I and others have said, you need to compile PHP --with-mssql
Blackwater Dev wrote:
No, I was using the mssql functions which I want to use.
I tried the dbx functions example:
$link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass);
but go the error that the mssql module isn't loaded.
On Wed, 1 Sep 2004 14:06:55 -0400, John Holmes [EMAIL PROTECTED] wrote:
From: blackwater dev [EMAIL PROTECTED]
I need some help...I am helping a local business with a site which
needs to connect to a mssql db, my webhost uses linux and compiled php
with the freetds library and when I go to the info page..it does show
Microsoft SQL Server under dbx yet I still get the errors called to
undefined function mssql_pconnect()...what can I try next?
Are you using the dbx functions and not mssql_connect/pconnect()??
http://www.php.net/manual/en/ref.dbx.php
---John Holmes...
--
Regards,
Ben Ramsey
http://benramsey.com
---
http://www.phpcommunity.org/
Open Source, Open Community
Visit for more information or to join the movement.
---
PGP Key ID: 0x3968B5EE
--
Regards,
Ben Ramsey
http://benramsey.com
---
http://www.phpcommunity.org/
Open Source, Open Community
Visit for more information or to join the movement.
---
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
-- Original message from blackwater dev : -- I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds It all appears to compile correctly, except the info page does not reflect the config was done with mssql at all. below is a snippet of the config switches that were used. http://mwvre.ht-tech.net/info.php It also shows a build date in June. Did you restart apache? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
On Wed, Sep 01, 2004 at 04:39:51PM -0400, blackwater dev wrote:
I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds
It all appears to compile correctly, except the info page does not
reflect the config was done with mssql at all. below is a snippet of
the config switches that were used.
--enable-ftp \
--enable-magic-quotes \
--enable-safe-mode \
--enable-sockets \
--enable-sysvsem \
--enable-sysvshm \
--enable-discard-path \
--enable-track-vars \
--enable-trans-sid \
--enable-yp \
--enable-wddx \
--without-oci8 \
--with-pear=/usr/share/pear \
--with-imap=shared \
--with-imap-ssl \
--with-kerberos=/usr/kerberos \
--with-ldap=shared \
--with-mysql=shared,%{_prefix} \
--with-sybase=/usr/include/freetds \
--with-mssql=/usr/include/freetds \
Any help would be appreciated.
thanks,
It looks like you compiled it OK. Did you do a 'make install' afterwards? Did
you restart the Apache server? I recently built PHP (4.3.8) with support for MS
SQL and that was all I needed to do.
--
Jim Kaufman
Linux Evangelist
public key 0x6D802619
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
the date is a very good question? Here is the info from my system -rwxr-xr-x1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. On Wed, 01 Sep 2004 22:29:41 +, Jennifer Goodie [EMAIL PROTECTED] wrote: -- Original message from blackwater dev : -- I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds It all appears to compile correctly, except the info page does not reflect the config was done with mssql at all. below is a snippet of the config switches that were used. http://mwvre.ht-tech.net/info.php It also shows a build date in June. Did you restart apache? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
-- Original message from blackwater dev : -- the date is a very good question? Here is the info from my system -rwxr-xr-x 1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. Are you sure apache is loading the version you just built and not an old one in some other location (possibly /etc)? Did you read the install instructions for PHP with Apache 2.0 on a Linux system? Check step 14 and make sure you are loading the module from the correct location. Just a guess, but since none of your new configure flags are showing on the php info page and the build time is old, it looks like you are not running from the location you think you are. http://us3.php.net/manual/en/install.unix.apache2.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MSSQL, PHP and Linux
On Thursday 02 September 2004 08:30, blackwater dev wrote: the date is a very good question? Here is the info from my system -rwxr-xr-x1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. But that's probably your php-cli version. Are you using the Apache module version of PHP? I didn't see it in the configure command you posted previously. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* A father doesn't destroy his children. -- Lt. Carolyn Palamas, Who Mourns for Adonais?, stardate 3468.1. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
