FreeTDS Development Group

[Robert Gonzalez <robert AT robert-gonzalez.com>]

You need to set some environment variables into the apache environment
variables list (on Ubuntu it's at /etc/apache2/envvars). I wrote up how I
got all my stuff working on Ubuntu here:
http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/

I know the OSes are different, but maybe it will help you get this thing
rolling.

Oh yeah, and don't forget to restart apache after changing the envvars file.
;)

On Sun, Jul 26, 2009 at 8:17 PM, Joshua <joshuajoe AT gmail.com> wrote:

> After recompiling on the newest version of FreeTDS (8.3) it seems my
> command line php user can access the database, and the webserver user
> cannot:
>
> <?php
> var_dump(mssql_connect('BLKDB04.weblinkconnect.com:1433
> ','WLafINhaanmcRO','---snip---'));
> var_dump(mssql_select_db('WLafayetteINCOC'));
> ?>
>
> Returns the following baffling results:
>
> command line: php -f ~/data/testmssql.php
> -> resource(4) of type (mssql link)
> -> bool(true)
>
> http://n2.greaterlafayettecommerce.com/testmssql.php
> -> bool(false)
> -> bool(false)
>
> Upon further investigation, on the good connection, FreeTDS is
> recieving all of the correct credentials. On the webserver side, it is
> searching for "SYBASE" -- which means it's defaulting, I think.
>
> Ideas?
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 

Robert Gonzalez
http://www.robert-gonzalez.com