Installing ADOdb to connect to Oracle 9i

[TK]

I have a problem getting ADOdb working with Oracle 9i. Before I tried
to connect to Oracle, I successfully connected to an MS Access table
via a DSN, and looped through all the records in that table, so I am
pretty sure ADOdb is installed correctly, but I could be wrong. To
connect to Oracle 9i, I first go in and un-comment
extension=php_o ci8.dll and extension=php_o racle.dll in the php.ini
file, but when I do that, the CGI script always times out (even for a
script that only calls phpinfo(), which worked before I un-commented
the two lines). I am running this on a Windows 2003 Server with IIS6,
and I'm running the CGI binary (php.exe). All three DLLs
(php_adodb.dll and the two oracle DLLs) are located in the same
folder, so I assume I have all the paths set up correctly. I am new
to PHP, so I don't know where to even start trouble shooting this.
Can anyone suggest things to check? Can I have the wrong version of
DLLs or something like that?

Any help is much appreciated,

TK

[cjbj]

t_**********@ho tmail.com (TK) wrote in message news:<37******* *************** ****@posting.go ogle.com>...

I have a problem getting ADOdb working with Oracle 9i. Before I tried
to connect to Oracle, I successfully connected to an MS Access table
via a DSN, and looped through all the records in that table, so I am
pretty sure ADOdb is installed correctly, but I could be wrong. To
connect to Oracle 9i, I first go in and un-comment
extension=php_o ci8.dll and extension=php_o racle.dll in the php.ini
file, but when I do that, the CGI script always times out (even for a
script that only calls phpinfo(), which worked before I un-commented
the two lines). I am running this on a Windows 2003 Server with IIS6,
and I'm running the CGI binary (php.exe). All three DLLs
(php_adodb.dll and the two oracle DLLs) are located in the same
folder, so I assume I have all the paths set up correctly. I am new
to PHP, so I don't know where to even start trouble shooting this.
Can anyone suggest things to check? Can I have the wrong version of
DLLs or something like that?

Any help is much appreciated,

TK

Check out some of the troubleshooting tips in
http://www.oracle.com/technology/tec...oting_faq.html
Try a simple OCI8 program before you add the complexity of the ADOdb
layer.

There are some other Oracle/PHP resources at
http://www.oracle.com/technology/tec...rce/index.html

-- CJ

[TK]

Thanks for your suggestions. The thing is that not even a simple code
like:

<?php
phpinfo();
?>

works when I uncomment "extension=php_ oci8.dll". When I run that
code, I receive the CGI Timeout error after a while. I'll check out
the links you provided, but if you, or anyone else, have any other
ideas how to fix it, I'd appreciate the input. I didn't point out
that both the web server and the Oracle DB is on the local computer,
so any DB client components needed should be installed and configured.

Thanks,
TK

[Andy Hassall]

On 12 Aug 2004 08:37:53 -0700, t_**********@ho tmail.com (TK) wrote:

I have a problem getting ADOdb working with Oracle 9i. Before I tried
to connect to Oracle, I successfully connected to an MS Access table
via a DSN, and looped through all the records in that table, so I am
pretty sure ADOdb is installed correctly, but I could be wrong. To
connect to Oracle 9i, I first go in and un-comment
extension=php_ oci8.dll
Good.
and extension=php_o racle.dll
Bad. This is for the long-dead Oracle 7 interface. Ignore this DLL entirely,
do not use it! (Confusing from the name, but that's how it is).
in the php.ini
file, but when I do that, the CGI script always times out (even for a
script that only calls phpinfo(), which worked before I un-commented
the two lines). I am running this on a Windows 2003 Server with IIS6,
and I'm running the CGI binary (php.exe). All three DLLs
(php_adodb.d ll and the two oracle DLLs) are located in the same
folder, so I assume I have all the paths set up correctly.
There's quite a lot more to it than that to get Oracle support running.
I am new
to PHP, so I don't know where to even start trouble shooting this.
Can anyone suggest things to check? Can I have the wrong version of
DLLs or something like that?

Is the Oracle home accessible to the user that PHP is running as (Oracle 9i by
default installs with relatively tight permissions). Particularly the
$ORACLE_HOME/bin directory.

Did you install Oracle Call Interface when setting up Oracle?

Is $ORACLE_HOME/bin on the PATH environment variable as seen by PHP and the
web server?

--
Andy Hassall / <an**@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool