ID:               20203
 User updated by:  [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
-Status:           Feedback
+Status:           Open
 Bug Type:         ODBC related
 Operating System: sparc solaris 2.8 and 2.6
 PHP Version:      4.2.3
 New Comment:

How do I activate the SQL log ??
(is it on the PC running MSSQL or on the sun machine ?)
Best regards 
Christos :)


Previous Comments:
------------------------------------------------------------------------

[2002-11-02 14:20:10] [EMAIL PROTECTED]

I'd still appriciate the SQL Log :)

------------------------------------------------------------------------

[2002-11-02 07:26:43] [EMAIL PROTECTED]

at /usr/pkg/php/php4-200210311500/ext/odbc/php_odbc.c:1274
1274            convert_to_string_ex(pv_query);
(gdb) n
1277            result = (odbc_result *)emalloc(sizeof(odbc_result));
(gdb) display result
1: result = (odbc_result *) 0x1b4a88
(gdb) display result.stmt
2: result.stmt = 0x1b9da8
(gdb) display /s result.stmt
3: x/s result.stmt  0x1b9da8:    "select * from kan_keim"

At this point the query statment is correct
But just before producing the fault is the following :

1305                            if (SQLSetStmtOption(result->stmt,
SQL_CURSOR_TY
PE, SQL_CURSOR_DYNAMIC)
5: /u rc = 16
4: rc = 16
3: x/s result.stmt  0x1c5148:    ""
2: result.stmt = 0x1c5148
1: result = (odbc_result *) 0x1b9dd8
(gdb) s

Program received signal SIGSEGV, Segmentation fault.
0xfeff55dc in SQLExtendedFetch () from
/usr/local/odbc/lib/sql_st_lt.so

I hope this helps you
Best regards 
Christos

------------------------------------------------------------------------

[2002-11-01 09:32:49] [EMAIL PROTECTED]

display query
display result->stmt

------------------------------------------------------------------------

[2002-11-01 06:16:39] [EMAIL PROTECTED]

Please i am not too familiar with gdb can you tell me how
I can print query and result->stmt variables in step #10 ?
Bets regards
Christos

------------------------------------------------------------------------

[2002-10-31 19:45:27] [EMAIL PROTECTED]

Also can you please turn on SQL Logging so we can see which steps are
being processed.  From the looks of it the SQLExtendedFetch is catching
an error condition or possibly a need to re-allocate data and refetch
furth of data. 


I find it hard to believe that the odbc_exect (a very basic part of any
DB layer) isn't working with MSSQL.  What are the types of data you're
trying to extract?

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/20203

-- 
Edit this bug report at http://bugs.php.net/?id=20203&edit=1

Reply via email to