Re: PHP page loading infinitely...
foo <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Thanks, after I changed the TDS_Version property from 7.0 to 8.0 and it started working... Cheers, Foo On Fri, Aug 7, 2009 at 9:51 AM, foo<[email protected]> wrote: > 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 >> >