ID: 24125
Updated by: [EMAIL PROTECTED]
Reported By: michael at redboxcode dot com
-Status: Feedback
+Status: Open
Bug Type: ODBC related
Operating System: Win NT
PHP Version: 4.3.2
New Comment:
Private Mail received from user:
can you post this reply, or tell me how to retrieve my password?
-----------------
php db-9d ENTER SQLAllocEnv
HENV * 005B3A90
php db-9d EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x005B3A90 ( 0x00a61430)
php db-9d ENTER SQLAllocConnect
HENV 00A61430
HDBC * 005B3A94
php db-9d EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 00A61430
HDBC * 0x005B3A94 ( 0x00a614d8)
php db-9d ENTER SQLConnectW
HDBC 00A614D8
WCHAR * 0x00A615E0 [ -3] "mydata\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
php db-9d EXIT SQLConnectW with return code 0
(SQL_SUCCESS)
HDBC 00A614D8
WCHAR * 0x00A615E0 [ -3] "mydata\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7D8B70 [ -3] "******\ 0"
SWORD -3
php db-9d ENTER SQLAllocStmt
HDBC 00A614D8
HSTMT * 00B68088
php db-9d EXIT SQLAllocStmt with return code 0
(SQL_SUCCESS)
HDBC 00A614D8
HSTMT * 0x00B68088 ( 0x00a61a28)
php db-9d ENTER SQLGetInfoW
HDBC 00A614D8
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012F758
SWORD 4
SWORD * 0x0012F73C
php db-9d EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 00A614D8
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012F758
SWORD 4
SWORD * 0x0012F73C (4)
php db-9d ENTER SQLSetStmtOption
HSTMT 00A61A28
UWORD 6 <SQL_CURSOR_TYPE>
SQLLEN 2
php db-9d EXIT SQLSetStmtOption with return code 1
(SQL_SUCCESS_WITH_INFO)
HSTMT 00A61A28
UWORD 6 <SQL_CURSOR_TYPE>
SQLLEN 2
DIAG [01S02] [Microsoft][ODBC Microsoft Access Driver]Option value
changed (10)
php db-9d ENTER SQLExecDirect
HSTMT 00A61A28
UCHAR * 0x00B68040 [ -3] "select * from mytable
order by time_stamp;\ 0"
SDWORD -3
php db-9d EXIT SQLExecDirect with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UCHAR * 0x00B68040 [ -3] "select * from mytable
order by time_stamp;\ 0"
SDWORD -3
php db-9d ENTER SQLNumResultCols
HSTMT 00A61A28
SWORD * 0x00B68094
php db-9d EXIT SQLNumResultCols with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
SWORD * 0x00B68094 (3)
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 1
UWORD 1 <SQL_COLUMN_NAME>
PTR 0x00B680C8
SWORD 32
SWORD * 0x0012F738
SQLLEN * 0x00000000
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 1
UWORD 1 <SQL_COLUMN_NAME>
PTR 0x00B680C8
SWORD 32
SWORD * 0x0012F738 (2)
SQLLEN * 0x00000000
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 1
UWORD 2 <SQL_COLUMN_TYPE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x00B680F0
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 1
UWORD 2 <SQL_COLUMN_TYPE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x00B680F0 (4)
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 1
UWORD 6 <SQL_COLUMN_DISPLAY_SIZE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0012F730
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 1
UWORD 6 <SQL_COLUMN_DISPLAY_SIZE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0012F730 (11)
php db-9d ENTER SQLBindCol
HSTMT 00A61A28
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00B68A70
SQLLEN 12
SQLLEN * 0x00B680EC
php db-9d EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00B68A70
SQLLEN 12
SQLLEN * 0x00B680EC (0)
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 2
UWORD 1 <SQL_COLUMN_NAME>
PTR 0x00B680F4
SWORD 32
SWORD * 0x0012F738
SQLLEN * 0x00000000
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 2
UWORD 1 <SQL_COLUMN_NAME>
PTR 0x00B680F4
SWORD 32
SWORD * 0x0012F738 (4)
SQLLEN * 0x00000000
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 2
UWORD 2 <SQL_COLUMN_TYPE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x00B6811C
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 2
UWORD 2 <SQL_COLUMN_TYPE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x00B6811C (12)
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 2
UWORD 6 <SQL_COLUMN_DISPLAY_SIZE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0012F730
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 2
UWORD 6 <SQL_COLUMN_DISPLAY_SIZE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0012F730 (50)
php db-9d ENTER SQLBindCol
HSTMT 00A61A28
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x00B68168
SQLLEN 51
SQLLEN * 0x00B68118
php db-9d EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x00B68168
SQLLEN 51
SQLLEN * 0x00B68118 (0)
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 3
UWORD 1 <SQL_COLUMN_NAME>
PTR 0x00B68120
SWORD 32
SWORD * 0x0012F738
SQLLEN * 0x00000000
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 3
UWORD 1 <SQL_COLUMN_NAME>
PTR 0x00B68120
SWORD 32
SWORD * 0x0012F738 (10)
SQLLEN * 0x00000000
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 3
UWORD 2 <SQL_COLUMN_TYPE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x00B68148
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 3
UWORD 2 <SQL_COLUMN_TYPE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x00B68148 (12)
php db-9d ENTER SQLColAttributes
HSTMT 00A61A28
UWORD 3
UWORD 6 <SQL_COLUMN_DISPLAY_SIZE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0012F730
php db-9d EXIT SQLColAttributes with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 3
UWORD 6 <SQL_COLUMN_DISPLAY_SIZE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0012F730 (50)
php db-9d ENTER SQLBindCol
HSTMT 00A61A28
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x00B681B8
SQLLEN 51
SQLLEN * 0x00B68144
php db-9d EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x00B681B8
SQLLEN 51
SQLLEN * 0x00B68144 (0)
php db-9d ENTER SQLAllocStmt
HDBC 00A614D8
HSTMT * 00B68448
php db-9d EXIT SQLAllocStmt with return code 0
(SQL_SUCCESS)
HDBC 00A614D8
HSTMT * 0x00B68448 ( 0x00a61f20)
php db-9d ENTER SQLGetInfoW
HDBC 00A614D8
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012F758
SWORD 4
SWORD * 0x0012F73C
php db-9d EXIT SQLGetInfoW with return code 0
(SQL_SUCCESS)
HDBC 00A614D8
UWORD 8 <SQL_FETCH_DIRECTION>
PTR 0012F758
SWORD 4
SWORD * 0x0012F73C (4)
php db-9d ENTER SQLSetStmtOption
HSTMT 00A61F20
UWORD 6 <SQL_CURSOR_TYPE>
SQLLEN 2
php db-9d EXIT SQLSetStmtOption with return code 1
(SQL_SUCCESS_WITH_INFO)
HSTMT 00A61F20
UWORD 6 <SQL_CURSOR_TYPE>
SQLLEN 2
DIAG [01S02] [Microsoft][ODBC Microsoft Access Driver]Option value
changed (10)
php db-9d ENTER SQLExecDirect
HSTMT 00A61F20
UCHAR * 0x00B683E0 [ -3] "insert into mytable
(name,time_stamp) values ('Michael','June 30 9:04:05');\ 0"
SDWORD -3
php db-9d EXIT SQLExecDirect with return code 0
(SQL_SUCCESS)
HSTMT 00A61F20
UCHAR * 0x00B683E0 [ -3] "insert into mytable
(name,time_stamp) values ('Michael','June 30 9:04:05');\ 0"
SDWORD -3
php db-9d ENTER SQLNumResultCols
HSTMT 00A61F20
SWORD * 0x00B68454
php db-9d EXIT SQLNumResultCols with return code 0
(SQL_SUCCESS)
HSTMT 00A61F20
SWORD * 0x00B68454 (0)
php db-9d ENTER SQLFreeStmt
HSTMT 00A61A28
UWORD 1 <SQL_DROP>
php db-9d EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 00A61A28
UWORD 1 <SQL_DROP>
php db-9d ENTER SQLFreeStmt
HSTMT 00A61F20
UWORD 1 <SQL_DROP>
php db-9d EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 00A61F20
UWORD 1 <SQL_DROP>
Previous Comments:
------------------------------------------------------------------------
[2003-06-25 15:05:15] [EMAIL PROTECTED]
Please turn on SQL Logging in your ODBC Administrator and post the
appropriate portions to this bug... aka from the first initial connect
to the last ODBC command for the script. Please note you MAY need to
delete the unique identifing material in the script (aka a
username/password).
------------------------------------------------------------------------
[2003-06-17 20:46:45] michael at redboxcode dot com
I've upgraded my development machine to 4.3.2 and the behavior still
exist.
------------------------------------------------------------------------
[2003-06-16 08:30:06] [EMAIL PROTECTED]
Please update to PHP 4.3.2 first.
------------------------------------------------------------------------
[2003-06-16 07:49:42] michael at redboxcode dot com
please note: I noticed that I am actually on version 4.3.1
Windows NT localhost 4.0 build 1381
inserting a record then reading the database works in this code
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
// First insert a record into the database
$sql_command = "insert into mytable (name,time_stamp) values
('Michael','".date("F j G:i:s")."');";
$result = odbc_exec( $connect_id, $sql_command );
echo $result." = ".$sql_command."\n";
// this will work correctly
?>
reading the database and THEN inserting the records does NOT work in
this code.
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
// first read the table
$sql_command = "select * from mytable order by time_stamp;";
$rsDetail = odbc_exec($connect_id, $sql_command);
// Now insert a record into the database
$sql_command = "insert into mytable (name,time_stamp) values
('Michael','".date("F j G:i:s")."');";
$result = odbc_exec( $connect_id, $sql_command );
// The command returns a valid results, but the record is NOT in the
database
?>
------------------------------------------------------------------------
[2003-06-12 05:44:39] [EMAIL PROTECTED]
Maybe I didn't stress enough the word SHORT example script..? :)
Can you please make this ONE file and max. 15 lines.
No HTML either, please.
------------------------------------------------------------------------
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/24125
--
Edit this bug report at http://bugs.php.net/?id=24125&edit=1
