Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: AW: AW: AW: [freetds] connect problem to mssql 7.0
  • Date: Sat, 20 Dec 2003 09:09:04 -0000

Il sab, 2003-12-20 alle 09:36, Roland Bole ha scritto:
> I have also established connections, see netstat -ap according to the PID
>
> ------------
> tcp 0 0 xxx.xxx.xxx.xxx:34061 elbefs01:1433
> ESTABLISHED 18597/httpd
> tcp 0 0 xxx.xxx.xxx.xxx:www 81-223-154-70.dyna:4529
> ESTABLISHED 18597/httpd
> ------------
>

Good! Also note that connection is ESTABLISHED so nobody close it.

> Why mssql_pconnect returns false ????
>
...
>
> Mysql_pconnect have to connect, because: I can see it in the freetds.log
>
> --
> iconv to convert client-side data to the "ISO-8859-1" character set
> 07:36:57.763837 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> 07:36:57.763998 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> 07:36:57.764078 Connecting to xxx.xxx.xxx.xxx port 1433, TDS 7.0.
> ---
> There is no error
>

Well this part of log tell me that FreeTDS tried to connect... Perhaps
some more lines can help me more...
Is written IP right ??

> And also php last function: mssql_get_last_message()
> Give me the following message:
>
> Changed language setting to us_english.
>
> So there must be a connect ???? Is this right????
>

It seems so, sql server return this message AFTER connection...

> BUT PHP can not make a "true" connection, because mysql_pconnect returns
> false.
>
> Tsgl can connect successfully and I can also make some sql queries.
>

I think you mean tsql here...

> $db_conn = mssql_pconnect ($sql_host,$sql_user,$sql_pass) or
> die ("Could not connect to database: ".mssql_get_last_message());
>
> $sql_host,$sql_user,$sql_pass have the right values like I use in tsgl,
> that´s OK,
>
> The question is: why php can not return true, if there is a connect (see
> freetds.log)
>
> The only error which is reported is during the ececution of the query with
> tsgl:
> -----------
> ZUM ZAUCHNERWIRT
> ZUPAN PATRICIA
> Msg 2403, Level 16, State 0, Server OpenClient, Line 0
> WARNING! Some character(s) could not be converted into client's character
> set. Unconverted bytes were changed to question marks ('?').
> Z?RICH KOSMOS
> ------------------
>

This is NOT an error !!


>
> what can I do ?????
>

I don't know...

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page