Skip to Content.
Sympa Menu

freetds - Re: [freetds] help about freetds and php

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Robert Gonzalez <robert AT robert-gonzalez.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] help about freetds and php
  • Date: Sat, 21 Feb 2009 08:49:44 -0700

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 <shiqiang.yan AT gmail.com>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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--

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




Archive powered by MHonArc 2.6.24.

Top of Page