Re: help about freetds and php

What flavor of linux are you running? I had to handle it two different when
installing on Red Hat (Fedora) and Debian (Ubuntu) versions.

On Sat, Feb 21, 2009 at 2:32 AM, shiqiang.yan <[email protected]>wrote:

>
> hi:
>    i set up freetds and php to connect sql 2005.
>
>   ./configure --prefix=/opt/deploy/amp/freetds --with-tdsver=8.0
> --enable-msdblib --enable-dbmfix --with-gnu-ld
>   make
>   make install
>
>
>   Using tsql I success.
>   tsql -S msserver -U sa
>
>   I build the php extension.
>
>   BUT faild using php ,  the scripts is :
>
>  <?php
>  putenv('TDSVER=80');
>  $hostname = "msserver_ipaddress:1433";
>  $user="sa";
>  $passwd="xxxxxxx";
>  $db_id = mssql_connect($hostname,$dbuser,$dbpasswd) or die("Couldn't
> connect the server!\
> n");
>  mssql_close($db_id);
> ?>
>
>   Who could help to sovle the problem? Thank you very much!
>
> I capute the info dump as below:
>
>    log.c:190:Starting log file for FreeTDS 0.82
>    on 2009-02-21 17:11:55 with debug flags 0x4fff.
> iconv.c:197:names for ISO-8859-1: ISO-8859-1
> iconv.c:197:names for UTF-8: UTF-8
> iconv.c:197:names for UCS-2LE: UCS-2LE
> iconv.c:197:names for UCS-2BE: UCS-2BE
> iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character
> set
> iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> net.c:210:Connecting to 202.206.32.203 port 1433 (TDS version 8.0)
> net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:303:tds_open_socket() succeeded
> util.c:162:Changed query state from DEAD to IDLE
> util.c:162:Changed query state from IDLE to DEAD
> util.c:334:tdserror(0x96c5160, 0x9706278, 20002, 0)
> dblib.c:7782:dbperror(0x9705b10, 20002, 0)
> dblib.c:7835:20002: "Adaptive Server connection failed"
> dblib.c:7856:"Adaptive Server connection failed", client returns 2
> (INT_CANCEL)
> util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
> util.c:389:tdserror: returning TDS_INT_CANCEL(2)
> dblib.c:1372:dbclose(0x9705b10)
> dblib.c:256:dblib_del_connection(0x23e3a0, 0x9706278)
> mem.c:563:tds_free_all_results()
> dblib.c:303:dblib_release_tds_ctx(1)
> dblib.c:5727:dbfreebuf(0x9705b10)
> dblib.c:718:dbloginfree(0x97057f0)
> dblib.c:1442:dbexit(void)
> dblib.c:303:dblib_release_tds_ctx(1)
>
>
>
> shiqiang.yan
> 2009-02-21
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 

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