RE: [PHP4BETA] ODBC to Oracle crashes the entire web-server(win32)

Lars, Openlink's ODBC drivers (www.openlinksw.com) will work with php, and should enforce proper cursor behavior onto the database. You can also use SQL92 syntax (including all the other join syntax) with our drivers. Best regards, Andrew ---------------------------------------------------- Andrew Hill Technical Support Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: Lars Mikkel Aas [mailto:lars.aas@norway.eu.net] Sent: Friday, May 12, 2000 7:57 AM To: Andreas Karajannis Cc: php4beta@lists.php.net Subject: Re: [PHP4BETA] ODBC to Oracle crashes the entire web-server(win32) At 13:02 12.05.00 +0200, you wrote: >Lars Mikkel Aas wrote: >> I run win2000, IIS with php4 RC2(ISAPI). I use ODBC to connect to my >> Oracle 8.1.5 database. >> I have tested to ODBC drivers: >> 1) Microsoft Oracle ODBC-driver >> 2) Oracle ODBC-driver >> There are some major problems with this: >> 1) The driver from Oracle dosen't work at all, and crashes the entire web-server >> 2) The microsoft driver, sometimes give me a result, but the web server goes down >> every time. I have tried all the CUSRSOR_TYPES, but the web server still goes down >> every time. >Can you please give more details - are there any error messages, does >the server crash or hang. It would be also helpful to have an ODBC >trace. If I use SQL_CUR_USE_ODBC the query executes successfully, and returns the resultset OK. But, after this the webserver stops responding. This machine is placed outside the building, and the sys-admin there reports that he has to start the w3svc service again. All other Cursor-settings causes this output: SQL error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set, SQL state S1C00 in SQLExecDirect in db_odbc.inc on line 47 My SQL that fails is: "select * from table1, table2" Both of these work just fine: "select * from table1" "select * from table2" --- Lars Mikkel Aas, Systems Engineer ---- KPNQwest Norway, Sandakerveien 64, Oslo ----- lars.aas@kpnqwest.no +47 22 09 29 64 -- PHP 4.0 Beta Mailing List <http://www.php.net/version4/> To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net For additional commands, e-mail: php4beta-help@lists.php.net To contact the list administrators, e-mail: php4beta-admin@lists.php.net