how do I put in the or die part. When I view the page it diplays the file up until it connects to the DB. I am trying to rule out everything that i can.
how do I put in the or die part. When I view the page it diplays the file up until it connects to the DB. I am trying to rule out everything that i can.
You probably need to put the "or die" in the function OCILogon(). It needs to go in the mysql_connect(.....) command line, like:
So I copied over a oci.dll file from the oracle directory to the c:\program files\php directory
renamed it php_oci.dll
and added extension=php_oci.dll in the php.ini file. Still nothing.
I re-installed php with the oci extension chosen this time to it added it for me. PHP would not start, I read somewhere that I need to have the Oracle 10.2 client librarys for OCILogin to work so I downloaded them and placed them into my ora92 folder. PHP starts with no errors, but still shows nothing after the OCIlogin. The or Die shows nothing.
james3302 wrote:I re-installed php with the oci extension chosen this time to it added it for me. PHP would not start, I read somewhere that I need to have the Oracle 10.2 client librarys for OCILogin to work so I downloaded them and placed them into my ora92 folder. PHP starts with no errors, but still shows nothing after the OCIlogin. The or Die shows nothing.
Ordinarily, if the "or die(...)" doesn't display the error and halt the execution, then the line that it's in didn't result in an error. That could mean that the error you're trying to trap either occurred earlier in the code, so it never reached that line, or it occurred somewhere after that line.
Edit: ...or your program control logic is such that no attempt was made to execute that line.
The reason I was not getting a result from the or die is because PHP did not recognize the ocilogon function. I finally for the oci8.dll working correctly. Is there anyway to see a more specific error as to why it cannot connect?
I have to change the SID to something different(I had to ask someone what it was after they got back from vacation) but now on some long queries Im getting
ORA-12170: TNS:Connect timeout occurredTuesday
when I try and connect to the DB in Ohio(im in GA BTW). Short queries to Ohio are no problem.