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