Re: PHP 4.3.0 + MSSQL database authentication problem?
| From: | Frank M. Kromann | Date: | Tue, 11 Feb 2003 18:42:41 +0000 |
| Subject: | Re: PHP 4.3.0 + MSSQL database authentication problem? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25570@lists.php.net to get a copy of this message | ||
Hi Alan,
Did you configure FreeTDS with the right tdsver ? This can be none when
compiling FreetTDS using --with-tdsver=7.0 or in freetds.conf.
You should use the correct version according to your MSSQL server (70. =
SQL Server 7, 80 = SQL Server 2000).
From PHP 4.3.0 you can compile php using --with-mssql=/path/to/freetds.
FreeTDS needs to be compiled with --enable-msdblib, and you need to change
your code (sybase_* should be mssql_*). The upside is access to all the
mssql_* functions.
I'm using this on a Mandrake 9.0 system and it works fine (FreeTDS 0.61)
- Frank
> Hi Frank,
>
> --- "Frank M. Kromann" <frank@kromann.info> wrote:
> > I'm not sure what 'Control Panel PHP script' means ?
>
> I meant the PHP page itself that is the Control Panel
> (i.e., 's_controlpanel.php')
>
> > What version of FreeTDS are you using ?
>
> 0.60 on the new server; I am not sure about the
> currently working server, but I think it is 0.50 or
> 0.51.
>
> > Do you use the sybase or the mssql extension in PHP
>
> The Sybase one ('sybase_connect'). The PHP was
> compiled with the '--with-sybase=/path/to/freetds'
> option.
>
> Thanx!
>
> Alan
>
>
> ______________________________________________________________________
> Post your free ad now! http://personals.yahoo.ca
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>