Installing ADOdb to connect to Oracle 9i

**cjbj** · Jul 17 '05, 07:55 AM

Re: Installing ADOdb to connect to Oracle 9i

t_karlsson72@ho tmail.com (TK) wrote in message news:<3703226c. 0408120737.2dfc 0bf9@posting.go ogle.com>...[color=blue]
> 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[/color]

Check out some of the troubleshooting tips in

Page not found | Oracle

http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html

Try a simple OCI8 program before you add the complexity of the ADOdb
layer.

There are some other Oracle/PHP resources at

Page not found | Oracle

http://www.oracle.com/technology/tech/opensource/index.html

-- CJ

TK · Jul 17 '05, 07:56 AM

Re: Installing ADOdb to connect to Oracle 9i

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** · Jul 17 '05, 07:56 AM

Re: Installing ADOdb to connect to Oracle 9i

On 12 Aug 2004 08:37:53 -0700, t_karlsson72@ho tmail.com (TK) wrote:
[color=blue]
>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[/color]

Good.
[color=blue]
>and extension=php_o racle.dll[/color]

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).
[color=blue]
>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.[/color]

There's quite a lot more to it than that to get Oracle support running.
[color=blue]
> 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?[/color]

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 / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

Installing ADOdb to connect to Oracle 9i

Installing ADOdb to connect to Oracle 9i

Comment

Comment

Comment