Skip to Content.
Sympa Menu

freetds - RE: AW: AW: [freetds] connect problem to mssql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: AW: AW: [freetds] connect problem to mssql 7.0
  • Date: Fri, 19 Dec 2003 15:44:47 +0100

>
> >
> > Now i have rebuild php and i have also a new build date, that is ok,
> >
> > Tsgl work, ok
> >
>
> Well
>
> > Mssql_pconnect, can not connect to sql server ????
> >
>
> > >If data get returned mssql_pconnect have to work...
>
> $db_conn = mssql_pconnect ($sql_host,$sql_user,$sql_pass) or
> die ("Could not connect to database: ".mssql_get_last_message());
>
> This is the last report:
> Could not connect to database: Changed language setting to us_english.
>
> DB settings the same like bevor.
>
>

"Changed language setting to us_english" it's just a message from
server, however connect fails...
Did you remember that usually apache use another user (nobody or apache
usually) and that ~/.freetds.conf work only for your user?
If you use

tsql -Smyserver -Umyuser -Pmypassword

you should have

$sql_host = 'myserver';
$sql_user = 'myuser';
$sql_pass = 'mypassword';

in your script.

Also fill correct freetds.conf file (I think
/usr/local/freetds/etc/freetds.conf if you configured FreeTDS with
--prefix=/usr/local/freetds)

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page