Re: PHP page loading infinitely...

Here you go,

......
......
......
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1541:set current_results to cursor->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
        colname = acc_id (5 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:3294:adjust_character_column_size:
        Server charset: UCS-2LE
        Server column_size: 900
        Client charset: UTF-8
        Client column_size: 1800
token.c:1490:tds7_get_data_info:
        colname = acc_name (7 bytes)
        type = 39 (varchar)
        server's type = 231 (x UCS-2 varchar)
        column_varint_size = 2
        column_size = 1800 (900 on server)
token.c:1555:setting up column 2
token.c:1490:tds7_get_data_info:
        colname = acc_group (8 bytes)
        type = 38 (integer-null)
        server's type = 38 (integer-null)
        column_varint_size = 1
        column_size = 4 (4 on server)
token.c:1555:setting up column 3
token.c:1490:tds7_get_data_info:
        colname = acc_order (8 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)
token.c:1555:setting up column 4
token.c:1490:tds7_get_data_info:
        colname = rowstat (7 bytes)
        type = 56 (int)
        server's type = 56 (int)
        column_varint_size = 0
        column_size = 4 (4 on server)

So it stops after fetching the table metadata. I have no problem when
using TSQL or iSQL, this only happens when I use PHP...

Cheers,
Foo



On Fri, Aug 7, 2009 at 5:41 AM, James K. Lowden<[email protected]> wrote:
> foo wrote:
>>
>>
>> strace shows that the table columns are processed properly, somehow
>> the script always hangs right before it process the table records
>
> A TDSDUMP log would provide more information.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>