ID: 19213 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Adabas-D related Operating System: SuSE Linux 8.0 PHP Version: 4.2.2 New Comment:
Hi again, now we have converted to SAPDB 7.3.00.25 (working better) PHP 4.2.3 Apache 1.3.27 But one Error holds on. If i'm requesting the database the first time no Error occurs but when i'm closing the result window and start a new request within around 10seconds the following PHP Warning shows up in the Error log -----snip--------- [26-Oct-2002 11:28:03] PHP Warning: SQL error: [SAP AG][LIBSQLOD SO][SAP DB]Syntax error or access violation; -3014 POS(260) Invalid end of SQL statement., SQL state 37000 in SQLExecDirect in /www/kunden/reisenetz/web/show.phtml on line 153 -------snip------------- The results of the second request are ok. When i'm using ODBC_prepare following Warning comes up: odbc_execute() supplied argument is not a valid ODBC result resource The results are ok too. It looks as if the ODBC_Close($conn) dont't work It is the same Error as in ADABAS D 11 Hope that this will help. With best regards Albert Steckenborn Previous Comments: ------------------------------------------------------------------------ [2002-10-07 03:48:24] [EMAIL PROTECTED] hi, i'm changing now from ADABAS D to SAPDB. Meanwhile i'm thinking that this bug is a bug in the ADABAS ODBC Driver and not PHP related. I need one week more for the migration and then wee will see if it's ADABAS D or PHP related. The reason to migrate to SAPDB is that we can use the most of our sripts anymore and the support (for a free software)is much better. Some of the scripts that are running on ADABAS D with errors so that we have to create db-Procedures, are running on SAPDB without any errors. That's the reason that i'm shure we can close our bug with the migration. A lot of thanks to Kalowsky and everybody else for the help. I will post the result of the migration around the 20021020. With best regards Albert Steckenborn ------------------------------------------------------------------------ [2002-10-01 07:31:12] [EMAIL PROTECTED] i've got the same problem :( apache 1.3.26, php v4.2.3, adabas kernel 11.00.07 odbc library odbclib.a (filesize 629128bytes, from adabas v10. the new one from v11 fails if reading long data). compiled php with the following options: './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-adabas=/database/adabas/' '--without-odbc' '--with-gd=/usr' '--with-jpeg-dir=/usr/lib' '--with-png-dir=/usr/lib' '--with-ttf' '--enable-ftp' '--enable-magic-quotes' '--enable-trackvars' '--with-zlib-dir=/usr' ------------------------------------------------------------------------ [2002-09-08 14:47:27] [EMAIL PROTECTED] Hi, i'm using the Adabas D ODBC Driver. odbc.ini: DRIVER=/usr/local/adabas/lib/odbclib.so ------------------------------------------------------------------------ [2002-09-08 12:30:54] [EMAIL PROTECTED] What ODBC driver are you using? unixODBC, iODBC, ... ? ------------------------------------------------------------------------ [2002-09-05 13:12:24] [EMAIL PROTECTED] is configured with --enable-debug in php.ini error_reporting = E_ALL & ~E_NOTICE report_memleaks = On in the "ERROR Log" no Error Messages are shown. I'm getting grazy with this ------------------------------------------------------------------------ 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/19213 -- Edit this bug report at http://bugs.php.net/?id=19213&edit=1