freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: AW: AW: AW: [freetds] connect problem to mssql 7.0
- 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
-
AW: AW: AW: [freetds] connect problem to mssql 7.0
, (continued)
- AW: AW: AW: [freetds] connect problem to mssql 7.0, Roland Bole, 12/19/2003
- RE: AW: AW: [freetds] connect problem to mssql 7.0, ZIGLIO Frediano, 12/19/2003
-
RE: AW: AW: [freetds] connect problem to mssql 7.0,
ZIGLIO Frediano, 12/19/2003
- AW: AW: AW: [freetds] connect problem to mssql 7.0, Roland Bole, 12/19/2003
-
RE: AW: AW: [freetds] connect problem to mssql 7.0,
ZIGLIO Frediano, 12/19/2003
-
AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
-
AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
-
AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
-
Re: AW: AW: AW: [freetds] connect problem to mssql 7.0,
Frediano Ziglio, 12/20/2003
- AW: AW: AW: AW: [freetds] connect problem to mssql 7.0, Roland Bole, 12/23/2003
-
Re: AW: AW: AW: [freetds] connect problem to mssql 7.0,
Frediano Ziglio, 12/20/2003
-
Re: AW: AW: AW: [freetds] connect problem to mssql 7.0,
Frediano Ziglio, 12/20/2003
-
AW: AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
- Re: AW: AW: AW: AW: [freetds] connect problem to mssql 7.0, James K. Lowden, 12/20/2003
- AW: AW: AW: AW: [freetds] connect problem to mssql 7.0, Roland Bole, 12/20/2003
-
AW: AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
-
AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
-
AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
-
AW: AW: AW: [freetds] connect problem to mssql 7.0,
Roland Bole, 12/20/2003
Archive powered by MHonArc 2.6.24.