473,322 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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_oci8.dll and extension=php_oracle.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
Jul 17 '05 #1
3 2906
t_**********@hotmail.com (TK) wrote in message news:<37**************************@posting.google. 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_oci8.dll and extension=php_oracle.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
Jul 17 '05 #2
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
Jul 17 '05 #3
On 12 Aug 2004 08:37:53 -0700, t_**********@hotmail.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_oracle.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.dll 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.andyhsoftware.co.uk/space> Space: disk usage analysis tool
Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Rodrigo Daunaravicius | last post by:
I can't get this configuration working: cx_Oracle 4.0.1 Oracle 8.0.6 Python 2.3.3 Win NT4.0 SP6fc My first shot at the problem was just running the installation thingie pre-built for...
1
by: rawii | last post by:
I am running on a Sun box and am trying to install the perl tools to connect to Oracle. When I try to install the DBD::Oracle module, I get the following. Please help.. What does is mean and...
0
by: George | last post by:
cross posted to comp.database.oracle by mistake. I'm getting the infamous ora 12154 - TNS could not resolve connect identifier error. My computer is running windows 2000 pro in standalone mode...
0
by: baka | last post by:
Hello, Here i am having sample program to display selected data on the browser with Pager functionality of ADODB_Pager. If i include the NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; then the Date...
10
by: Ed Stevens | last post by:
A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled...
1
by: Marc Rondeau | last post by:
Hi every expert. I very need Help! I don't know what is wrong in my code. When i try to execute this code on my access , it give me give this weard error The stored proc have no parameters, i...
7
by: trpost | last post by:
I just started using the php adodb library for my Oracle transactions, but am running into a problem when there are 2 simultaneous requests going on at the same time. The nature of the php app...
2
by: pramodrepaka | last post by:
i'am working with the datareport without using dataenvironment i.e with the help of ADODB but i am not able to understand how to connect with oracle.please help me
1
by: perl | last post by:
I want use perl to connect oracle XE and download perl -5.8.8,DBI-1.56.tar.gz DBD-oracle-1.19.tar.gz.and then I install them,I don't know why I can't install them.except them,should I download other...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.